#Assignments on adventureworks database pdf#
#Assignments on adventureworks database code#

Microsoft created this company and its databases (an OLTP database and a Star Schema Data warehouse) to assist people in learning about database technologies.ДЄdventure Works produces and distributes metal and composite bicycles to North American, European, and Asian commercial and consumer markets. The AdventureWorks data warehouse is based on a fictitious bicycle manufacturing company named Adventure Works Cycles. For the year 2003, which model of bike (ModelName) yielded the highest margin for AdventureWorks?.HINT: you can format the output of a numeric column like this: format(sum(UnitPrice),2) In which year and month were bike sales to females the highest? List and compare the total sales quantities of bikes sold (all model types) by customer gender by year and month.In what year were the sales of RoadBikes the highest? List and compare the total sales dollar amounts of the three model types of bikes sold by AdventureWorks for the years 2001 вЂ“ 2004.What are the three model types (EnglishProductSubCategoryName) of bikes sold by AdventureWorks?.What do you think is the purpose of the recursive relationship on DimEmployee?.What standard table naming convention did the AdventureWorksDW database designers use to differentiate dimension tables from fact tables in this star schema data warehouse?.The row count for each table is in TABLES.The TABLES table contains columns TABLE_NAME and.There is a table within information_schema called.Use the information_schema to find out how many rows there are in the internet_sales_fact.How many rows are there in each of the dimension tables in this star schema? List the dimension table name and its row count.If you attempt a query and it looks right but doesnвЂ™t work, be sure that the case used in naming database objects in your SQL exactly matches object names on the server.Д«e sure to read вЂњHints regarding the dataвЂќ on page 4 of this document prior to attempting to answer these questions. This is a Linux server and Linux commands are typically case sensitive. If you did work with a partner, be sure to specify your partnerвЂ™s name on the document you submit.

However, this is an individual assignment each one must submit your own final deliverable for this assignment. You may work with a partner on completing this assignment.

#Assignments on adventureworks database pdf#

Save the document as a PDF and submit your PDF using the Homework # 5 link in the Moodle page for assignment section of вЂњWeek TwelveвЂќ in Moodle which is the same place where you found this file.

Where the question requires a written answer, please submit proper sentences explaining your answer to the question.

#Assignments on adventureworks database code#

Where the question requires SQL, submit both your SQL code and your answer set.Answers must be clearly identified and numbered according to the questions below. Compose answers to the questions assigned below in a document.Create and run queries against the warehouse to analyze AdventureworksвЂ™ business.Create and run queries against the warehouse to answer questions about the content of the warehouse.Study the database and answer questions about its structure.Using a SQL query editor (such as MySQL Workbench).Examine the Adventureworks Data Warehouse to become familiar with the structure of a realistic star schema data warehouse.Create a connection to the Adventureworks Data Warehouse (вЂњawвЂќ) on a shared server.This assignment will give you hands-on practice in working with a realistic data warehouse. Your assignment submission should be a document saved and submitted as a PDF file via the link found in the assignment section of вЂњWeek TwelveвЂќ in Moodle which is the same place where you found this file. It is due on Sunday November 24th, at 11:59 p.m. This Project is worth 100 points (out of 1000) toward your final grade.