Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Behind Closed Doors What Company Audit Is Really About

Authors: V. Beattie, R. Brandt, S. Fearnley

2001 Edition

0333747844, 978-0333747841

More Books

Students also viewed these Accounting questions

Question

Does it have at least one-inch margins?

Answered: 1 week ago

Question

Does it highlight your accomplishments rather than your duties?

Answered: 1 week ago