Question

A factory (including the name and the name of the director) needs to establish a management database to store the following information: I) A factory has a number of workshops, each workshop has the workshop number, workshop director's name, address and telephone number. II) There are more than one workers in each workshop, and each worker has a staff number, name, age, sex type of work. III) A workshop produces a variety of products, each of which has the product number and price. IV) A workshop produces a variety of parts, and one kind of parts may be manufactured by different workshops. Each part has the part number, weight and price. V) A product is consist of a variety of parts, and one kind of parts can be used to assemble a variety of products. VI) Products and parts are stored in the warehouses. VII) A factory has multiple warehouses, each of which has the warehouse number, name and phone of the warehouse director.

(1) Give the ER diagram for this management database.

(2) Mapping the ER diagram into the conceptual schema, and indicate the primary keys and foreign keys.

Answer 1

Solution:

ER Diagram:

The entity relationship diagram represents the various entities and the relationship between them which helps us in understanding how the system works.

The ER diagram flr the given scenario is developed as shown below.

Please follow it.

wantshop No Telephone Dir Name name workshop factory has address Images Produces has Stofframber Member Price name age SC Products Products Workers has CI..) Part No. Parts Weight price (stored M Care House name warchouse No phone director