Question: define the database structure for a Movie database. Your structure should incorporate the discussions from class, and implement the principles of data normalization (up

define the database structure for a Movie database. Your structure should incorporate the discussions from   

define the database structure for a Movie database. Your structure should incorporate the discussions from class, and implement the principles of data normalization (up to 3rd normal form) as described in Chapter 10 and in class. Your database must track data for the following movie related information: movies actors, directors, producers characters genres reviews songs Minimum of 3 movies, however you do not need to overdue the rest of the information, for example, having one or two actors, reviews and songs for each movie will be sufficient. The goal of the assignment is developing the ability to structure a database before implementation. You will represent your structure with a basic diagrams done in Word or other word processing software and submitted as a PDF file. Your diagrams should be similar to the examples from class. You do not need to use the EER diagram tools in Workbench for this assignment. Your DB structure should show an understanding of the concepts presented in Chapter 10, up to and including normalizing a database to the 3rd normal form. Your tables must be properly structured with appropriate primary keys and foreign keys where required. Mary-to-Many relationships must be established using a linking table. Data should not be duplicated across different tables. No column should contain more than one value. All relationships between tables must be indicated with appropriate connections as in the example below and in the sample document given in the homework assignment.

Step by Step Solution

3.36 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

cannot see the image you sent me but I can still answer your question about the data structure for a ... View full answer

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!