Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
An employee may take one exam; an exam is taken by one employee. A patient makes many appointments; an appointment is made by one patient.
An employee may take one exam; an exam is taken by one employee. A patient makes many appointments; an appointment is made by one patient. A delivery is made by one vehicle; a vehicle may make many deliveries. A book may be written by many authors; an author writes many books. Write the answers on the page itself. For the following partial ERDs, using the business rules as given, do the following for each one: put in an appropriate Primary Key PK put in a Foreign Key FK; if necessary ensure you indicate it as such! put in the relationship name both sides! in the correct place put in maximum cardinality put in one additional attribute your choice, but it must make sense
An employee may take one exam; an exam is taken by one employee.
A patient makes many appointments; an appointment is made by one patient.
A delivery is made by one vehicle; a vehicle may make many deliveries.
A book may be written by many authors; an author writes many books.
Write the answers on the page itself. For the following partial ERDs, using the business rules as given, do the following for each one:
put in an appropriate Primary Key PK
put in a Foreign Key FK; if necessary ensure you indicate it as such!
put in the relationship name both sides! in the correct place
put in maximum cardinality
put in one additional attribute your choice, but it must make sense
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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