Question: a. Answer the following questions according to below database schema figure. State the names of all tables State the primary keys of the tables b.
a. Answer the following questions according to below database schema figure. State the names of all tables State the primary keys of the tables b. State the foreign keys in the tables (if any) C. Which tables can be joined? a. customers * customer_id first_name last_name phone email street staffs staff_jd first_name last_name email phone active store_jd manager_id state zip_code orders order_id customer_id order_status order_date required_date shipped_date store_id staff_id stores store_id store_name phone email Street ++ state zip_code order_items order_id "item_id product_id quantity list price discount
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
