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
- Fall '10
- Database normalization, Simon & Schuster, Free Press, Ballantyne, Green Gables, functional dependency principles