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

Room four

Matt Hetland

Two days

150

Room five

Max Bing

Three days

225

Room six

Laura Paul

One day

Room seven

Sue Wilt

Two days

180

Room eight

Terry Klemp

One day

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

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!

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...

In java I have to do the following: Create a file named Dao.java: Dao.java -Include the following class fields, constructor //Declare DB objects DBConnectconn = null ; Statement stmt = null ; //...

io (a) Give the general formula for estimating transition probabilities from training data. Provide the full transition matrix A for this HMM based on the training data shown. [6 marks] (b) Give the...

1. Introduction to Computer Architecture concepts; The MIPS R2000 architecture allows for up to four external coprocessors. Our local systems arIPS external coprocessors are used by describing, in...

Write a java class called Event.java representing an event set up in someone's calendar. This class should store three bits of information about the event: What is the title of the event (a String)...

Java Programming Assignment: An Introduction to Java Classes Implement a simple command line application that prompts the user for a name, and prints it in Bond, James Bond form. Your application...

1 Constructing a Hash Table Create a hash table class: public class HashTable From there, build a hash table of an \"optimal\" length that you choose (around 100, but not more than 150). The hash...

User To all Comp2310 students (All Sections), Many of you asked about the methods moveChairForward/Backward. You should implement those by simply subtracting/adding the distance passed to the method...

Page replacement public class KernelFunctions { //****************************************************************** // Methods for supporting page replacement...

Can you help again?? Java class Create a program called Loan Amount. This will display how many months it will take to pay off the loan. The program needs the purchase cost, the annual interest rate...

Boustred, a Colorado resident, purchased a replacement main rotor holder for his radio-controlled helicopter from a retailer in Colorado. The main rotor holder was manufactured by Align Corporation,...

Consult Paragraphs 11-12 of PCAOB Auditing Standard No. 15. Identify one relevant financial statement assertion related to the revenue account that is impacted by an IRU swap. Why is it relevant?

Absorption costing net operating income is GREATER than variable costing net operating income when?

Suppose that you were asked to select a material for a spherical pressure vessel to be used in an aerospace application. The stress in the vessel wall is =2tpr where p is the internal pressure, r is...

Go to the website of the Federal Reserve Bank of St. Louis (http://www.stlouisfed.org) to find some information about the Fed. Find a map of the Federal Reserve districts. If you live in the United...

Suppose that the T-account for First National Bank is as follows: Assets Liabilities Reserves $100,000 Deposits $500,000 Loans 400,000 a. If the Fed requires banks to hold 5 percent of deposits as...

Imagine that you intend to buy a portfolio of ten stocks with some of your savings. Should the stocks be of companies in the same industry? Should the stocks be of companies located in the same...