Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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?
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
Step by Step Solution
★★★★★
3.50 Rating (147 Votes )
There are 3 Steps involved in it
Step: 1
Although all the last names that exist in the table appear to be unique it would not be a ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting Information Systems
Authors: Marshall B. Romney, Paul J. Steinbart
13th edition
133428532, 978-0133428537
