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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!