Stan’s Southern Barbeque Supply Store sells mass-produced barbecue products to various Retail Stores. Stan’s has the credit department set a credit limit for each new customer. They also record a contact person and address for each company. Each sales order has the order number, date, tax, and total. Sales orders also contain the following information for each product ordered: stock number, description, and price. The manager of Stan’s receives sales orders by fax. Stan's never makes partial shipments; if they are out of stock of a certain item, they wait until they obtain that item and then ship the entire order. Stan’s sends a monthly statement detailing all sales during the current period. Stan’s allows some customers to make installment payments. You are the system designer for the Stan’s Southern Barbeque Supply Store.
Requirements:
1. Create a REA Model for the above Sales process. There are three business events: Take Sales Order, Ship Goods, and Receive Payment.
2. Create the necessary Table based on the REA model provided.
Business Event Tables:
Agents Tables: Use the Field from the Data Table
Resources Tables: Use the field from the Data Table
Many-To-Many Tables: