TODO list database design
This project is my latest among others, consisting of two parts: the first part is individual, and the second part is done in pairs and submitted last January 7th. We developed a database for a task list management application ("to-do" list). This database allows users to define and manage their tasks.
First part:
Modeling:
I designed the entity-relationship model of the database using online tools, while specifying integrity constraints. I also established the relational logical model of the database.
Database implementation:
I proceeded with the creation of SQL scripts for table creation, deletion, and insertion of test data. A script allowing the execution of all other scripts to recreate the tables if necessary and fill them was also created.
Second part:
In this second part, my partner and I wrote SQL queries to interact with the database while defining indexes to optimize them. Additionally, we defined PL/SQL procedures and functions that could, for example, calculate the number of points gained/lost for a user. We also defined triggers for score updates, deletion of completed tasks, etc.