Consider the following table in a relational database. Last Name Rank Room Shift Smith Manager 234 Morning Jones Custodian 33 Afternoon Smith Custodian 33 Evening Doe Clerical 222 Morning According to...


Consider the following table in a relational database.
Last Name Rank Room Shift
Smith Manager 234 Morning
Jones Custodian 33 Afternoon
Smith Custodian 33 Evening
Doe Clerical 222 Morning
According to the data shown in the table, which of the following could be candidate keys of the table?
a) {Last Name}
b) {Room}
c) {Shift}
d) {Rank, Room}
e) {Room, Shift}



Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here