Room Scheduler Project Final PhaseFinal Project Test Script This is a scenario that you can use to test your final project. It is not an exhaustive test but tests almost all of the conditions your program should handle. When you submit your final project all the tables in the database should be empty. 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 -Add faculty b -Add faculty c -Add faculty d -Add faculty e -Add faculty f -Add faculty g -Add room 101 60 seats -Add room 102 40 seats -Add room 201 20 seats -Add date any date will be referred to as date1 -Add date any other date will be referred to as date2. -reserve a date1 20 seats -reserve b date1 50 seats -reserve c date1 30 seats -reserve d date1 20 seats -reserve e date2 100 seats -cancel a date1 -Status date1 -Status Waitlist -reserve f date1 20 seats -Status Waitlist -add room 202 100 seats -Status Waitlist -Status date1 -reserve g date2 200 seats -Cancel g date2 -reserve f date2 20 seats -Drop room 201 -Status waitlist -Status date1 -Status date2 -Status faculty f General conditions of testing: I will provide the code that I already made for the initial phase of the project but I need help with the final phase of the project which is based off the initial phase. I will provide the rubric instructions and additional material to help solve this assignment. Please check the final project grading rubric to know what to satisfy and name the code file RoomSchedulervas5260 and the database folder RoomSchedulerDBvas5260 (similar to the initial phase compressed zip folder I provided which has the code I used for the initial phase and the database folder I used for the initial phase). I need this done in java and thanks in advance! Also there are a few videos and materials I havent uploaded because I am unsure if you will need them but if you need any help you can just ask if I have any materials for whatever area you need help with and If there are materials to help you out I will upload them thanks. I may have to email it to you if there are too big. PS. Its up to you if you want to use my initial phase and do the final phase or do both. And I stored the database file in a folder called Derby Databases and you will need to use my PSU id to name the files for the project which I mentioned above as well. The videos I provided is to help you finish the project because the final phase which is what I need is based off the initial phase if the video mentions about programming assignment 6 that is for the initial phase by the way. So some videos and materials are used to finish the initial phase (programming assignment 6) and then there are some more videos and materials to finish the final phase.