Objective:
In this project we created a database system that if implemented would contribute to the effort to immunize the Panamanian population against Covid-19. We presented: the conceptual data model, through an Entity Relationship diagram; the logical data model or Relational Model; and the physical design of the database, which contains: the creation script of tables with all the necessary constraints to maintain the integrity of the data, the database diagram created (generated by the controller), and the code with inserting data with a minimum of 10 records per table for testing. In addition, we implement views, procedures, triggers and cursors as requested in the case study.
Technologies used in the development of the project:
Development tool: Microsoft SQL Server
Deployment environment: Command-Line Interface
Project management: Microsoft Teams & Microsoft Word