XYZ Enterprise is a television company that buys component inventories of televisions, converts the components into finished televisions, and then sells televisions to customers. Each television is assigned with a unique Televisionid and televisions that have similar characteristics are categorized into television types. Information on television types and televisions are entered into the database prior to any transactions. Salesperson takes care of sales call, sale order, and sale. Normally XYZ salespersons make sale calls to potential customers and not all sales calls are successful. Sometimes a salesperson needs to make multiple sales calls to the same customer to obtain one sale order. Some sale orders are

3

triggered by customer visit. One sale can be associated with multiple sale orders from the same customer. One sale order can be fulfilled by different sales. Customers can pay for multiple sales with one payment, and partial payments are allowed. Each cash receipt is assigned to one and only one of XYZ Cash accounts by one and only one of XYZ cashiers. XYZ's only cash resource is from the sale of televisions. XYZ stores the information of cash accounts, customers, and employees into database prior to any transactions.

List of attributes:

Cashaccountid

Cashreceiptid

Salespersonname

Customeraddress

Cashaccountlocation

Cashreceiptamount

Saleamount

Cashaccountbalance

Televisiontypeid

Saleorderdate

Saleid

Televisionid

Salespersonid

Proposedsellingpriceinsalecall

Customerid

Cashierid

Saledate

Cashiername

Cashieraddress

Salescallid

Salescalldate

Cashreceiptdate

Customername

Saleorderid

Quotedsellingpriceinsaleorder

Required:

Please create a revenue cycle REA model for XYZ; and convert it into relational tables (ignore the row values).

Notes: Be sure to include all relevant classes, associations, attributes, and multiplicities. Clearly list any assumptions you make.