Data Modeling

Siper

Homework5S18.docx

Home >Computer Science homework help >Data Modeling

Customer

Number

Name

Address

Date

Number_of_rentals

Bonus

TAPE

Code

Purchase_date

Times_rented

C_Number

M_Number

MOVIE

Number

Title

Year

Type

Critic_rating

Nominations

Awards_won

D_Number

DIRECTOR

Name

Number

Year_of_birth

Year_of_death

STAR

Number

Name

Birthplace

Year_of_birth

Year_of_death

PLAYED_IN

S_number

M_number

Role

Using MySQL workbench to create a database with six tables. You need to set up primary key and foreign key each table. Make two lines of contents for each table. Using forward engineering to forward it the MySQL server. The export as a SQL file. You then submit this SQL file to Blackboard.

Customer

Number

Name

Address

Date

Number_of_rentals

Bonus

TAPE

Code

Purchase_date

Times_rented

Number

M_Number

MOVIE

Number

Title

Year

Type

Critic_rating

Nominations

Awards_won

D_Number

DIRECTOR

Name

Number

Year_of_birth

Year_of_death

STAR

Number

Name

Birthplace

Year_of_birth

Year_of_death

PLAYED_IN

S_number

M_number

Role

Customer

Number Name Address Date Number_of_rentals Bonus

TAPE

Code Purchase_date Times_rented C_Number M_Number

MOVIE

Number Title Year Type Critic_rating Nominations Awards_won D_Number

DIRECTOR

Name Number Year_of_birth Year_of_death

STAR

Number Name Birthplace Year_of_birth Year_of_death

PLAYED_IN

S_number M_number Role