Analyze the entities - relationships between these entities

Assignment Help Database Management System

Reference no: EM13973592

Comment: Following the instructions of the Flix2You problem, I need to complete:

Problem Instructions

Flix2You is looking for a company to help them design a solution that meets the requirements they have set forth. As a team and aided by course materials, course content, and quality external resources, you need to create a proposal to meet the requirements of Flix2You. Keep in mind; your organization is not the only one being solicited for this contract.

"Organization of Data"

The database that drives the Flix2You website is a generic e-commerce database that was purchased as "off-the-shelf" software and was then modified by a prior group of database consultants. The database currently works with the Flix2You website, but it is difficult to query and understand the data in the current database. When queries are run, it slows down the online system and often disrupts customer transactions.

Given the existing database schema, analyze the entities, relationships between these entities, and cardinalities of these relationships.

Determine what the structure will be that will hold your extracted dataset. Then, construct the corresponding ER Diagram for the new database design.

NOTE: The existing database schema can be found in the problem resources section of this document. Existing database analysis - Normalization/Denormalization Approaches

Create the tables in the new database. Several possible approaches to this solution exist

Normalized Approach: If your team offers this type of solution be sure your design is in 3rd Normal Form. Once all the tables are in 3rd Normal Form, explain why they are in the 3rd Normal Form and develop and document the SQL necessary to create at least 3 of the related tables in the new database structure. In addition to creating the tables, use SQL to populate these tables with sample data.

Denormalized Approach or Alternative Approaches: Any other possible solution will require at a minimum of 2 tables developed, and included the SQL necessary to create these tables. In addition to creating the tables, use SQL to populate these tables with sample data. Do Nothing: Although this sounds extreme, is there a way to keep things as they are and improve the situation. (least recommended).

Please, for the ER diagrams use Microsoft Visio.

Reference no: EM13973592

Questions Cloud

Can drinking benzene-contaminated water hurt my liver : Can drinking benzene-contaminated water hurt my liver? Can drinking benzene-contaminated water hurt my kidneys?

Compare the characteristics in the two cases : Review and discuss the other case (assigned to the other students) and read those students' analyses. Compare the characteristics in the two cases and the analyses

Find velocity with which projectile exits from block : A 0.155 kg projectile is fired with a velocity of +702 m/s at a 1.94 kg wooden block that rests on a frictionless table. The velocity of the block, immediately after the projectile passes through it, is +42.9 m/s. Calculate the velocity with whic..

Research paper for malaria in africa : Students will be required to write an8-10 page paper (excluding title and reference pages) utilizing a minimum of 12 scholarly sources using APA style (6thEdition) formatting.

Analyze the entities - relationships between these entities : Develop and document the SQL necessary to create at least 3 of the related tables in the new database structure and create the tables in the new database.

Calculate velocity with which projectile exits from block : A 0.161 kg projectile is fired with a velocity of +700 m/s at a 1.94 kg wooden block that rests on a frictionless table. The velocity of the block, immediately after the projectile passes through it, is +39.6 m/s. Calculate the velocity with whic..

Recognize the elements and correct use of a thesis statement : Recognize the elements and correct use of a thesis statement. Recognize the use of summary, paraphrasing, and quotation to communicate the main points of a text. Analyze the rhetorical strategies of ethos, pathos, logos in writing samples and for inc..

Pre-production stage of filmmaking : Not all composers are able to (or want to) be present in the "pre-production" stage of filmmaking. What are some reasons they might (or might not) be part of the filmmaking process at this stage?

What percent of original energy is left after collision : A 0.23 kg billiard ball that is moving at 2.6 m/s strikes the bumper of a pool table and bounces straight back at 2.3 m/s. The collision lasts 0.01 s. What percent of the original energy is left after the collision?

User Account

All Pages