Question: List: The primary key for each relation The candidate keys (if any) for each relation The foreign keys (if any) for each relation The domain

List:

  • The primary key for each relation
  • The candidate keys (if any) for each relation
  • The foreign keys (if any) for each relation
  • The domain of each attribute
  • Two semantic constraints

  • Admission (admission-date, patient, supervisor, department, room-no)
  • Admission-Date

    Patient

    Supervisor

    Department

    Room-No

    08/01/2020

    12341234

    54546677

    EMM

    A123

    08/01/2020

    33334444

    54546677

    EMM

    A125

    07/31/2020

    77897788

    54546677

    EMM

    A125

    08/02/2020

    12341234

    77881234

    OPR

    B444

    08/02/2020

    33334444

    77881234

    OPR

    B555

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!