Database Concepts Flashcards

Front

Entity in a database

Back

An object or thing that can have data stored about it.

Front

Primary key

Back

A unique identifier for each record in a table.

Front

Multiple primary keys in a table

Back

False; a table can only have one primary key.

Front

Purpose of a foreign key

Back

To create a link between two tables.

Front

Normalization

Back

It reduces data redundancy and improves data integrity.

Front

Composite key

Back

A primary key composed of two or more columns.

Front

SQL command to create a table

Back

CREATE TABLE

Front

Importance of data types in table design

Back

Data types specify the kind of data that can be stored and affect storage requirements.

Front

ERD

Back

An Entity-Relationship Diagram that visually represents entities and their relationships.