Database

A collection of data stored in a computer system

Metadata

Data about data: Metadata is used in database management to help data analysts interpret the contents of the data within the database

Managing data with metadata

Relational database

A database that contains a series of related tables that can be connected via their relationships

Primary key

• Used to ensure data in a specific column is unique
• Uniquely identifies a record in a relational database table
• Only one primary key is allowed in a table
• Cannot contain null or blank values

Foreign key

• A column or group of columns in a relational database table that provides a link between the data in two tables
• Refers to the field in a table that's the primary key of another table
• More than one foreign key is allowed to exist in a table