Problems with Repeating Sections
RentalForm(TransID, RentDate, CustomerID, Phone, Name, Address, City, State, ZipCode,
(VideoID, Copy#, Title, Rent ) )
TransID RentDate CustomerID LastName Phone Address VideoID Copy# Title Rent
1 4/18/95 3 Washington 502-777-7575 95 Easy Street 1 2 2001: A Space Odyssey $1.50
1 4/18/95 3 Washington 502-777-7575 95 Easy Street 6 3 Clockwork Orange $1.50
2 4/30/95 7 Lasater 615-888-4474 67 S. Ray Drive 8 1 Hopscotch $1.50
2 4/30/95 7 Lasater 615-888-4474 67 S. Ray Drive 2 1 Apocalypse Now $2.00
2 4/30/95 7 Lasater 615-888-4474 67 S. Ray Drive 6 1 Clockwork Orange $1.50
3 4/18/95 8 Jones 615-452-1162 867 Lakeside Drive 9 1 Luggage Of The Gods $2.50
3 4/18/95 8 Jones 615-452-1162 867 Lakeside Drive 15 1 Fabulous Baker Boys $2.00
3 4/18/95 8 Jones 615-452-1162 867 Lakeside Drive 4 1 Boy And His Dog $2.50
4 4/18/95 3 Washington 502-777-7575 95 Easy Street 3 1 Blues Brothers $2.00
4 4/18/95 3 Washington 502-777-7575 95 Easy Street 8 1 Hopscotch $1.50
4 4/18/95 3 Washington 502-777-7575 95 Easy Street 13 1 Surf Nazis Must Die $2.50
4 4/18/95 3 Washington 502-777-7575 95 Easy Street 17 1 Witches of Eastwick $2.00
Storing data in this raw form would not work very well. For example, repeating sections will cause problems.
Note the duplication of data.
Also, what if a customer has not yet checked out a movie--where do we store that customer’s data?