Database Management System20765 marksRelational Model Constraints and Relational Database Schemas
Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key?
Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key? [5]
A primary key is an attribute (or a set of attributes) that uniquely identifies each tuple (row) in a relation (table). It must satisfy two properties: - Uniqueness: No two rows can have the same primary key value. - Not Null: The primary key attribute cannot be NULL. Eid Name Salary Address ----...