Discuss the case of a local clothing sales chain

Assignment Help Basic Computer Science

Reference no: EM133361379

Assignment:

Question

Consider the case of a local clothing sales chain that is selling a variety of clothing items online for home delivery. The restaurant wants to analyze information about food sales, including:

i) Location;

ii) Customer;

iii) DateTime of Sale;

iii) Amount of Sale,

iv) Items in Order;

v) Order Method (e.g., phone vs. Web);

vi) Designer;

vii) Colour;

viii) Type of Clothing (e.g., coat, pants, shirt, socks);

ix) Special Needs (e.g., fabric allergies, no animal products)

(a) Draw a typical 'snowflake' schema using the "Crow's Feet" notation for a relational database in which facts associated with product sales are stored. Make sure you use clear table names to show the type of data stored in each table and indicate the relationships between tables (including all keys and foreign keys). Make sure you include dimensions that could help support queries based on WHO, WHAT, WHERE, WHY, WHEN, and HOW.

(b) What attributes would be associated with the main fact table in the schema for part (a)?

Reference no: EM133361379

Questions Cloud

How is food used to create and solidify bonds : Is this something you have seen as important in other societies as well? Which ones? 2. How is food used to create and solidify bonds in your experience

How many different plant foods do you eat : How many different plant foods do you eat on a regular basis? How difficult would it be for you to obtain a more diverse diet by shopping in the same places you

Analysis of the feasibility of this type of experiment today : A description of the treatment of participants. A discussion on your opinion regarding if the experiment was ethical or unethical.

What are the levels of sociocultural integration : what are the levels of sociocultural integration and how did Julian Steward apply the concept in a case against indigenous people?

Discuss the case of a local clothing sales chain : Consider the case of a local clothing sales chain that is selling a variety of clothing items online for home delivery.

How species have adapted to changing conditions : How species have adapted to changing environmental conditions over time. Overall, paleontology is a fascinating and important field that contributes

Why do you suppose flood stories are so popular : Why do you suppose flood stories are so popular? What events or religious tenets might flood stories explain?

Identify a particular social problem : identify a particular social problem that an applied anthropologist might want to get involved in, and think about what theoretical perspectives would be useful

Define characteristics of the input variables : Define characteristics of the input variables. Make sure you cover all input variables. Define characteristics of inputs.

User Account

All Pages