Question
Create an Information Model for Revenue Analysis Jane Jones (JJ) just opened a small food truck, Gourmet@5, on Fifth Avenue in New York City. The
Create an Information Model for Revenue Analysis Jane Jones (JJ) just opened a small food truck, Gourmet@5, on Fifth Avenue in New York City. The menu is simple, offering hamburgers, hot dogs, water bottles, and a variety of soda and candy bars. She gives you a spreadsheet that contains all the transactions for the first week from Monday through Sunday. The diagram shows what data was collected. An illustration presents two types of tables, which are: a Fact table on the left, and a Dimension table on the right. The key notes below read: Key, and Column. The data from the sales table under the left fact table are as follows: Column: Transaction I D, Day, Item, and Quantity. The data from the items table under the right dimension table are as follows: Key: Item Code; Column: Item Name, Item Price, and Item Category. N number of items flow out in one sale. The data dictionary provides a brief description for each of the fields. Sales Name Description TransactionID An ID used to identify the transaction. Day The day of the week the transaction occurred. Item The item sold to the customer (code). Quantity The quantity sold of the item. Items Name Description ItemCode A code that uniquely identifies a type of product. ItemName The name of the item (product type). ItemPrice The items price. All items have a fixed price. ItemCategory The items category. Develop an information model that will help analyze the first weeks sales. The owner is especially interested in knowing which products generate the most revenue. Generate at least two reports using the information model you created.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started