Question: The database at a Grocery Store needs to process lots of data. In this example, our store is open from 7am to 10pm, and processes
- The database at a Grocery Store needs to process lots of data. In this example, our store is open from 7am to 10pm, and processes an average of 30 transactions per hour total. Each transaction consists of an average of 20 items being purchased.
- Describe how we can use Data Management to determine the Grocery Stores right technology/model?
- Describe how we can organize a relational data model (nouns/verbs) for the Grocery Store?
- How many rows of data will the Grocery Store be generating every day? And then calculate how many rows of data for an entire year (assume our store is open every day of the year)?
- Why is it important to know estimated rows of data? (Hint: this can be longer than 3 sentences)
- Data Management requires us to understand what our data is, in order to properly store, preserve, and retrieve the data later. Continuing with our Grocery Store example from question #1:
- Please describe the different data elements and data types involved in our Grocery Store example, for the data that is being stored in our database? (Hint: this can be in a list, or separated into different data objects, but it should be clear what is being stored)
- Why are naming conventions important in our Grocery Store database? What are your Naming Conventions for your Database Design?
- Yes or No, and why: Can your Grocery Store database transaction have more than one cash register sales clerk? (Hint: It could be either design which do you prefer? This can be longer than 3 sentences)
- How does our Grocery Store database allow items to be in more than one transaction (example: two people both bought bananas)?
- What is our responsibility to protect the data within our Grocery Store Database? Why is it our responsibility? Is it anybody elses responsibility? (Hint: This should be longer than 3 sentences)
- Describe a specific example of a Relational Database that you use in your life? Describe how you imagine it works? (Hint: think about the things you interact with in your life that saves something about you. This should be longer than 3 sentences)
5.) What types of reports can be generated from our Grocery Store Database? Who would be interested in seeing those reports?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
