1 / 8

Assignment 6-1

Assignment 6-1. Schedule(staffNo, dentistName, patNo, patName, surgeryNo, Date, Time) Make assumptions: SurgeryNo is the surgery room number. Date and Time are two different attributes. No Appointment!

matthew-thornton
Download Presentation

Assignment 6-1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Assignment 6-1 Schedule(staffNo, dentistName, patNo, patName, surgeryNo, Date, Time) Make assumptions: SurgeryNo is the surgery room number. Date and Time are two different attributes. No Appointment! A dentist is allocated to a specific surgery room for each day. But a surgery room can be used by multiple dentists same day. A surgery room can have one surgery at a time. One surgery needs only one dentist. A patient is allowed to have more than one surgery a day.

  2. Assignment 6-1 dentistName ===> staffNo -0.5 staffNo ===> dentistName Yes patName ===> patNo -0.5 patNo ===> patName Yes

  3. Assignment 6-1 surgeryNo, Date ===> staffNo What does it mean? A surgery room is reserved for one dentist a day. -0.5 staffNo, Date ===> surgeryNo What does it mean? A dentist is allocated to a specific surgery room for each day. Yes!

  4. Assignment 6-1 patNo, Date ===> ALL What does it mean? A patient can have at most one surgery a day. Usually is true. Not a rule we want to make. -0.5

  5. Assignment 6-1 patNo, staffNo, Date ===> Time What does it mean? A patient can see one dentist once a day. -0.5 Can a patient have multiple appointments a day? Yes But must see different dentists.

  6. Assignment 6-1 patNo, staffNo ===> ALL What does it mean? A patient can see one dentist once. -0.5

  7. Assignment 6-1 Candidate keys: staffNo, Date, Time surgeryNo, Date, Time patNo, Date, Time Must have FDs: staffNo, Date, Time ===> All surgeryNo, Date, Time ===> All patNo, Date, Time ===> All

  8. Assignment 6-1 2. staffNo  dentistName patNo  patName staffNo, Date, Time  All patNo, Date, Time  All surgeryNo, Date, Time  All staffNo, Date  surgeryNo 3. staffNo, Date, Time (any one of the three ALL FDs) 4. patNo, Date, Time surgeryNo, Date, Time

More Related