C-Assn2 - S15 S1024 Helen Pearson P108 Ian MacKay 9/12/2008...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
14.15 The table shown in Figure 14.19 lists sample dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located in a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. (c) Describe and illustrate the process of normalizing the table shown in Figure 14.19 to 3NF relations. Identify the primary, alternate, and foreign keys in your 3NF relations. staffNo dentistName patNo patName appointment surgeryNo         date                 time   S1011 Tony Smith P100 Gillian White 9/12/2008     10.00 S15 S1011 Tony Smith P105 Jill Bell 9/12/2008     12.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: S15 S1024 Helen Pearson P108 Ian MacKay 9/12/2008 10.00 S10 S1024 Helen Pearson P108 Ian MacKay 9/14/2008 14.00 S10 S1032 Robin Pleavin P105 Jill Bell 9/14/2008 16.30 S15 S1032 Robin Pleavin P110 John Walker 9/15/2008 18.00 S13 In 3NF, I removed the transitive dependency and removed the functional dependencies 3 by splitting into a new table. The transitive dependency that is left is the patientName that depend on the patientNo. This was split this into new table while creating a foreign key. The following will show the tables being rearranged and naming of the tables:...
View Full Document

This note was uploaded on 07/01/2010 for the course CS 3400 taught by Professor Profwhite during the Spring '10 term at Nova Southeastern University.

Page1 / 2

C-Assn2 - S15 S1024 Helen Pearson P108 Ian MacKay 9/12/2008...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online