hw2Schema3.pdf

EMPLOYEE PK employeeID FK empbranch ref BRANCH FK empsupervisor ref EMPLOYEE

ORDERS PK orderNumber FK customerID ref CUSTOMER FK salesPerson ref EMPLOYEE

BRANCH PK branchNumber FK branchManager ref EMPLOYEE

CUSTOMER PK customerID

PRODLINE PK orderNumber

prodCode FK orderNumber ref ORDERS FK prodCode ref PRODUCT

INSTLINE PK orderNumber

instType FK orderNumber ref ORDERS FK instType ref INSTALLATION

INSTALLATION PK installType

PRODUCT PK productCode