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.comACCT 4240A Schema Assignment Fig. 1 CS PROPULSION PARTIAL DATABASE SCHEMA CHART OF ACCOUNTS ACCOUNT NUMBER ACCT NAME ACCT TYPE AMOUNT DEBIT ANT CREDIT AMT CUSTOMERS CUST ID CUST LAST CUST FIRST ADDRESS CITY STATE ZIP ACCOUNT NUMBER SALES ORDERS ORDER ID CUST ID ORDER DATE LINE NUMBER THY ID QUANTITY ORDERE D EXTENDED AMOUNT ACCOUNT NUMBER SHIP DATE SHIPPING ADDRES SHIPPING CI] SHIPPING Z S TY SHIPPING STATE JP VENDORS VENDOR ID VENDOR NAME ADDRESS CITY STATE ZIP ACCOUNT NUMBER INVENTORY INV ID VENDOR ID DESCRIPTION QUANTITY IN STO CK UNIT PRICE EXTENDED AMOUNT|ACCOUNT NUMBER