The Expense Cycle of T&T Company

T&T Company $($T&T$)$ is a manufacturing company who sells otebook eomputers all over the world. In

order to make their notebook computers, T&T purchases computer components from various vendors.

Each type of computer component is given by vendors an initial dist price when purchased. And prices can

be further negotiated based on the quantities purchased. Each purchasing staff is in charge of a specific

group of vendors. One or more types of computer components can be included in a purchase order which

cap be paid for in any one of three ways: $1)$ immediately in cash, $2)$ on the ${15}^{th}$ of the following month, or

over the course of six months. Purchases are signaled by purchase order#; Cash disbursements are

traced by disbursement voucher#$.$

The policies above plus the attributes listed below are relevant to potential users of the data model, and

T&T needs to include all of them in its final database structure $($attributes with asterisks are hints for some

$($not all$)$ of the needed relationships$).$ Cashiers and purchasing staffs both belong to an entity called

"employee".

$-$Inventory #

$-$Primary vendor for this

computer component

$-$Vendor#

$-$Bank for cash aecount

$-$Vendor name

$-$Purchase date

$-$Actual purchase price of

each computer components

$-$Bank account for

disbursement$*$ gish $h$

$-$Monthly salary of employee

Inventory description

QOH $($quantity$-$on$-$hand$)$

Bank account#

A$/$P amount

Purchase order# krimay

Purchase amount

Employee name

Cash disbursement amount

Employee's highest degree

Amount of cash

disbursement applied to a

certain purchase

Initial list price

Disbursement voucher#

Bank account type

Vendor$-$Employee$*$

Inventory quantity

purchased

Disbursement date

Employee #

Cash account balance

CREATE A DIAGRAM USING $($Entity$-$Relationship format$)$