Creating a physical relational database based on our imaginary but realistic entity relationship diagram (ERD), inserting data, and solving queries. Creating two triggers: (1) one for updating and (2) a trigger that inserts a row in a “log” table.
Our database was meant to describe a scenario for scheduling medical appointments in Portugal. The purpose of this was to facilitate the scheduling of clinical arrangements through a platform that has all the information that the medical analyst needs to plan those appointments. table.