Renton Business Supplies sells building material and plumbing equipment to individual as well as corporate customers. Individual customers are typically walk-in customers who pay for their purchases before leaving the store. Corporate customers often have accounts with Renton's and these customers prefer to call through their orders, have them made up, and then send a driver to collect the items. These types of corporate purchases are charged to the accounts of the corporate customers. At the end of the month, the corporate customers can either pay off the entire balance on the account, or they can pay off the balance over a period of three months. The arrangement with corporate customers is that all payments should be made via Electronic Funds Transfer. REQUIRED Draw an REA diagram for the revenue cycle of Renton Building Supplies. Include all entities and cardinalities. Ramjohn Hunte wants to store the following data about Helsinki Company's purchases of inventory: item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase REQUIRED 1. Design a set of relational tables to store this data. Name each table and field in accordance with good database design. Do all the data items need to be stored in a table? If not, which ones do not need to be stored, and why do they not need to be stored? (14 marks) 2. Identify the primary key for each table. ( 3 marks) Renton Business Supplies sells building material and plumbing equipment to individual as well as corporate customers. Individual customers are typically walk-in customers who pay for their purchases before leaving the store. Corporate customers often have accounts with Renton's and these customers prefer to call through their orders, have them made up, and then send a driver to collect the items. These types of corporate purchases are charged to the accounts of the corporate customers. At the end of the month, the corporate customers can either pay off the entire balance on the account, or they can pay off the balance over a period of three months. The arrangement with corporate customers is that all payments should be made via Electronic Funds Transfer. REQUIRED Draw an REA diagram for the revenue cycle of Renton Building Supplies. Include all entities and cardinalities. Ramjohn Hunte wants to store the following data about Helsinki Company's purchases of inventory: item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase REQUIRED 1. Design a set of relational tables to store this data. Name each table and field in accordance with good database design. Do all the data items need to be stored in a table? If not, which ones do not need to be stored, and why do they not need to be stored? (14 marks) 2. Identify the primary key for each table. ( 3 marks)
