Adventure-Works-Cycles
AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles.
Microsoft highlight SQL Server features with the AdventureWorks Database, various versions of which can be downloaded at the SQL Server community projects. AdventureWorks Database is also used in code examples found in SQL Server documentation and books. There are also versions for SQL Azure and SQL Server 2005.
This database is used in the Generation UK&I interim project. The following business problems need to be answered.
Customer Question
- What are the regional sales in the best-performing country?
- What is the relationship between annual leave taken and bonus?
- What is the relationship between Country and Revenue?
- What is the relationship between sick leave and Job Title?
- What is the relationship between store trading duration and revenue?
- What is the relationship between the size of the stores, number of employees and revenue?
This project includes
SQL Codes: