Questions and Answers
What is the primary key in a relational database?
A key that uniquely identifies each record in a table
What is the purpose of normalization in database design?
To minimize redundancy and prevent anomalies
What is a foreign key in a relational database?
A field in a table that matches the primary key of another table
In relational database design, what does the term 'composite key' refer to?
Signup and view all the answers
What is the purpose of integrity constraints in a relational database?
Signup and view all the answers