DBST 651 9040 | MIDTERM PART II | Complete Solution

DBST 651 9040 – Fall 2015 

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.  State any assumptions you make about the data shown in this table. (20 Points)

Question 2:

Please provide answers Problems 10 through 16 in Chapter 3 of Coronel book 11e Pages 109.   (20 Points)

To avoid any confusion with the 10^th edition, the first question starts with:

10. For each table in the database, identify the primary key…

Question 3:

Please provide answers to the Review Questions 7-9 in chapter 5 of Coronel book 11e, page 182.  (10 Points)

To avoid any confusion with the 10^th edition, the first question starts with:

7. List all of the attributes of a movie