Question: CUSTOMER begin{tabular}{|l|l|l|} hline Cust# & Cname & City hline end{tabular} ORDER begin{tabular}{|l|l|l|l|} hline Order# & Odate & Cust# & Ord_amt hline end{tabular} ORDER

CUSTOMER \begin{tabular}{|l|l|l|} \hline Cust\# & Cname & City \\ \hline \end{tabular} ORDER \begin{tabular}{|l|l|l|l|} \hline Order\# & Odate & Cust\# & Ord_amt \\ \hline \end{tabular} ORDER ITEM \begin{tabular}{|l|l|l|} \hlineOrder# & Item# & Qty \\ \hline \end{tabular} ITEM \begin{tabular}{|l|l|} \hlineItem# & Unit_price \\ \hline \end{tabular} SHIPMENT \begin{tabular}{|l|l|l|} \hline Order\# & Warehouse\# & Ship_date \\ \hline \end{tabular} WAREHOUSE \begin{tabular}{|l|l|} \hline WareHouse\# & City \\ \hline \end{tabular} List all the foreign keys in the schema in the following format: referencing_table_name( foreign_key_attribute) references referenced_table_name (key_attribute)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
