Question: Fre Project 3: Data Modeling and Normalization Mi Pr Project 3: Data Modeling and Normalization Overview The task in this project is to design a
Fre Project 3: Data Modeling and Normalization Mi Pr Project 3: Data Modeling and Normalization Overview 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
