Database and SQL Concepts

Front

Database

Back

An organized collection of data that allows for easy access, management, and updating.

Front

Table

Back

A structure within a database that stores data in rows and columns.

Front

Record

Back

A single row in a table, representing one complete set of data.

Front

Field

Back

A column in a table, representing one specific attribute of data.

Front

Primary Key

Back

A unique identifier for each record in a table.

Front

Foreign Key

Back

A field in one table that references the primary key in another table, creating a relationship between the tables.

Front

Relational Database

Back

A database structured to recognize relations among stored data using tables.

Front

Entity

Back

An object or thing in the database that is stored as a table (e.g., 'Customers' or 'Products').

Front

Attribute

Back

A property or characteristic of an entity (e.g., 'Name' or 'Price').

Front

SQL (Structured Query Language)

Back

A programming language used for managing and manipulating relational databases.