There is a report table for overdue DVD rentals. The store has multiple copies of the same DVD (they are all numbered to be identified). How can I normalize this data to meet 3NF requirements?
Look at objects--actors:
1. Customer 2. Title 3. Physical Medium (DVD, the thing you take home when borrowing) 4. Artist 5. Rental (act of renting = transaction)
Media.Statustracks availability of a medium (DVD).