Consider the case of local restaurant chain

Assignment Help Computer Engineering

Reference no: EM133324647

Assignment: Consider the case of local restaurant chain that is selling variety of menu items online for home delivery. The restaurant wants to analyze information about food sales, including:
Problem 1: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.

i)Location; ii) Customer; iii) datetime of sale; iv) Items in Order;

v) Order Method(e.g., phone vs. Web); Special Needs(e.g., food allergies, vegetarian)

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

Reference no: EM133324647

Questions Cloud

To observe the ber performance of simo system : To observe the BER performance of SIMO system with two receive antenna MRC is correlated Rayleigh fading channel.To observe the BER performance of a TB-MIMO

Would you pursue an opportunity to trial the change : change and found evidence-based interventions that would be beneficial in your work area, would you pursue an opportunity to trial the change

Explore the social construction of gender : Explored the "social construction" of gender. Provide three examples of how we can tell that gender is a social concept (and not a product of biology).

Develop individualized practicum learning objective : Develop individualized practicum learning objective, be sure to write them using the SMART format. Use the resources found in Week 2 to guide

Consider the case of local restaurant chain : Consider the case of local restaurant chain that is selling variety of menu items online for home delivery. The restaurant wants to analyze information

What lasting impacts has each contribution made : Emphasize how they impacted Deaf culture. How is that influence seen in today's culture? What lasting impacts has each contribution made?

What does the article contribute to cognitive psychology : Do you have any criticisms or ideas about how the study could have been better? What does the article contribute to cognitive psychology?

What type of study is conducted : What type of study is conducted and Which of these is the single most concerning of these threats? Describe why this is the case

Provide a sample chain-of-custody and discuss the process : Provide a sample warrant and discuss the details. Provide a sample chain-of-custody and discuss the process. Discuss how the computer/mobile device is stored

User Account

All Pages