DBST 651 9040 - Fall 2014

MIDTERM PART II



Name:                    			Date:

Question 1:
The table shown below lists dentist-patient appointment data.  A patient is given an appointment at a specific time and date with a dentist located at a particular surgery.  On each day of patient appointments, a dentist is allocated to a specific surgery for that day.

StaffNo	Dentist Name	PatNo	PatName	Appointment Date & Time	SurgeryNo
S1011
S1011
S1024
S1024
S1032
S1032	James Bond
James Bond
Andrew Joe
Andrew Joe
Kevin King
Kevin King	P100
P105
P108
P108
P107
P110	Kim Su 
Jenny Gold
Ian Chappell
Ian Chappell
John Spooner
Frank Holey	1/9/05 10.00
1/9/05 12.00
1/9/05 10.00
2/7/05 14.00
2/7/05 16.30
2/7/05 18.00	S10
S15
S10
S10
S15
S13


Evaluate if the table shown above is normalized, if not describe and illustrate the process of normalizing the table shown above to third normal form.  Show your work in table format along with step by step explanations of how you got from to 1NF, 2NF, and 3NF. State any assumptions you make about the data shown in this table.(20 Points)

Question 2: 
Please provide answers to problems 10 through 16 in Chapter 3 of Coronel book after reading the problem. (Page 99-100)(15 Points)

Question 3:
Please provide answers to Questions (located under the Review Question in our textbook)  7-9 in chapter 5 of Coronel book after reading the problem. (Page 172)(15 Points)