flovodoh

Employee

Department

SalesEmployee InventoryEmployee CustomerSupportEmployee

EmployeeIDPK

EmpFirstName

EmpLastName

DepartmentIDFK

EmpAddress

EmpHireDate

EmpBirthDate

EmpJobTitle

EmpSalary

EmpOfficeNumber

EmpPhoneNumber

DepartmentIDPK

DepartmentName

DeptFaxNumber

DeptPhoneNumber

Belongs To

SuperType

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

Manages

Sales

Customer

Product

SalesIDPK

CustomerID

SalesPerson/

EmployeeID??

CustomerIDPK

Name

Address

ProductNumberPK

Name

Description

CreditLimit

CurrentBalance

QuantityOnHand

ReorderQuantity

Cost

MSRP

Placed On

Places Order

AsileLocation

Orders

Vendors

Product

OrderIDPK

VendorIDFK

ProductNumberFK

VendorIDPK

VendorName

Address

PhoneNumber

ContactPerson

Creates/Order From

ProductNumberPK

Name

Description

QuantityOnHand

ReorderQuantity

Cost

MSRP

Ordered From

VendorIDFK

Placed On

IsleLocation

Customer

SupportCall

Employee

CustomerIDPK

Name

Address

CreditLimit

CurrentBalance

SupportIDPK

CustomerIDFK

CallDateTime

EmployeeID

CallDetails

CallStatus

Makes EmployeeIDFK

EmployeeIDPK

EmpFirstName

EmpLastName

EmpDepartmentIDFK

EmpAddress

EmpHireDate

EmpBirthDate

EmpJobTitle

EmpSalary

EmpOfficeNumber

EmpPhoneNumber

Logs

Employee Equipment

Laptop PrinterFax

EmployeeIDPK

EmpFirstName

EmpLastName

EmpDepartmentIDFK

EmpAddress

EmpHireDate

EmpBirthDate

EmpJobTitle

EmpSalary

EmpOfficeNumber

EmpPhoneNumber

EquipmentIDPK

EmployeeIDFK

AssignDate

Assigned

SuperType

LaptopIDPK

EquipmentIDFK

attribute name

PrinterFaxIDPK

EquipmentIDFK

attribute name