I have done this course during the summer 2022. It is a 8 weeks course with 2 hours class per week (and homework), which covered the following topics:
- Database management
- Database creation
- Data manipulatioin
- Data visualisation
- Data analysis (e.g., groupby, joins)
- Subqueries
- Views
- Stored functions and procedures
- Events/triggers
- Backups
This repository contains all the work I have done for the final project of the course. It is a SQL database, inspired by MyAnimeList, which stores all the information about anime and users, which allows back-end stuff (e.g., sign in) and analyse the data to see the current trend in the anime world. The KaedeAnimeList.sql contains my SQL code for the project (do not worry, all the data is made-up and fake!) and Kaede presentation.pdf is the slides used during my project presentation. I used the slide template from slidecarnival, which the hyperlink will take you to the downloading page. The back up for the file can be found in dump. Below picture is my DB diagram to show the relation between the tables (I also attached pdf of ER diagram).
