4.10

Functional Dependence

A relationship where a value in one column depends on a value in another column.

Primary Key

A unique identifier for each row in a database table.

Composite Primary Key

A primary key made up of two or more columns.

Second Normal Form (2NF)

A database design that requires non-key columns to fully depend on the whole primary key.

Third Normal Form (3NF)

A database design that requires that all columns depend only on the primary key and not on other non-key columns.

Normalization

The process of organizing data in a database to reduce redundancy and improve data integrity.

Duplicate Rows

Rows in a database that are identical to each other; not allowed in a well-structured table.

Unique Values in Primary Key Column

In a table, each primary key value must appear in exactly one row.

Non-Key Column

A column in a database table that does not make up part of the primary key.

Database Management

The practice of storing, retrieving, and managing data in a database system.