Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 12c SQL

Authors: Joan Casteel

3rd edition

1305251032, 978-1305251038

More Books

Students also viewed these Databases questions

Question

Which supplier did the company purchase the most from?

Answered: 1 week ago

Question

Would management want these numbers to be higher or lower?

Answered: 1 week ago

Question

What do you consider abnormally high? Are these suspicious?

Answered: 1 week ago