Question
Sheldon Co. buys and sells a variety of glass and plastic bottles nationwide. Each type of inventory has a unique item #. An individual sale
Sheldon Co. buys and sells a variety of glass and plastic bottles nationwide. Each type of inventory has a unique item #. An individual sale or purchase can consist of multiple inventory types which are listed as a line item on the sale invoce or the purchase order. Data about inventory items are added to the database when a supplying vendor can be found for the new item who will provide a quotes price to Sheldon Co. vendors can supply many products and vice versa. Customers are not assigned to any particular sales person; anyone can service them. The same is true for vendors and buyers. A sale, a purchase or a cash transaction involves just one employee. Customers and vendors are added to the database before any transactions with them take place. Cashiers handle cash receipts and disbursements, they are bonded, and they put all the receipts from any day into just one account, but these accounts vary daily. New cash accounts are added to the database when they are opened. Employees are added to the database on the day they are hired. All purchases are paid for immediately with a check drawn on a single account, but multiple accounts are used in purchasing activity. All check numbers are different from each other, even those from different accounts. Customers pay on the 25th of the month for all sales during the previous month. Cash receipts and disbursements take place within other cycles of the firm. REQUIRED: Using the list of attributes provided on the following page, construct an REA diagram including relationships, cardinalities, and tables. IMPLEMENT the TABLES IN ACCESS.
DATA ELEMENTS (Don't add or delete any) V-inventory item # -item weight , quantity of an item sold on this invoice .-quantity of an item purchased on this order -item color -sale invoice # -purchase order # o -purchase S amountsale S amount ,/-check # /-remittance advice # -cash receipt amount -sale date .-check amount -cash account # -cash account balance -customer # -individual accounts payable ./ . customer name -customer address -individual accounts receivable -/-vendor # .-vendor's current price quote for an item . -buyer employee # buyer telephone # .-vendor name -salesperson employee # -salesperson commission rate -cashier employee # quantity of a particular bottle item at this warehouse vendor's own product number for an inventory item -cashier fidelity bond plan . -warehouse # .-warehouse locationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started