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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions