Assignment 2 1- A table containing dentist/patient appointment data

1 Pages259 Words497 Views

Added on 2019-09-16

About This Document

Assignment 2 1- Consider the following table which lists dentist/patient appointment data.

Assignment 2 1- A table containing dentist/patient appointment data

Added on 2019-09-16

Related Documents

Fall_2016 CSC342Assignment 21-Consider the following table which lists dentist/patient appointment data. A patient is given anappointment at a specific time and date with a dentist located at a particular surgery. On each dayof patient appointments, a dentist is allocated to a specific surgery for that day.Staff_NoDentist_NamePat_NoPat_NameAppointmentData TimeSurgent_NoS1011S1011S1024S1024S1032S1032Tony SmithTony SmithHelen PearsonHelen PearsonRobin PlevinRobin PlevinP100P105P108P108P105P110Gillian WhiteJill BellIan MackayIan MackayJill BellJohn Walker12-Sep-08 10.0012-Sep-08 12.0012-Sep-08 10.0014-Sep-08 14.0014-Sep-08 16.3015-Sep-08 18.00S15S15S10S10S15S13a)Describe and illustrate the process of normalizing the above table to 3NF. State any assumptions youmake about the data shown in this table.b)Identify the functional dependencies represented by the attributes show in the 3NF tables. 2-Suppose that a data warehouse consists of the three dimensions time, doctor, and patient, and the two measures count and charge, where charge is the fee that a doctor charges a patient for a visit.a)Draw a star schema diagram for the above data warehouse. 1

Assignment 2 1- A table containing dentist/patient appointment data_1

End of preview

Want to access all the pages? Upload your documents or become a member.