The task in this project is to design a normalized database that could be used to collect and store information for a video rental outlet.
computer science
Description
The task in this project is to design a normalized database that could be used to collect and store information for a video rental outlet.
The database should be structured to support tasks such as: tracking rentals by title and by customer; producing reports, such as rentals due on a certain date; categorizing rentals by media type (e.g., Blu-Ray, DVD, Game).
The assignment does not require you to produce examples of the reports listed, but only that the database be correctly structured to allow the query and reporting features of a DBMS, such as Access, to work properly. You will need to collect information about several titles in each category, which can be done online, at your local video store, or from your personal media collection.
You will be given an initial, un-normalized field list of data items to be tracked, which you will normalize into the appropriate separate tables. The database students will prepare in this project is somewhat simplified in comparison to a real-world application. For example, only brief customer address information is included, to reduce the amount of data input required for the project.
We have also simplified the example in terms of structure; ignoring, for example, the complexities of a real-world video outlet, such as varying rental periods for different products. The initial field list does not include all of the appropriate key fields for the tables that will be created, so suitable key fields should be added to the tables as required.
This project is most easily completed using MS-Access; for a detailed discussion of the other options for
completing the Project, please see "Alternatives to MS Access" below.
