flovodoh

Orders

Vendors

OrderIDPK

VendorIDFK

ProductNumberFK

VendorIDPK

VendorName

Address

PhoneNumber

ContactPerson

Creates/Order From

Ordered From

Placed On SalesIDFK

Logs Order

Sales

Product

Customer

Employee

SalesIDPK

CustomerIDFK

SalesPerson/

EmployeeID??

ProductNumberPK

Name

Description

QuantityOnHand

ReorderQuantity

Cost

MSRP

Placed On

Places Order

AsileLocation

CustomerIDPK

Name

Address

CreditLimit

CurrentBalance PK

Makes

Logs

EmployeeIDPK

EmpFirstName

EmpLastName

DepartmentIDFK

EmpAddress

EmpHireDate

EmpBirthDate

EmpJobTitle

EmpSalary

EmpOfficeNumber

EmpPhoneNumber

Belongs To

SuperType

Manages

Assigned

SupportCall

Department

Equipment

SupportIDPK

CustomerIDFK

CallDateTime

EmployeeID

CallDetails

CallStatus

EmployeeIDFK

DepartmentIDPK

DepartmentName

DeptFaxNumber

DeptPhoneNumber

Belongs To

EquipmentIDPK

EmployeeIDFK

AssignDate

SalesEmployee InventoryEmployee CustomerSupportEmployee

SuperType

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

attribute name

CustomerSupportEmployee

Laptop PrinterFax

attribute name

attribute name

attribute name

EmployeeIDFK

AssignDate

SuperType

LaptopIDPK

EquipmentIDFK

attribute name

PrinterFaxIDPK

EquipmentIDFK

attribute name