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. In Tape table, set foreign key C_number with on update cascade, on delete set null. Set foreign key M_number with on update cascade and on delete cascade. Remember dont set customer number and movie number as required (not null) if you want to set them as null when needed. In Movie table, set the foreign key D_number with on update cascade, on delete set null In Played_In, set two foreign keys with on update cascade and on delete cascade. Add one row of data in each table.

Export the SQL file and submit to Blackboard

Cute Address Year of death Purchase ciate Narne Number_of_settels Year_of_th Code Tine yered Nuwber tonus --- Birth TAPE RENTED TO CUSTOMER Name IN STAR CONTAINS Nam IN 1 Numbe Role PLAYED N MOVE DIRECTED BY DIRECTOR Year or bath NE Awarcie_won Year of death (The Nominations Year Type Critics 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 M Role