Tools

Java, SQL, Azure

Context

Database Sytems (CSE 414) Final Project

Timeline

1 week (Spring 2022)

Group

Individual Project

Project Introduction

This application ran on the command line terminal, and connect to a database server you created with Microsoft Azure. In this assignment we were tasked with programing part of an appointment scheduler for vaccinations, where the users are patients and caregivers keeping track of vaccine stock and appointments.

Part 1: ER Diagram

First, I completed the design of the database schema with an E/R diagram and create table statements. I created four tables: Patients, Appointments, Caregivers, and Availabilities.

Part 2: Java Implementation

In this stage, I implemented the code that stores Patient information, and lets users interactively schedule their vaccine appointments. In the Scheduler.Java file I implemented the following methods: createPatient, usernameExistsPatient, createCaregiver, usernameExistsCaregiver, loginPatient, loginCaregiver, searchCaregiverSchedule, reserve, uploadAvailability, addDoses, showAppointments, and logout.

My code implementation on GitHub can be found:

1. Create Table Statements: vaccine-scheduler-java-main --> src/main --> scheduler --> model

2. Java Implementation: vaccine-scheduler-java-main --> src/main --> scheduler --> Scheduler.java