RSS

Data Modeling

28 Mar

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.

 
Leave a comment

Posted by on March 28, 2018 in academic writing, Academic Writing

 

Tags:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

 
%d bloggers like this: