Use an Entity-Relationship diagram to depict the information needs of a small computer business firm

Use an Entity-Relationship diagram to depict the information needs of a small computer
business firm:
(a) The employees of the company assemble different types of computers. For each
employee a record is kept of his employee no., name, address, phone no., job title,
and salary.
(b) A record is also kept of each of the machines model, specs and name, and quantity on
hand.
(c) Each machine consists of a number of parts. An inventory must be kept of the parts
in stock. For each part a record is kept of its name, price, and quantity on hand.
(d) These parts are ordered from various suppliers. A record must be kept of the
suppliers name, address, and phone number.
(e) The assembled computers are sold to various customers. A record is kept of the
customers name, address, and phone number. Some of these customers are credit
customers and for these customers a record is kept of their credit limit

 

0Comment