Suppose that you need to create two-table database to record information for a DVD rental kiosk. The following information needs to be recorded.
For all movies: Movie number, title, category, rental rate, and whether or not it is available for rent; for all rented movies, the customer who rented the movie and the due date will also need to be recorded.
For all customers: Customer number, name, address, city, state, ZIP code, and phone number.
Create a preliminary design (use Figure 12-14 in the book for reference if needed) for a possible two-table database for this scenario (Movie table and Customer table), locating the fields in the most appropriate tables and having a minimum of redundancy.