Homework: Database Design & Entity-Relationship Modeling
I. 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.
II. 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 can't do either of the above, you could write down the table schemata and describe the relationships among them.
III. Submit the document. Make certain the table title, course number, and module and Case ID are on the work you submit.
IV. Describe the major points you learned in the readings especially on entity relationship modeling and what lessons you have learned in this exercise. (at least half a page).
Format your homework according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.