Urgent 3

Need in 3 hours

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

• SQL Schema Plus-2019-01

ACCT 4240A Schema Assignment