Using MySQL to create a database with six tables. You need to set up primary key andforeign key each table. Make two lines of contents for each table. In Tape table, set foreign key C_number with on update cascade, on delete set null. Set foreign keyM_number with on update cascade and on delete cascade. Remember don’t set customer number andmovie 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 nullIn Played_In, set two foreign keys with on update cascade and on delete cascade.Add one row of data in each table. CustomerNumberNameAddressNumber_of_rentals BonusDateТАРЕCodePurchase_dateTimes_rentedC_NumberM_NumberMOVIENumberTitleYearТуреCritic_rating Nominations Awards_won D_NumberDIRECTORNameNumberYear_of_birthYear_of_deathSTARNumberNameBirthplaceYear_of_birthYear_of_deathPLAYED_INS_numberM_numberRole DateAddressYear of_deathPurchase_doteNumber_of_rentalsNameYear of_ethCodeTimes_rentedNumberBonusBirthplaceTAPERENTED_TOCUSTOMERNameNumberSTARCONTAINSNameNNmberRolePLAYED INMOVIEDIRECTED_BYDIRECTORYear of birthNumberAwards wonYear of deathTleNominationsYearCritics ratingТуре

Select this option to generate a statement to drop each object before the statement that creates it.…

Answered: ed to set up primary key and foreign…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using MySQL 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.
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 don’t 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.