What is the primary purpose of database normalization?
Normalization reduces redundancy and ensures data integrity by organizing fields and tables logically.
What does the First Normal Form (1NF) require?
1NF ensures that each column contains atomic values and each record is unique.
Which key uniquely identifies a record in a table?
A primary key is used to uniquely identify each record in a table.
What is a foreign key used for?
A foreign key establishes a relationship between two tables by referencing a primary key.
Which normal form removes partial dependencies?
Second Normal Form (2NF) removes partial dependencies from a table.
Which statement is true about denormalization?
Denormalization combines tables to reduce join operations but may introduce redundancy.
Loading Questions...
What is a composite key?
A composite key is made up of two or more fields used to uniquely identify a record.
What happens if a table lacks a primary key?
Without a primary key, records may not be uniquely identifiable, leading to data anomalies.
Which command is used to define a primary key in SQL?
The PRIMARY KEY constraint defines one or more columns as uniquely identifying each row.