Answered step by step
Verified Expert Solution
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 entityrelationship 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 superclasssubclass 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 superclasssubclass 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 to many themes and a theme can classify 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 and only unit a measure. Each unit of measure is associated with to many garland strands. Each string of lights has and only unit a measure. Each unit of measure is associated with to many strings of light. Each Christmas ornament has and only unit a measure. Each unit of measure is associated with to many Christmas ornaments. Each figurine has and only unit a measure. Each unit of measure is associated with 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 to many garland strands. A garland strand is associated with to many colors. Each string of lights has to many colors. Each color is associated with to many strings of light. Each Christmas ornament has to many colors. Each color is associated with to many Christmas ornaments. Each figurine has to many colors. Each color is associated with to many figurines.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started