The STAFF relation of a medical facility is shown below. Does it make sense to choose the attribute Last-Name as the primary key of this relation?
 

Transcribed Image Text:

Last-Name Kyger Dillard Shafiroff Sutton First-Name Renton Wendy Suzanne Jean Carson Anna-Christie Medical Assistant X-Ray Tech Receptionist Melissa Title Hayley X-Ray Tech X-Ray Tech Secretary Salary 28000 28000 16000 23000 28000 14000 Department Radiology Radiology General Office General Medicine Radiology General Office Last-Name Kyger Dillard Shafiroff Sutton First-Name Renton Wendy Suzanne Jean Carson Anna-Christie Medical Assistant X-Ray Tech Receptionist Melissa Title Hayley X-Ray Tech X-Ray Tech Secretary Salary 28000 28000 16000 23000 28000 14000 Department Radiology Radiology General Office General Medicine Radiology General Office

Answer rating: 100% (QA)

Although all the last names that exist in the table appear to be unique it would not be a ... View the full answer