Reply 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 a candidate key of the table?
(A) {Last Name}
(B) {Room}
(C) {Shift}
(D) {Room, Shift}

Home Modern › Forums › ISRO ›

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 a candidate key of the table?
(A) {Last Name}
(B) {Room}
(C) {Shift}
(D) {Room, Shift}

› Reply 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 a candidate key of the table?
(A) {Last Name}
(B) {Room}
(C) {Shift}
(D) {Room, Shift}