Available under Creative Commons-ShareAlike 4.0 International License.
- A candidate key is selected by the designer to uniquely identify tuples in a table. It must not be null.
- A key is chosen by the database designer to be used as an identifying mechanism for the whole entity set. This is referred to as the primary key. This key is indicated by underlining the attribute in the ER model.
- For example Employee(EID, First Name, Last Name, SIN, Address, Phone, BirthDate, Salary, DepartmentID) -EID is the Primary key.
- 1662 reads