Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Advances In Spatial And Temporal Databases 11th International Symposium Sstd 2009 Aalborg Denmark July 8 10 2009 Proceedings Lncs 5644

Authors: Nikos Mamoulis ,Thomas Seidl ,Kristian Torp ,Ira Assent

2009th Edition

3642029817, 978-3642029813

More Books

Students also viewed these Databases questions

Question

5. How are novelty, creativity and communication related?

Answered: 1 week ago

Question

Explain exothermic and endothermic reactions with examples

Answered: 1 week ago

Question

define the term outplacement

Answered: 1 week ago

Question

describe the services that an outplacement consultancy may provide.

Answered: 1 week ago