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
\begin{tabular}{|l|l|l|}
\hline Delivery Number & DNumber & SNumber \\
\hline
\end{tabular}
Using phpMyAdmin to create a database with five

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!