Arcontica Classic Furniture manufactures a of rustic chairs, lawn furniture, and interior purnishing including lamps, desks and bed frames. AFC's customer base comprises both private customers and retail outlets. consumer's sales are for cash or by credit card, but business costumers are for cash or by credit card, but business costumers are extended by a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepare a sales order, and sends stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department update the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department where the AR clerk updates the AR subsidiary ledger . Customer submit checks and remittance advices to the mail room. A clerk sends the remittance advances to the AR department and the checks to the cash receipts department. At the end of the day, the cash receipts clerks prepares a deposit slip and deposit the checks into the company's bank account, files the bank receipt and update the cash receipts journal. The physical aspects of cash sales transaction are handled similar to the process described here except that checks or credit card account numbers are submitted with the original order. Required : 1.Prepare REA model to support the sales/collections process. 2.Show the cardinalities for all association. 3.List the tables, keys and attributes needed to implement this model in a relational database.
Arcontica Classic Furniture manufactures a of rustic chairs, lawn furniture, and interior purnishing including lamps, desks and bed frames. AFC's customer base comprises both private customers and retail outlets. consumer's sales are for cash or by credit card, but business costumers are for cash or by credit card, but business costumers are extended by a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepare a sales order, and sends stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department update the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the
Required :
1.Prepare REA model to support the sales/collections process.
2.Show the cardinalities for all association.
3.List the tables, keys and attributes needed to implement this model in a relational database.
Step by step
Solved in 3 steps with 6 images
