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 4: Managerial SQL-This case requires students to write SQL queries to answer nine managerial accounting questions. Students also generate and answer their own questions. The SQL queries are more complex than the basic SQL case and can be categorized as intermediate to difficult.
Suitable courses: Accounting information systems; Auditing (external or internal); Data analytics; Fraud; Managerial
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.
Grav was with by Trilby Media.