First Normal Form Problems (Data)
TransID RentDate CustID Phone LastName FirstName Address City State ZipCode
1 4/18/95 3 502-777-7575 Washington Elroy 95 Easy Street Smith's Grove KY 42171
2 4/30/95 7 615-888-4474 Lasater Les 67 S. Ray Drive Portland TN 37148
3 4/18/95 8 615-452-1162 Jones Charlie 867 Lakeside Drive Castalian Springs TN 37031
4 4/18/95 3 502-777-7575 Washington Elroy 95 Easy Street Smith's Grove KY 42171
TransID VideoID Copy# Title Rent
1 1 2 2001: A Space Odyssey $1.50
1 6 3 Clockwork Orange $1.50
2 2 1 Apocalypse Now $2.00
2 6 1 Clockwork Orange $1.50
3 9 1 Luggage Of The Gods $2.50
3 15 1 Fabulous Baker Boys $2.00
3 4 1 Boy And His Dog $2.50
4 3 1 Blues Brothers $2.00
4 13 1 Surf Nazis Must Die $2.50
4 17 1 Witches of Eastwick $2.00
1NF splits repeating groups
Still have problems
- Replication
- Hidden dependency:
- If a video has not been rented yet, then what is its title?