Base De Datos Covid

The Las Mercedes Communal Hospital of the municipality of Florencia Caquetá, requires systematizing the information related to vaccines for citizens who come to the hospital to avoid the spread of the COVID-19 virus that is currently present. For this, the hospital needs to register users who are potential beneficiaries of the vaccine according to the levels established by the government. For this, the registration must be made for each user where the type of vaccine to be applied and the estimated date for the second dose (if applicable) is established.
Additionally, the user must be registered depending on the age group and category in which they are. The hospital has 3 officials who have access to the system (1 epidemiologist and 2 nursing assistants).
The application must comply with the following:
• Registry of officials: Register an official by registering their personal data.

• Consultation of officials: Consultation by identifying their personal data.
• Update an official: Updates the information of an official in the database.
• User registration: Register a user by registering their personal data.

• Consultation of users: Consultation by identifying their personal data.
• Update users: Updates the information of a user in the database.
• Record for each user to be vaccinated: Record the dose of the vaccine applied and the date of the next dose, if applicable.

• Generation of reports of vaccinated according to each type of vaccine: Generation of reports of vaccinated users according to the type of vaccine and according to the population group in which the users are found.
• Finally, when executing the application, it must request a Login and Password to guarantee the security of the application and access only to authorized personnel. Employees must bear in mind that the following characters are not allowed in the password: $,%, &, /, *, /, -, ñ so it is mandatory to use the exception blocks in Java to avoid these characters .

For the development of this project, the object-oriented paradigm must be used (classes, inheritance, polymorphism, encapsulation, etc.), Likewise the MYSQL database must be used as the default database.

The activity consists of:
Make the query on inheritance and polymorphism.
The inheritance and polymorphism query comprises:
-Inheritance and Polymorphism
-Simple inheritance2
-Multiple inheritance
-Inheritance of Interface
-Inheritance of Implementation
-Polymorphism and reuse
-Overload
-Polymorphism in inheritance hierarchies
-Polymorphic variables
Then in a document he presents the inheritance model to apply in his project. In this model, each of the classes must be specified according to the class model, subsequently, inheritance must be implemented by determining which is the parent class that remains and which are the child classes that will inherit the attributes.

After modeling, you must implement model inheritance in the object-oriented programming language in the selected project.
Design the database in a database engine such as MySQL and then establish the connection with the selected project.
Finally, you must add the SQL statements necessary to enter, query, update or delete data from the project to the database created.