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
- Spring '10
- Foreign key, Candidate key, Database normalization, Tony Smith Helen Pearson Helen Pearson Robin Pleavin