Urgent 3

Entity-Relationship Diagram (ERD) Assignment (15 Pts.)

Sidney A. Porter, MSA CPA Instructions

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:

Source: Accounting Information Systems, 14th Edition. Romney and Steinbart

Source: edrawsoft.com

ACCT 4240A Schema Assignment

ACCT 4240A Schema Assignment

Fig. 1 CS PROPULSION PARTIAL DATABASE SCHEMA

CHART OF ACCOUNTS ACCOUNT_NUMBER ACCT_NAME ACCT_TYPE AMOUNT DEBIT_AMT 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 INV_ID QUANTITY_ORDERE D

EXTENDED_AMOUNT ACCOUNT_NUMBER

SHIP_DATE SHIPPING_ADDRES S

SHIPPING_CI TY

SHIPPING_STATE SHIPPING_Z IP

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