Validate the logical model using normalization

Assignment Help Database Management System

Reference no: EM13752349

Creation of logical database

Your Learning Team has been hired as database consultants for a start-up company that will stream movies over the Internet (similar to Hulu, Netflix, and others). The new organization requires one or more databases for Customer Information, Movie Information, and Supplier Information. At a minimum, the following attributes must be captured:

Customer: name, address, customer ID, credit card number and expiration, history of movies rented, "likes" (such as, genres, and movies the customer is interested in)

Movie: title, year, supplier ID (owner of movie), description of movie, statistics on movie rental frequency, rental cost

Suppler: ID, name, address, bank routing payment information

Create the documentation and databases for the following:

Logical design of the database(s)

Map the conceptual model to the logical model components.

Validate the logical model using normalization.

Validate the logical model integrity constraints.

Validate the logical model against user requirements.

Reference no: EM13752349

Questions Cloud

Discussion-integration of technology : Technology has changed the way we conduct business on a daily basis. A number of organizations have opted for integrating systems and sharing information with their counterparts.

Explain how you will modify the landing page and its element : Explain how you will modify the landing page and its elements. Examine the impact the modification of the page and its elements will have-or does have-on the statistics

Discuss major considerations about distribution environment : This week's reading discusses transport packaging. Discuss the major considerations about the distribution environment that must be understood before deciding upon the structural design of the package. Must be at least 250 words and APA format w/r..

Investigate and evaluate the deep cultural roots of artifact : Investigate and evaluate the deep cultural roots of your artifact. What historical roots allowed your artifact to come into being?

Validate the logical model using normalization : Your Learning Team has been hired as database consultants for a start-up company that will stream movies over the Internet (similar to Hulu, Netflix, and others). Validate the logical model using normalization

Design system environment to support the entire system : Design system environment to support the entire system. The system is to be deployed on the company's premises but securely connected to the Internet.

Explain computer-mediated communication : Do you find these tips to be helpful or do you think that they are too obvious and should be common sense? Were there any tips that made you disagree with the author? Which tips will you adapt into your computer-mediated communication?

Information under investor relations : Public companies must file a 10K form with the Securities and Exchange Commission (SEC) annually. Navigate to the Home Depot website and locate the most recent 10K filing. You can usually find this information under Investor Relations. Review the ..

Elements involved in evaluation of a transportation system : Explain the three key elements involved in evaluation of a transportation system's needs for training and simulated drills.

User Account

All Pages