2023年11月25日

Java代写 | Room Scheduler Initial Phase

本次Java代写是开发一个Room Scheduling应用程序，通过程序来合理分配房间的使用时间

Room Scheduler

Initial Phase

 

This is the first half of the final project. 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:

A testing scenario will be provided to assist you in testing this application.

Database considerations:

The Rooms Table should be preloaded with several Rooms such as 101, 102 and the number of seats in the room. You should have a different number of seats per room so that you can test the proper reservation of rooms for different class sizes. You will be shown how to preload tables with values.

The Date Table should be preloaded with several Dates of your choice. These are just normal Dates.

The database tables should not contain redundant data, i.e. relevant data should only appear in one table.

GUI Guidelines:

The user should be required to enter only unknown data. Drop down lists of known data such as Faculty member names, Room names, or Dates should be displayed for the user to select. Combo Boxes should be used for the drop-down lists on the form. When information is requested to be displayed e.g. for a Status command, all of the requested information must be displayed. When a command is performed, the results of that command should be displayed to the user on the same display without the user needing to check Status to see what was done.

For this project, you may, and I recommend, the use of the GUI designer in NetBeans.

 

Note: A good example to use for how to program this project is contained in the programming examples in Figures 24.30, 24.31 and 24.32 in Chapter 24 from our book.

Final Phase

This assignment is the final half of the project. The final project is a continuation of Initial Phase. This phase of the project will additionally implement the following user commands:

Add Room Seats

Add a new Room to the system. The Room name is a string and Seats is the number of seats in the Room. When a room is added, the wait list must be searched for any faculty waiting for a room for all Dates that rooms are reserved and reserve the room for them and remove them from the waiting list.

Add Date

Add a new Date that rooms can be reserved to the system.

Cancel Reservation Faculty Date

The reservation for that Faculty member and Date must be removed from the Room’s reservations or the waiting list. If the reservation is removed from a room, the waiting list must be checked to determine if another Faculty member can be booked for that room for that Date, checking the number of seats requirement, of course.

Status Faculty member

The Status command for a Faculty member will display the Room and Date for each room the Faculty member has reserved and/or is waitlisted for.

Drop Room

The Drop command must remove a room from the application. Any faculty members that had this room reserved for any Date will get another room reserved for that Date if possible, in priority sequence, and the new reservation reported to the user. If the faculty member cannot get a new room reserved, the user is informed that the faculty member could not get a new room reserved and that they have been placed on the waitlist.

Testing scenario:

A testing scenario will be provided to assist you in testing this application.