Question: Please create an entity-relationship (E-R) model for the following business description - Define the entities (hint, look for the nouns) - Define the relationships between

 Please create an entity-relationship (E-R) model for the following business description

Please create an entity-relationship (E-R) model for the following business description - Define the entities (hint, look for the nouns) - Define the relationships between entities - Define the optionality ("may or must", 0 or 1) - Define the cardinality (1 and only 1", or Many) - Define the key attribute(s) and a few of the attributes of the entity Please submit your work in PDF format, using Lucid Chart, Visio, or even by hand. You may work with one other person; both will receive the same grade. TopDrawer designs and sells men's and women's underwear in various silhouettes (boxer, boxer brief, hipster, thong), fabrics (cotton, polyblend), colors and sizes. A given style is for a specific gender but can be sold (as a SKU) in multiple colors and sizes. For direct-to-consumer (ecommerce) sales, a given SKU can be sold as a single unit or merchandized as part of a "bundle" of 2, 3 or 4 units with a quantity discount. Currently, bundles are always the same style and size, but can include different colors, (though there is consideration of creating bundles with multiple silhouettes, all of the same size and color) In the wholesale channel, the base SKU is always a pack (no singles) with same style and size, sometimes the same color, sometimes multi-color. Some wholesale retailers (e.g., Nordstrom) have exclusive print and color offerings and packaging that can't be sold anywhere else. These are called Special Make Ups or SMUS. Underwear is made in third-party factories, mostly in Asia but also in South America. A given style can be produced at one or many factories, but some factories only produce cotton products. Fabric (poly and cotton) comes from mills and because of trade restrictions and tariffs, some factories aren't allowed to source raw materials from certain mills. Please create an entity-relationship (E-R) model for the following business description - Define the entities (hint, look for the nouns) - Define the relationships between entities - Define the optionality ("may or must", 0 or 1) - Define the cardinality (1 and only 1", or Many) - Define the key attribute(s) and a few of the attributes of the entity Please submit your work in PDF format, using Lucid Chart, Visio, or even by hand. You may work with one other person; both will receive the same grade. TopDrawer designs and sells men's and women's underwear in various silhouettes (boxer, boxer brief, hipster, thong), fabrics (cotton, polyblend), colors and sizes. A given style is for a specific gender but can be sold (as a SKU) in multiple colors and sizes. For direct-to-consumer (ecommerce) sales, a given SKU can be sold as a single unit or merchandized as part of a "bundle" of 2, 3 or 4 units with a quantity discount. Currently, bundles are always the same style and size, but can include different colors, (though there is consideration of creating bundles with multiple silhouettes, all of the same size and color) In the wholesale channel, the base SKU is always a pack (no singles) with same style and size, sometimes the same color, sometimes multi-color. Some wholesale retailers (e.g., Nordstrom) have exclusive print and color offerings and packaging that can't be sold anywhere else. These are called Special Make Ups or SMUS. Underwear is made in third-party factories, mostly in Asia but also in South America. A given style can be produced at one or many factories, but some factories only produce cotton products. Fabric (poly and cotton) comes from mills and because of trade restrictions and tariffs, some factories aren't allowed to source raw materials from certain mills

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!