Question: Each question is worth 10 points each. Convert the following textual description to an entity-relationship diagram in UML notation. Please spend time differentiating between entities,

Each question is worth 10 points each. 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.

Each question is worth 10 points each. Convert the following textual description

7. 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. 8. 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. 9. 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 the house. 10. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!