DEMO_ERD lab 4

DEMO_ERD lab 4 - JOB_ID FK2 MANAGER_ID HIRE_DATE SALARY...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CUSTOMER PK CUSTOMER_ID NAME ADDRESS CITY STATE ZIP_CODE AREA_CODE PHONE_NUMBER FK1 SALESPERSON_ID CREDIT_LIMIT COMMENTS JOB PK JOB_ID FUNCTION LOCATION PK LOCATION_ID REGIONAL_GROUP PRICE PK,FK1 PRODUCT_ID PK START_DATE LIST_PRICE MIN_PRICE END_DATE DEPARTMENT PK DEPARTMENT_ID NAME FK1 LOCATION_ID PRODUCT PK PRODUCT_ID DESCRIPTION EMPLOYEE PK EMPLOYEE_ID LAST_NAME FIRST_NAME MIDDLE_INITIAL FK1
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: JOB_ID FK2 MANAGER_ID HIRE_DATE SALARY COMMISSION FK3 DEPARTMENT_ID SALES_ORDER PK ORDER_ID ORDER_DATE FK1 CUSTOMER_ID SHIP_DATE TOTAL ITEM PK,FK1 ORDER_ID PK ITEM_ID FK2 PRODUCT_ID ACTUAL_PRICE QUANTITY TOTAL Entity Relationship Diagram DEMO database World Campus IST210 Instructor: Gary Heberling...
View Full Document

Ask a homework question - tutors are online