database systems
assisted two groups of four students in constructing their final thesis in constructing database systems and data mining
The final thesis consisted of reviewing a case study about a supermarket firm, continued with formulating a solution based on database systems using SQL and data mining with R:
- Construction of Entity Relationship Diagram for the business function of the firm;
- Reviewing SQL Statements for database creation;
- Reviewing the Exploratory Data Analysis steps using SQL;
- Reviewing insights acquired from the data mining process using R; and
- Reviewing the solutions towards the current business process of the firm.