Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Convert the following textual description to an entity-relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of attributes. If

Convert the following textual description to an entity-relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of attributes. If you are identifying a strong entity - make sure you identify a primary key for it. You are not required to use superclass/subclass hierarchy for any of these problems, but may choose to do so if you wish.

1. The world is composed of 7 continents. A continent has a unique name and a current population. The names of the continents are:Africa, Antarctica, Asia, Europe, Australia/Oceania, North America and South America. A country has a unique name, and a current population. Each continent is composed of 0 to many countries. A country may be situated on 1 to many continents.

2. The world is composed of 7 continents. A continent has a unique name and a current population. A country has a unique name, and a current population. There are also languages that are spoken in the world. Each continent is composed of 0 to many countries. A country may be situated on 1 to many continents. A country has 1 to many official languages. A language may be an official language for 0 to many countries.

3. Each house in a development contains 8 rooms. Each room contains a location (within the house) and a name. The location of the room uniquely identifies the room within the house. A room may be classified as a bedroom, a bathroom or a common room. A room can be classified as only 1 type of room. A specific room type can be associated with many different rooms in a house. Each room has a collection of furniture. Each furniture piece has a color and a location (in the room). The furniture types are: sofa, chair, bookcase. A furniture can have only 1 furniture type but there may be many instances of a furniture type in a room.

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

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions

Question

Does your message use defamatory language?

Answered: 1 week ago