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
This note was uploaded on 11/17/2011 for the course ITM 311 taught by Professor Harrisonmcknight during the Fall '10 term at Michigan State University.
- Fall '10