CENARIO A manufacturing company produce equipment 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. Equipments are manufactured for customers. It is needed to know the equipments of customers. Some of the customers pay the transportation cost. Name, address, tax number type of the customer will be stored. 1. Identify the entities 2. Define attributes of entities and their optionality. Define UID p. Add at least 5 more meaningful attributes not mentioned in the scenario (Database system) 3. For one of the attributes explain the result of changing the optionality

SCENARIO A manufacturing company produce equipment 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. Equipments are manufactured for customers. It is needed to know the equipments of customers. Some of the customers pay the transportation cost. Name, address, tax number type of the customer will be stored. 1. Identify the entities 2. Define attributes of entities and their optionality. Define UID p. Add at least 5 more meaningful attributes not mentioned in the scenario (Database system) 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