Use the following information about a Video Rental business to guide your design:

- The store rents DVD videos to customers.

- Each rental has a due date and time.

- The store may have multiple copies of some videos.

- Videos have a title, category, studio name, director, producer, writers, year produced, version and actors.

- Customers can rent more than one video at a time, up to a limit of 10.

- Videos are purchased from suppliers, and may be available from more than one supplier.

- Customer service representatives serve customers, but we dont keep track of which customer is served by which customer service representatives.

- A program will be written to manage the events of new customers, updates of customer information, video queries, rentals, holds and returns, and management reports.

- A program will be written to allow customers to search the inventory to look for videos based on category, actors, year, directors, writers, or title. (So you could look for all comedies with Gene Wilder acting, produced before 1980.). Customers are also allowed to recommend DVDs that are not on stock.

- A program will be written to manage purchasing of new DVDs. The purchasing decisions are based on suppliers advertisements, customers recommendations, and the budget available.

Design Forms, Reports, Interface, and Dialogue for the video rental store for the events of video queries, rentals, holds and returns, DVD purchase, customer management and management report