QUESTION 4 [25 Marks] Referring to Figure 1, write statement to create the Hotel table using the
Fantastic news! We've Found the answer you've been seeking!
Question:
QUESTION 4 [25 Marks]
- Referring to Figure 1, write statement to create the Hotel table using the integrity enhancement features of SQL.
(8 Marks)
- Write SQL statement using the Data Defination Language (DDL) or Data Manipulation Language (DML) with the following questions:
- Create an INSERT statement to add the tuple of data to the HOTEL table from the following sample data. (7 Marks)
Hotel Number | Hotel Name | City |
H001 | Sunshine Bay | Tanjung Karang |
H002 | Mayang Sari | Port Dickson |
H003 | Corus Jumbo | Air Keroh |
H004 | Eagle Ranch | Johor Bharu |
- Change the hotel name of H003 to Classy Jumbo. (2 Marks)
- Modify the City of H001 to Kuala Kubu (2 Marks)
- Delete Eagle Ranch from HOTEL table (2 Marks)
- Create a view containing the hotel name and the names of the guests staying at the hotel.
(2 Marks)
- Give the users Manager and Director full access to these views, with the privilege to pass the access on to other users.
Related Book For
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg
Posted Date: