You have been asked to develop a Room Scheduling application for Tiny College. This college has only one building in which to schedule rooms. The Tiny College can reserve one room per Date per faculty, for each Date the rooms are available. The rooms are reserved by Faculty name. Faculty can request a room reservation for a specific Date based on the number of seats they require. The room will be assigned by the program, faculty do not get to request a specific room. Each Date is just a specific Date. Faculty are identified by a single name. This application should have a very nice GUI interface and will be a database driven application. The database used will be Derby. This application must use good ObjectOriented Design and Programming. The database must use good Object-Oriented Design and Programming. There is a very close correlation between Object-Oriented Design and Database Design. Your application design should include at least four classes besides the main GUI class, e. g. Faculty class, Room class, Date class..., Reservations class, etc. Your database accesses should be in the classes that correlate with the database tables.
This phase of the project will implement the following user commands:
Add Faculty
A faculty member is added to the database. The faculty member is identified by only one name.
Reserve Faculty Date Seats
The faculty member will be assigned a room for the requested Date, if there are seats available. The rooms will be assigned in a best fit manner. The faculty member should be assigned the smallest room that has enough seats for their request. If there are no rooms available or no rooms with enough seats available, the faculty member will be put on the wait list for that Date. The waiting list must be maintained in the order the faculty members tried to reserve their rooms.
Status Reservations by Date
The Status command by Date will display the faculty members that have rooms reserved on that Date.
Status Waiting List
The Status command for the Waitlist will display all the Faculty members waiting for rooms. It will be displayed in Date order and then in the order of when the reservation was requested.
Testing scenario:
all the tables in the database should be empty except the Rooms Table and the Dates Table. The Rooms table should contain three rooms, such as 101 with 60 seats, 102 with 40 seats, and 201 with 20 seats, which will be used in this script. The Dates table should contain two dates, which will be expressed as date1 and date2 in this script. This scenario assumes that is the case.
The faculty names will be a, b, c, d, etc. to simplify input and this script.
The dates will be real dates but will be represented in this script by the symbolic names date1 and date2.
Script:
-Add faculty a
Note: after adding a faculty, the faculty should appear in the drop down list on the Reserve panel.
-Add faculty b
-Add faculty c
-Add faculty d
-Add faculty e
-Reserve a, date1, 20
a reserves room 201
-Reserve b, date1, 50
b reserves room 101
-Reserve c, date1, 50
c gets waitlisted
-Reserve d, date1, 40
d reserves room 102
-Reserve e, date1, 20
e gets waitlisted
-Reserve c, date2, 20