Question: a. a. Answer the following questions according to below database schema figure. State the names of all tables State the primary keys of the tables

 a. a. Answer the following questions according to below database schema

a. 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? customers * customer_id first_name last_name phone email street city state zip_code staffs staff_id first_name last_name email phone active store_id manager_id 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 city ++ + state zip_code order_items et order_id *item_id product_id quantity list_price discount

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 Databases Questions!