1. In logical database design, why there is a need to introduce a new relation for many-tomany relationship in ERD?

2. Describe how to convert a generalization/specialization in ERD into relations in GRD.

3. What are user interface and system interface respectively?

4. List at least 4 typical menu types and discuss their advantages and disadvantages.

5.Write an SQL statement to create a view about the hotel numbers and hotel names.

6. Write an SQL statement to insert the staff numbers and names into the guest table.

(1 mark) SQL other statements in basic SQL

a) Create a view to check the hotel name, room number and the guest names who booked the room

b) Select everything from the view created above

c) Drop the above view

d) Create a view to check the hotel number and hotel names and the number of rooms they have.

e) Create a view to see the pair of room types and prices.

f) Create a view to see the distinct pair of room types and prices.

g) Create an index of room types and prices on the room table

h) Drop the above index

i) Create an index of the guest names

j) Create a new table including hotel information (i.e., hotel names and numbers) from the room table; k) Backup the room table

l) Insert the staff numbers and names as the guest numbers and names into the guest table. If not successful, why?