Assignment
This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ability to reach third normal form for your design, your mastery of how to "break" fields in to sub-fields to access data individually, and your ability to reach the desired goals with the fewest number of fields (without being SO clever that easily understanding your system is an issue). Your completed project must be word-processed and follow this format for the table notation. Table name bolded. Names of the fields in each table with the primary key field(s) underlined. All foreign keys indicating the table name they link to. Do not provide any other details, such as, field length or type.
Correct example: Customer (customerid, fname, lname, salespersonid Salesperson table) Your system should be able to provide the following information:
- Customer bio (name, address, phone, driver's license)
- Videos in the library
- Videos that are rented out
- Info on each video (format (VHS, Beta, DVD, BluRay), length, rental price, cost, rental time period, genre of video - comedy, action, quantity of categories unknown.)
- Who has what rented out
- How much money was taken in per day, week, month, year
- A customer's rental history and if they paid late fees on a rental
- How many times a video is rented in a specific time period
*** Make sure to list your business rules that dictate the assumptions you make during design.