数据库代写 | FIT3003 Major Assignment2020-Semester2

本次数据库代写是为MonChef数据库创建一个数据仓库

FIT3003 Major Assignment2020-Semester2

B. Problem Description – MonChef Data Warehouse
MonChef is a food business located in Clayton and run by Monash University, that helps provide
healthy and delicious food at a reasonable price for schools and the community. MonChef has two
main business segments. One is for school canteen orders in which the business will take orders
from schools, colleges, businesses, or for special occasions and deliver the food for them. The
other one is on catering service, catering to the community through different delivery service
providers like UberEats, DoorDash, etc. Therefore, the management at MonChef frequently
generates reports to keep track of the business (e.g. calculating statistics on the revenues generated
from school order and catering service), which can later be used for forecasting various trends and
making predictions about the food business.
MonChef currently has an existing operational database which maintains and stores all of the
business transaction information (such as school order, catering order, product, etc.) required for
the management’s daily operation. However, since the staff at MonChef has limited database
knowledge and the operational database is quite large, MonChef has decided to hire your team of
Data Warehouse Engineers to design, develop, and quickly generate reports from a Data
Warehouse.
MonChef’s operational database tables can be found at MonChef.
C. Tasks
The assignment is divided into FOUR main tasks:
1. Design a data warehouse for the above MonChef database.
You are required to create a data warehouse for the MonChef database.
The management is especially interested in the following fact measures:
● Total sales/revenue for Catering service
● Total sales/revenue for School Canteen service
● Number of Catering orders
● Number of School Canteen orders
● Average order price for School Canteen
● Average order price for Catering
● Total service delivery costs of the delivery provider
● Number of customers
● Number of products
The following show some possible dimension attributes that you may need in your
data warehouse:
● Order status
● Customer type
● Delivery providers
● Order date (Day[Sat, Sun, ….Fri], Month[Jan-Dec], Year)
● Season [Summer, Winter, Spring, Autumn]
● Customer location
● Product type (Meal[Starter, Main, Dessert], Cuisine, Flavour[Savoury,
Sweet])
● Staff’s gender


程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: [email protected]  微信:itcsdx


如果您使用手机请先保存二维码,微信识别。如果用电脑,直接掏出手机果断扫描。

blank

发表评论