This is a jdbc client project from my early days as a Computer Science student
This programm was created for the fourth semester class Data Bases and is the final project for the class
A jdbc application that runs queries in pgAdmin to simulate the functionality of a hospital's database.
- The database saves information about the hospital's doctors of a variety of departments
- The database saves doctors' information are (name, surname, specialty, contact information, department code, etc.)
- The database saves the hospital's patients and their information (name, surname, contact information, etc.)
- The database saves the appointments and the diagnosis for each patient and information and date about them
- The database saves each patient's medical record, including treatments and prescription drugs
- There is a predetermined dataset used for this project
- Design the relational scheme of the database and implement the creation queries in the PostgreSQL DMBS
- Apply the normalization theory to the relational scheme of the DB to check if it follows 3NF or BCNF
- Insert the data from the given dataset using proper queries
- Implement some functionality using proper queries:
a. What are the drugs (maximum and minimum number) prescribed
b. What are the diagnoses of the last week
c. What are the doctor's 'X' appointments last month
d. Who are the patients who have seen more than one doctor
e. From what department have most patients been examined
f. What is the average number of patients examined per department
- Implement some functionality using triggers:
a. Creation of trigger and function that will execute for every patent examined and diagnosis to update patient's medical file
b. Creation of trigger and function that implement's the query d)
- Connect databse with JDBC client in Java using the proper library
- Write a Java console application that will execute the queries
- There is a predetermined dataset used for this project
- The comments to make the code understandable, are within the archives
- This project was written in Eclipse Java IDE
- This repository was created to show the variety of the work I did and experience I gained as a student