This case series focuses on data normalization and writing SQL queries of a relational database to answer accounting questions. The real-world data represents travel expenses of Canadian government workers. These cases can each be assigned independently, or they can be sequenced to provide an overview of relational databases and introduce SQL queries.
Case 2: Basic SQL-This case has 20 SQL problems that vary in difficulty. All of the queries are SELECT queries. The initial queries are very basic and then build to more complex queries.
Suitable courses: Accounting information systems; Auditing (external or internal); Data analytics; Fraud; Managerial
Link to download files (requires login)
Join EYARC for Full Access
EYARC Experience
Turn case studies into powerful teaching moments for your students. Active EYARC users can explore our experiential learning platform to access cutting-edge curricula and innovative teaching resources.
Try It NowAcademic Case Materials
Access free resources to prepare students for the global marketplace. Resources include case studies, data sets, analytics workbooks, videos and many other tools focused on business and accounting topics.
To search by multiple tags, enter the search word followed by a comma and the next word, etc.
For example, entering "Audit, Excel, Intermediate" will list cases related to audit AND Excel AND intermediate difficulty.
To search by a single tag, enter it in the search box or click on the tag below in the Popular Tags area.
