Adventure Works database
Business scenario: In this assignment, we will learn how to create dimensional modelsfor OLAP database by applying a 4-steps dimensional model. Please install AdventureWorks database, read the AdventureWorks casestudy,and analyzethe ERD OLTP schemathat you can find in this week assignment before starting this assignment.Q1:The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the saleorders’lifecycle. Specifically, he wants to know the total numbers of orders when they are ordered, due, and shipped to the customer. Provide a 4-stepsdimensional model in the SQL comment section (2 points) and create a data mart solution in SQL for the dimension model that you propose (2 points).Q2:The CEO of AdventureWorks Inc.wants to build two data martsto keep track ofsalesperformance. He is concerned with how effective each salesperson can sell products to the customer. To measure the effectiveness of each salesperson, he wants to use total numbers of orders and sales performance ratio (defined by SalesYTD divided by SalesLastYear). Besides, he wants to know his company’s monthlysales performance.Specifically, he wants to keep track ofmonthlytax effectiveness (defined by Tax Amount divided by Sales SubTotal)and monthly sales amount.Provide a 4-stepsdimensional model in the SQL comment section (2 points) and create data mart solutionsin SQL for the dimension model that you propose (4 points)
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
A database used for a toy store that keeps track of the inventory and purchase orders...
A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...
A database used for a toy store that keeps track of the inventory and purchase orders...
A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...
The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind...
The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. Here is the schema of the database: Products (ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued); Suppliers (SupplierID, CompanyName, ContactName , ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage); Categories (CategoryID, CategoryName, Description, Picture); Orders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName,ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry); Order_details (ID, OrderID,...
The owner of a small chain of appliance stores wants to build a database to help...
The owner of a small chain of appliance stores wants to build a database to help track data about its regions, stores, employees and jobs. The chain has divided the map of where its stores exists into various regions. Each region has a description (of boundaries). Each store is named, has an average market size (expressed in dollars) and belongs to s specific region. Each store also has an address, city, state, and zip. The database should...
Mr. Bob Dillon is a collector of china pieces. He needs a database is to store...
Mr. Bob Dillon is a collector of china pieces. He needs a database is to store data about his collection. Each piece in this collection is to be identified by a unique ID value. Bob knows of several agents that work on getting these pieces shown in prestigious exhibitions. Each exhibition has an ID, a name, a venue, a start date and an end date. For all items shown, there is a deadline for returning them to the item owners....
Your team of consultants has been hired to create a database for MD Employment Agency (MDEA)....
Your team of consultants has been hired to create a database for MD Employment Agency (MDEA). MDEA is an employment agency that contracts with the city of Miami, FL to assist displaced workers in finding new career opportunities and to help workers currently collecting unemployment benefits. Up to this point MDEA has been using standalone PCs to handle data entry of new clients and to update their status. The company also has relationships with local government agencies that have openings...
Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accoun...
Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible. Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time. This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data. For your final...
Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following...
Database
1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...
The Case Express Delivery (ED) is a Morgantown based home goods company. Customers can call in...
The Case Express Delivery (ED) is a Morgantown based home goods company. Customers can call in orders and ED mails the items to the customer. They also email the customers a bill, as seen below. Customers can mail in a check, once they receive the order. ED needs to track whether the order has been paid or not, but the payment information is handled by a third-party vendor. ED needs to create a database to track their customers. Each customer...
Database system QUESTION 5 Collector's Hub is a world renowned toy/memorabilia collectibles shop that was founded...
Database system
QUESTION 5 Collector's Hub is a world renowned toy/memorabilia collectibles shop that was founded in 1980. Collectors from all over the world would buy collectibles from this shop since it specializes in providing rare collectibles Collectibles such as movie memorabilia, statues, model kits, action figures and others are highly sought after by the collectors if it is rare and have a high appreciation value. The company has been managing its customers' order and sales by manual bookkeeping but,...
Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible. Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time. This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data. For your final...
Database
1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...
Database system
QUESTION 5 Collector's Hub is a world renowned toy/memorabilia collectibles shop that was founded in 1980. Collectors from all over the world would buy collectibles from this shop since it specializes in providing rare collectibles Collectibles such as movie memorabilia, statues, model kits, action figures and others are highly sought after by the collectors if it is rare and have a high appreciation value. The company has been managing its customers' order and sales by manual bookkeeping but,...
Most questions answered within 3 hours.
-
If the barometric pressure is 107.4 kPa, what is the pressure in
kPa of the gas...
asked 11 seconds from now -
State the operation or control mechanism of TRIAC, DIAC, UJT, PUT,
GTO and IGBT.
asked 53 seconds ago -
Generator An AC generator supplies an rms voltage of 220 V at
50.0 Hz. It is...
asked 3 minutes ago -
Cars enter a car wash at a mean rate of 2 cars per half an hour....
asked 15 minutes ago -
Write SQL queries to answer the following question: A. Which
students are enrolled in Database and...
asked 28 minutes ago -
Required:
How was Dell computer working capital policy as a competitive
advantage? Write at least 200...
asked 10 minutes ago -
Your eye is 2.5 m away from a 60W light bulb that emits light in
all...
asked 18 minutes ago -
As a human and using your own human Intelligent Analysis (IA),
you would have noted that...
asked 20 minutes ago -
Transverse waves on a string have wave speed 8 m/s, amplitude
0.071 m, and wavelength 0.33...
asked 34 minutes ago -
At −11°C a sample of carbon monoxide gas exerts a pressure of
0.45 atm. What is...
asked 34 minutes ago -
Aqueous hydrobromic acid HBr reacts with solid sodium hydroxide
NaOH to produce aqueous sodium bromide NaBr...
asked 48 minutes ago -
You dissolve 1.0 mole of a substance in water to a total volume
of 1,000 ml....
asked 52 minutes ago