NormalizationExercise

NormalizationExercise - PATIENT relation: PATIENT (Patient...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Normalization Exercise Identify and Explain Which Normal Form, using Functional Dependency Principles 1. BOOK relation: Book No. Book Name Year Publisher 1073043 The Last of the Mohicans 1985 1076443 Ivanhoe 1963 Free Press 1034875 The Hobbit 1974 Ballantyne 1098744 Anne of Green Gables 1989 Using functional dependency principles, assess the normal form of BOOK. (circle one:) None 1NF 2NF 3NF Explanation: 2. Using functional dependency principles, assess the normal form of PATIENT.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: PATIENT relation: PATIENT (Patient ID , Patient Name, Doctor, Dependent) [Assume that each patient may have one or more Dependents] (circle one:) None 1NF 2NF 3NF Explanation: 3. Using functional dependency principles, assess the normal form of CUSTOMER. CUSTOMER relation: CUSTOMER (Cust ID , Order No , Cust Name, Cust Address, Order Type, Order Status) (circle one:) None 1NF 2NF 3NF Explanation:...
View Full Document

Ask a homework question - tutors are online