───✱*.｡:｡✱*.:｡✧*.｡✰*.:｡✧*.｡:｡*.｡✱ ───

Detailed Contribution Reports

I mainly contributed with the design of the database, including the ERD as well as procedures and functions related to the database. For instance, I made (most of) the stored procedures, and I made some design choices for validation for instance, which Russell implemented within the database whenever he made the creation script.

Learning Outcome Reflections

I learned a lot about managing databases, particularly with error handling. Since this was a database that was intended to be used by others, we had to make sure that the database was user friendly. This means that we had to implement a lot of error handling through transactions to handle if the data was valid for instance. Moreover, it was a learning experience learning how to create an actual database from scratch like this, rather than building it from something that has already been provided—like the previous labs.

Challenge Resolution Documentation

Whenever I (or my team) would encounter a challenge, we tried to communicate together to make sure we have a common idea or goal. For instance, whenever we had challenges on which constraints we should add, me and Russell (the rest of the team too) had a conversation about the constraints and we decided on what we should do.