We continued working on database theory (reading database schemas and basic normalization principles). We used these knowledge to generate queries that related to operational needs of a company. We emphasized the need to be able to translate an English question to SQL and vice versa and its importance in the auditing process.
In week 10, we will focus on the database schema of one of the cases (GRT) and use it to understand the role and functionality of ERP systems with a company.
Topics and Readings for Week 10
Theory: Read chapter 6 (enterprise systems).
Seminar: In our seminar we will continue working with sql queries. We will some applications of SQL in the context of auditing (fraud detection).
Assignments for Week 10
The online quiz will be a based on chapters 6, and material from the seminar. The quiz will be available on Friday at 12:30 pm.
