Database Normalization: 1NF, 2NF, and 3NF Quiz

Each row in the table must be unique, meaning there are no duplicate rows.

Adding an order ID as a primary key helps solve the problem of identical rows in a database.

The database must meet the requirements of First Normal Form (1NF).

A key that can uniquely identify each row in a table. It's like a special code for each entry.

Creating a separate table for order items, ensuring each cell contains a single value.

All non-prime attributes must be fully functionally dependent on the candidate key.

A set of attributes that can uniquely identify a tuple (row) in a table, except for the primary key.

To uniquely identify any record or row of data within a table.

A key used to reference the primary key of another table. It's like a link between different tables.

A non-prime attribute's dependency on another non-prime attribute. It's a complex relationship.

A key that uniquely identifies one and only one instance of an entity in a database. It's like the unique ID for each entry.

In a relational database, the primary key is the most suitable key for uniquely identifying any record or row of data from a table.

Partial dependency represents a situation where a non-prime attribute (Course Fee) is only dependent on the primary key to determine its value.

Candidate keys are as strong as the primary key and can uniquely identify a tuple (row) in a relation. They are like alternative keys that are equally effective.

In a relational database, primary keys are used to uniquely identify any record or row of data from a table.

Foreign keys are used to point to the primary key of another table in a relational database. They act as a bridge between tables.