IFSM 436 Exercises and Case Studies

1. ANALYSIS
   Exercises
   1. The process for accounts payable at the BENK Motor Company is as follows: When the purchasing dept wrote a purchase order, it sent a copy to accounts payable. Later, when material control received the goods, it sent a copy of the receiving document to accounts payable. Meanwhile, the vendor send an invoice to accounts payable. It is up to accounts payable, then, to match the purchase order against the receiving document and the invoice. If they matched, the dept issued payment. As a result, the dept spent most of its time on mismatches, instances where the purchase order, receiving document, and invoice disagreed. In these cases, an accounts payable clerk would investigate the discrepancy, hold up payment, generate documents, and all in all gum up the works.
      How do you as a SA design an IS to improve the productivity ?
      
   2. Construct an Entity-Relationship diagram for the following situation:
      A company consists of several dept, each having a number of employees. Each dept has a manager who must be on the monthly payroll. Other employees are on either the monthly payroll or the weekly payroll, and are members of the sports club if they so wish.
   
   
2. CASE STUDY 1.
   
   Personal Computer Associates.
   PC Associates is a large, multinational consulting corporation, which uses a number of PCs and software packages in the course of her work. PC Assoicates needs to maintain the following information about the PCs and software packages its employee uses to do their jobs. For each PC, the computer number, the computer model and manufacturer, and the type of microprocessor needed to be stored. Data for each employee also needed to be stored - such as the employee name, employee number, and phone number. Also for each PC, the inventory tag number, location, computer number and the number of the employee who owns the PC. For each software package, the package number, current cost, type, name and version needed to be stored. Also for each software package installed on a PC, the package number and cost, installation date and inventory tag number needed to be stored.
   
   Analyse and create the database structure for PC Associates. Questions for discussion will be distributed in class.