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 - 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
Get step-by-step solutions from verified subject matter experts
