CMIS 320

Mail_order

Using the mail_order.txt as a guide, reverse engineer the set of tables.
Draw an ER diagram of the relationships among the tables.
Create a .sql batch file that creates the tables using the exact same
names and field order as in the guide file. Include the primary and foreign keys.


0. For each table, paste the lines from 'show create table' about
the primary key and any constraints:

 customers 


 employees 


 odetails  


 orders    


 parts     


 zipcodes  


When the above has been checked by your instructor, get the Inserts
file from your instructor, execute it to populate the tables, and 
answer these queries:


1. How many rows in each table?
 customers ____
 employees ____
 odetails  ____
 orders    ____
 parts     ____
 zipcodes  ____

As is typical of well-designed tables, not much of interest is in a single
table. Data needs to be pulled from multiple tables to answer queries of
interest.
These queries involve a join of two tables:

2. What city is each employee in?

3. What orders are each employee working on?

4. How many orders does each customer have?