Codacoda
Back to Academy

relational database

Tables, Rows & Columns

A relational database organizes data into tables, where each table represents an entity type. Each row (record) is one instance of that entity, and each column (field) defines an attribute. CRUD operations — Create, Read, Update, Delete — are the four fundamental ways to interact with table data.

Use Cases

  • •Storing user profiles with consistent fields like name, email, and created date
  • •Managing product catalogs where each item shares the same attribute structure
  • •Tracking order records that can be inserted, queried, modified, or removed
  • •Building any application that needs persistent, structured data storage

Visualization

BEFOREusersidnameemail
Speed:1x
Empty 'users' table with columns: id, name, emailStep 1 / 6

Implementation

Output

Click "Run Code" to see output...