below. Equipments are manufactured by using parts. Name, manufacturing date, current status of manufacturing must be known. Some of the equipments must be tested. We want to define all parts with their na
SCENARIO
A manufacturing company produce equipments and sell them. The company needs a system to manage stock operations. It is explained below.
Equipments are manufactured by using parts. Name, manufacturing date, current status of manufacturing must be known. Some of the equipments must be tested.
We want to define all parts with their name, description and type. Only the defined parts can be bought. Once parts are bought, they are located into shelves in warehouses. Each physical part uniquely identified with number. We want to know when each part is bought. Each bought part may have different warranty period. We have to use the bought part in manufacturing by taking this into account.
Warehouses are located in different part of the company. Size, type of the warehouses may be different.
Each parts can be bought from same or different suppliers. We want to know in which city they are located. Also for how many years we are working with each supplier. We also give rating to suppliers. Their account number, tax number will be also needed.
-------------------------------
According to above scenario, draw Entity Relationship Diagram (ERD). The following items must be included in this design.
1. Identify the entities
2. Define attributes of entities and their optionality. Define UID s. Add at least 5 more meaningful attributes not mentioned in the scenario
3. For one of the attributes explain the result of changing the optionality
4. Define volatile attribute(s) and convert them into nonvolatile attribute(s).
5. Identify relationships between entities by using Matrix Diagram
6. Specify optionality, cardinality and name of the relationships
7. Read one relationship between two entities by ERDish
8. For one of the relationships, explain the result of changing the optionality and cardinality
Step by step
Solved in 3 steps
