Create a database design, Create a database design

Create a database design

Assignment Help Database Management System

Reference no: EM13318893

Instructions: Create a database design (schema) based on the following problem description. You need to list the tables, the fields, the primary key of each table, and all foreign keys. You will probably want to draw this on paper, though there are free tools to create diagrams.
Sample domain description for a movie database
A DVD collection contains many movies. Each movie is in one or more genre. Each movie has 1 or more actors in it. Each actor can be in multiple movies. Each movie has a title and an MPAA rating. Each actor has a name, gender, and birthday. Assume that the DVD collection does not contain multiple copies of the same movie.
Instructions: Based on feedback from Homework 1, make corrections to your database design (schema) based on the following problem description. You need to list the tables, the fields and datatypes, the primary key of each table, and all foreign keys. You will probably want to draw this on paper, though there are free tools to create diagrams. Note the addition of datatypes.

You may upload your results to Canvas or turn it in on paper.

Sample domain description for a movie database

A DVD collection contains many movies. Each movie is in one or more genre. Each movie has 1 or more actors in it. Each actor can be in multiple movies. Each movie has a title and an MPAA rating. Each actor has a name, gender, and birthday. Assume that the DVD collection does not contain multiple copies of the same movie

Reference no: EM13318893

Questions Cloud

Find how much energy is transferred to each eardrum : At a rock concert, the sound intensity 1.0m in front of the bank of loudspeakers is 0.10W/m^2. How much energy is transferred to each eardrum in one second

Develop a shaft sinking and lining strategy : Ppurpose of the exercise is for students to develop a shaft sinking and lining strategy for the site and

Find the normal force acting on the pivot point : Suppose a 34-kg child sits 1.24 m to the left of center on a seesaw of length, L= 3.74 m, pivoted in the middle. Find the normal force acting on the pivot point

What is the area of the leaf in square meters : Gold, which has a mass of 19.32 g for each cubic centimeter of volume, is the most ductile metal and can be pressed into a thin leaf or drawn out into a long fiber. what is the area of the leaf in square meters

Create a database design : Create a database design (schema) based on the following problem description.

Find the area of contact between each tire and the ground : A person who weighs 616 N is riding a 108-N mountain bike. find the area of contact between each tire and the ground

Use a rounded square to list likely future effects of system : Use a rounded square to list likely future effects of the system

What mass of gold is needed to make the new model : A major motor company displays a die-cast model of its first automobile, made from 5.14 kg of iron. What mass of gold is needed to make the new model

What is the smallest number of whole bricks : A solid concrete block weighs 250 N and is resting on the ground. Its dimensions are 0.400 m x 0.190 m x 0.0880 m. What is the smallest number of whole bricks

User Account

All Pages