1. Fill in the column headings in row one of each table (Customer, Employee, and Sales Order) with the data items (attributes) you believe belong in the table.
2. Draw an ER diagram for the three tables: Customer, Employee, and Sales Order. Suppose the Sales Order Table also contains information for an employee who makes a sale. If you have an ERD drawing tool such as Visio, you could draw the diagram using the tool and copy it into your document. You could also draw it on paper, scan it, and insert it into your document. If you cant do either of the above, you could write down the table schemata and describe the relationships among them.

Employee Table

Social Security Number	First Name	Last Name	Address	City	State	Zip Code	Birthday	Status (Full/Part Time)	Salary (Hourly Rate)	Date of Hire

Customer Table

Customer Number	First Name	Last Name	Email	Telephone-Number	Address.	City	Zip code	Customer Since (date)

Sales Order Table

Sales Order Number	Customer Number	Social Security Number	Sales Amount	Date	Comments