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. 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
Room two
Jeff Hanson
Room three
Kali Jacobson
Room four
Matt Hetland
Room five
Max Bing
Room six
Laura Paul
Room seven
Sue Wilt
Room eight
Terry Klemp
Room nine
Seth McLaughlin
Room ten
Colleen Weiland
Room eleven
Jason Quam
Room twelve
Willow Damon
Room thirteen
Clint Watson
Room fourteen
Mark Laten
Room fifteen
Grant Hyland
Room sixteen
Jaden Waldron
Room seventeen
Doug Hill
Room eighteen
Courtney Fisher
Room nineteen
Kayla Swenson
Room twenty
Jasmine Richards
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