Instructions: \"Create sql to do the following: a) Drop the PROPERTY table w/cas

Question

Instructions:

"Create sql to do the following:

a) Drop the PROPERTY table w/cascade constraints. (Note:you may give your tables other names, as long as I can easily understand what each is for.)

b) Create a HOTEL table to hold Property information for a hotel database. You will need to determine what field(s) the table should contain.

c) Insert a few rows into the table.

d) A select statement that displays the rows inserted

We will be testing your sql by running the same sql file(s), so you need to ensure that it runs correctly from start to finish and allows me to run it multiple times in succession"

Explanation / Answer

Save as file: hotel.sql

a)

c)

insert into HOTEL values (H101', 'Grosvenor Hotel‘, 'London');

insert into HOTEL values (H120', 'Majestic Hotel‘, 'Paris');

insert into HOTEL values (H143', 'Aroma Hotel‘, 'Amsterdam');

insert into HOTEL values (H133', ' Hotel Royal‘, 'NY');

insert into HOTEL values (H141', 'Novelty Hotel‘, 'Rome');

d)

Select * from HOTEL;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.