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.