First Normal Form
RentalForm(TransID, RentDate, CustomerID, Phone, Name, Address, City, State, ZipCode,
(VideoID, Copy#, Title, Rent ) )
RentalForm2(TransID, RentDate, CustomerID, Phone, Name, Address, City, State, ZipCode)
RentalLine(TransID, VideoID, Copy#, Title, Rent )
Remove repeating sections
- Split into two tables
- Bring key from main and repeating section
RentalLine(TransID, VideoID, Copy#, . . .)
- Each transaction can have many videos (key VideoID)
- Each video can be rented on many transactions (key TransID)
- For each TransID and VideoID, only one Copy# (no key on Copy#)