Reference no: EM13997878

Draw an ERD diagram based on the Crow's Foot model for a database to support the basic operations of "Milky Way Jewelry".Specify:• Entity sets, their attributes, and primary keys;• Relationship sets and their descriptive attributes (if such exist);• Connectivities and cardinalities;• Decompose all M-M relationships, if any;• If found, replace any multivalued attributes and composite attributes• appropriately.Each piece of jewelry for sale is assigned a unique number, and is described by the name,sale price and a style.Each piece of jewelry can be made from one or more material, e.g. white gold anddiamond. The same material can be used to make many pieces of jewelry. The materialsused and their amount for each piece must be recorded in the database. Materials aredescribed by material code, title and feature. A material can be a mixture of othermaterials. Then it is necessary to record the composition of the material including thepercentage of each mixed material. The same material can be used to make many kinds ofmixtures.For each piece of jewelry it is necessary to record the artist who created the piece of art.Information about artists is to be recorded in the database. It includes artist ID, name,address and phone number. One artist can create many pieces of jewelry. Each piece of jewelry can be only made by one artist.