In$-$Class Hands$-$On Activity: Using the AdventureWorks Database as an ERP System

Objective: Students will simulate how an ERP system integrates various business functions using the AdventureWorks database. Each student or group will assume the role of a department $($Accounting$,$ Sales, Operations, etc.$),$ using SQL queries to perform their specific tasks based on a customer order placed through the company$$s website.

Scenario: A customer has placed an order for a new product through the company$$s website. Each department must work together to process the order, manage resources, and ensure customer satisfaction.

Department Roles and Tasks:

Accounting:

Task: Generate an invoice, update the profit and loss statement, and ensure payment reconciliation.

Query:

Did Human Resources play in managing employee work hours and payroll in the ERP system?

Based on your experience in this simulation, what are some of the key benefits of using an ERP system in a real$-$world business setting?