Planning and Methods

[139037]

First of all we will have to be in contact with the medical centers from where we will take the information in order to understand the whole procedure including every detail from the first day when a person register in the medical center till to the blood test, diagnoses and appointment. Taking this information is an important issue because this way it will be easier to implement the database and the application in general.

Before implementing the application it will be necessary to make some analysis in order to ensure how it will work.

UML offers very good possibilities to achieve this goal.
Before implementing the database it is very important to design an E-R diagram in order to see the relationships that exist between the entities.
Then the ER diagram will be transformed into relational model in order to have a clear view about the tables that will be implemented in Access.
After the implementation of the database in Access it will be important to make it possible for the members of the center to have access to that database, so to achieve this it will be needed a windows application.

I start with creating the E-R Model → Relational Model → Database and then the visual parts of the project i created by using Visual Basic .NET.

In access the database is consisted of 4+1 tables: tblPatients, tblExaminatin, tblLab, tblAppointment and also table of login.

After i finish the visual part of project I attach the VB with database in Access.