CS Jet Propulsion, a seller of aircraft parts, has determined that its relational database is not

completely normalized or efficient. You have been asked to assist the database designer by

preparing an Entity-Relationship Diagram (ERD) based on the schema shown on the following

page. There are numerous ways to draw an ERD. Some examples are shown below. You may

use one of the styles below or do research to find an ERD style that you believe works better.

Regardless of the style you choose, your diagram should use the appropriate symbols to

represent all entities, relationships and must include, at a minimum, the attributes that are

primary keys or foreign keys. In addition, your diagram should reflect cardinalities of each

relationship.

Example styles of Entity-Relationship Diagrams: Panel A: Relationships depicted by diamonds Sales Line Inventory Panel B: Relationships depicted without diamonds Sales Inventory Panel C: Attributes attached to entities Invoice Number Date Hem Number Description Amount List Price Sales Inventory Source: Accounting Information Systems, 14" Edition. Romney and Steinbart Supplier Customer Order Supplies Submits Item1 Item1 Item1 Item2 Item2 Item2 Item3 Item3 Item3 Sents Supplied by Requests Sent by Requested on Shipment Item Product Includes Used in Uses Item 1 Item1 Item 1 Item2 Included on Item2 Item2 Item3 Item3 Item3 Source: edrawsoft.com