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

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. Remember, weak entities do not have a primary key. You are not required to use superclass/subclass hierarchy for any of these problems, but may choose to do so if you wish. Emilia owns Christmas decorations. A Christmas decoration is either an ornament, a figurine, a garland strand or as a string of lights. A Christmas ornament has a shape (values: round, square, or star), and a size. A size consists of a length, a width and a height. Each Christmas ornament can be classified into many themes. A theme consists of a name and the different values are: folk art, elegant, traditional, pastel, and wooden. An ornament can be classified as 1 to many themes and a theme can classify 1 to many ornaments. A Christmas figurine has a size, consisting of height, length, and width. It also has the name of the base material it is made out of. You also want to track if the figurine is fragile as well as if it plays music. A figurine represents a Christmas character. The names of the Christmas characters a figurine can represent are: Angel, Santa Claus, Nutcracker, Christmas tree and Snowman. A garland strand consists of a base material, and a length. A string of lights consists of a bulb size, a count of the number of bulbs on the strand and a length. Since Emilia has American as well as European decorations, she needs to track the unit of measure used for each of the length, width, or height of the different Christmas decorations. A unit of measure consists of a unique denomination name (examples are: inch, centimeter, meter, foot) as well as a unique abbreviation and a unique prefix. Each garland strand has 1 and only 1 unit a measure. Each unit of measure is associated with 0 to many garland strands. Each string of lights has 1 and only 1 unit a measure. Each unit of measure is associated with 0 to many strings of light. Each Christmas ornament has 1 and only 1 unit a measure. Each unit of measure is associated with 0 to many Christmas ornaments. Each figurine has 1 and only 1 unit a measure. Each unit of measure is associated with 0 to many figurines. We also need to track the color of the different Christmas decorations. Each color has a unique name, a hue, a saturation and brightness. Each color is associated with 0 to many garland strands. A garland strand is associated with 1 to many colors. Each string of lights has 1 to many colors. Each color is associated with 0 to many strings of light. Each Christmas ornament has 1 to many colors. Each color is associated with 0 to many Christmas ornaments. Each figurine has 1 to many colors. Each color is associated with 0 to many figurines.

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

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions