Question

IN SQL
Hotel Reservation Room Table Attribute name ATTRIBUTE DESCRIPTION Domain Range pk FK NULL Room Number Yes NO NO No Haddress location No No No No Yes type The number of the room primary INTEGER >0 key Hotel address VARCHAR(50) any The exact location of the room; VARCHAR(30) Any north tower, south tower... Type of room; big, small or VARCHAR(25) any medium The date that the room was DATE ANY reserved Whether or not the room is BOOLEAN ANY reserved No No No resrvedate No No yes Reservationroom No No No

Answer 1

Answer:

4- The SQL query is--

SELECT * FROM `Hotel Reservation Room Table`

WHERE (location="North Tower" OR location="South Tower") and Reservationroom=false;

Explanation: To print any data we use SELECT statement.Here the location is either North Tower or South Tower so we use OP operator and the room has not be reserved so it false.The table name is Hotel Reservation Room table and table name is having spaces so we enclose the table name in back ticked symbol-``.

5-The SQL query is--

SELECT Haddress,RoomNumber

FROM `Hotel Reservation Room Table`

WHERE location="west tower";

Explanation:Firstly,In SQL to print any data we use SELECT statement.The syntax is--

SELECT column1,column2,..,columnn FROM table_name WHERE condition.we will use the WHERE clause after table name any condition we want to check.Here we want two columns(attributes),those are Haddress and RoomNumber.The table name is Hotel Reservation Room table and table name is having spaces so we enclose the table name in back ticked symbol-``.In WHERE clause the condition is location is equal to west tower.

6- The SQL query is--

SELECT * FROM `Hotel Reservation Room Table`;

Explanation: It is simple.To print any data in SQL we use SELECT statement.To select all data in the table we use * symbol.The table name is Hotel Reservation Room Table.

Hope you understand and like the answer.

Thank you..