First page Back Continue Last page Graphics
Third Normal Form
Formal Presentation
Example
- Consider the two relational schemas
- R1 = (cust-name, name, house-num, street, city, state)
- cust-num name, house-num, street, city, state
-
- R2 = (house-num, street, city, state, zip)
- house-num, street, city, state zip
- zip state
- Are these relations in 3NF?
Notes: