mist

MIST315 Entity Relationship Diagram (Example 1). Personal Computer Associates. You are a system analyst. PC Associates is a large, multinational consulting corporation, which uses a number of PCs and software packages in the course of her work to maintain the following information a do their jobs. For each PC, the bout the PCs and software packages its employee uses to computer number, the computer model and manufacturer, and ber. Also for each PC the type of microprocessor needed to be stored, ta stored -such as the employee name, employee number, and phone num 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 needed to be stored Da for each employee also needed to be 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. Given the above, draw an entity-relationship diagram and translate it into relational tables, for xample tudent (student id, name, address, major, dept.), etc WAt