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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!