Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am looking for the solution to the problem , where Enhanced Entity Relationship diagram is made using shapes eg. rectangles for entity and show

I am looking for the solution to the problem , where Enhanced Entity Relationship diagram is made using shapes eg. rectangles for entity and show disjoint constraint whereever applicable in addition to the conversion to relational model and then UML class diagram
image text in transcribed
We want to model a computer sales system and its components. A manufacturer manufactures computer components. The manufacturer is defined by his name, and we must know his address (no, street, city, and country). There are 4 types of components: - a processor, which has a speed and a number of cores. - a hard disk, which has a capacity. - a motherboard, which has no specific property that we want to store. - a graphics card, which has a speed and a memory capacity. In addition to the type, each component has a name and a description. Two components cannot have the same name. It is possible that two components are incompatible and that they do not work if they are placed in the same computer. We need to store the fact that two components are compatible or not. A store, which is characterized by its name, buys components from a manufacturer at a price established by the latter. Note that a manufacturer can own one or more stores (stores must still buy from this manufacturer, or even from other manufacturers). The store may purchase the same component from several manufacturers at different prices, and it is possible for two stores to purchase the same component from a manufacturer at different prices. A store also resells components at a price it sets. Additionally, a store can sell computers. A computer contains a processor, a hard disk, a motherboard and a graphics card (always only one of each). Design an Enhanced Entity-Relationship diagram for the grade book database and convert it to a relational model. Suggest a conversion of your EER into a UML class diagram, justify the different conversion steps. Draw the corresponding UML class diagram

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Deductive And Object Oriented Databases Second International Conference Dood 91 Munich Germany December 18 1991 Proceedings Lncs 566

Authors: Claude Delobel ,Michael Kifer ,Yoshifumi Masunaga

1st Edition

3540550151, 978-3540550150

Students also viewed these Databases questions

Question

1. How do most insects respire ?

Answered: 1 week ago

Question

Who is known as the father of the indian constitution?

Answered: 1 week ago

Question

1.explain evaporation ?

Answered: 1 week ago

Question

Who was the first woman prime minister of india?

Answered: 1 week ago

Question

Explain the concept of going concern value in detail.

Answered: 1 week ago

Question

Group Size and Communication

Answered: 1 week ago

Question

Understanding Group Roles

Answered: 1 week ago