This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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.
- Spring '10