Question: Using phpMyAdmin to create a database with five tables. You need to set up primary key and foreign key for each table. Make two lines
Using phpMyAdmin to create a database with five tables. You need to set up primary key and foreign
key for each table. Make two lines of contents for each table.
In Delivery table, set two foreign keys with on update cascade, on delete set null. Remember set
DNumnber and SNumber as Nullable since you want to set them as null on delete.
In Delivered table, set both foreign keys with on update cascade and on delete cascade.
Export the SQL file and submit to Blackboard Department
Supplier
begintabularlll
hline Delivery Number & DNumber & SNumber
hline
endtabular
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
