Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. (20 points)

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

Database Systems Design Implementation And Management

Authors: Carlos Coronel, Steven Morris

14th Edition

978-0357673034

More Books

Students also viewed these Databases questions