Create the corresponding relational data model

Assignment Help Database Management System
Reference no: EM13780258

Create the corresponding relational data model by implementing the database for myFlicks.com within the course's mySQL site, linked on the course's homepage within Blackboard. Be sure to populate your tables with dummy data, providing me with the SQL scripts used to create the tables and insert the data into the actual database within a Word document. You need only to have enough data so that your queries (explained below) can be processed and not a complete product or customer inventory.

For this project, you will also create at a minimum 10 important SELECT queries that you need for the day to day management and maintenance of the operation of the site to turn raw data into useful information. In other words, these should all be SELECT statements that myFlicks.com administration or the site itself would actually process to present data to the user or management. Run the queries against your database to ensure the results are correct. Justify why each of the queries you created are important to the application in a written report. Be sure that you make the best use of the data that you can.

I will look for at least two major areas in your implementation. (a) First, I will check the structure of the tables - has entity and referential integrity been enforced and does the structure of your relational database match the ER diagram you submitted as deliverable #2 (b) most importantly, do you have queries that support the transactions associated with myFlicks.com. Remember that I will be looking for and grading 10 queries, but at the same time, I grade on a difficulty scale. Points will be awarded based on complexity, meaning I am looking for aggregate information, joins, etc. and not just statements such as select * from users, etc. As an example, you may have 10 queries, but if one is a very simple and not very useful query, it may get only 2 points (each is worth 7 with the other points given to the database's integrity structure). Also, make sure no query or report produces a null output. I must see data in the output for all queries/reports. Remember, and I reiterate, grading for the queries/reports will be based on the complexity of the queries. Simple queries are allowed, but are awarded very few points.

Reference no: EM13780258

Questions Cloud

National food chains related problems : How can Whole Foods compete with the large national food chains (Publix, Safeway, Wal-Mart, etc.)?
How you would have used a different leadership approach : Visualize two different leadership scenarios that you witnessed directly, read about, or saw on television or in a more. Think throught how you would have used a different leadership approach for each one if you had been the leader
What issues regarding the livestock support theory of arson : What issues regarding the livestock support the theory of arson? Explain how the butane torch could have gotten into the field where the cows were
Connection between character personality and theory : Describe the connection between the character's personality and the theory used to explain it using relevant information such as direct quotes, descriptions of life events, examples of interpersonal behavior, and so on.
Create the corresponding relational data model : Create the corresponding relational data model by implementing the database for myFlicks.com within the course's mySQL site, linked on the course's homepage within Blackboard. Be sure to populate your tables with dummy data, providing me with the..
Use problem framing and cause-and-effect analysis : Write a report analyzing the organizational problem and the process for OIP. Problem statement: What exactly needs to be improved? Use problem framing and cause-and-effect analysis to develop a brief, preliminary problem statement. Note: You will exp..
Influences of social connections and technology : Evaluate the significance of social capital in the context of global citizenship and multicultural understanding
What legal options does frank oldburr have : What is Discrimina Inc.'s legal responsibility to provide health insurance to employees? What legal options does Frank Oldburr have to get himself covered with a health plan
Explain highest type of ownership estate in real property : What is the highest type of ownership estate in real property? If a contract ends in a dispute, and the parties want to have the matter resolved without going to court, which is the most common method for them to pursue

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd