Question
Create a SQL table in java class that does the following: The class in java is called Calendar. This is supposed to be used in
Create a SQL table in java class that does the following: The class in java is called Calendar.
This is supposed to be used in a hotel system. Take in new reservations and keep a calendar, or SQL table, of room reservations updated with new reservations. Attach customers' names to the specific room number they would like to stay in and give the customer information on where they are staying. Make a SQL table that keeps track of the person and the room they are in, and for how many days, and the price.. The SQL table is called Reservations.
The room number with the name attached to it is in a text file called Hotel Rooms. The text file can be imported into the class and then put into the table, or manually put into the table. Here is the text information:
Room one
Mary Jensen
Two days
150
Room two
Jeff Hanson
Three days
225
Room three
Kali Jacobson
One day
75
Room four
Matt Hetland
Two days
150
Room five
Max Bing
Three days
225
Room six
Laura Paul
One day
90
Room seven
Sue Wilt
Two days
180
Room eight
Terry Klemp
One day
90
Room nine
Seth McLaughlin
Three days
227
Room ten
Colleen Weiland
One day
115
Room eleven
Jason Quam
Two days
230
Room twelve
Willow Damon
One day
115
Room thirteen
Clint Watson
One day
115
Room fourteen
Mark Laten
Two days
230
Room fifteen
Grant Hyland
Two days
260
Room sixteen
Jaden Waldron
One day
130
Room seventeen
Doug Hill
Three days
390
Room eighteen
Courtney Fisher
One day
130
Room nineteen
Kayla Swenson
Two days
260
Room twenty
Jasmine Richards
Two days
500 dollars
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started