1. What is functional dependency, partial functional dependency and transitive functional dependency?

2. Why normalization is important for database design?

3. What are the two typical structure arrangements?

4. Write a pseudocode for the sorting algorithm (i.e., put a list of numbers into an order).

II. (1 mark) SQL advanced SQL

a) Declare a cursor of the room table containing all hotel numbers and hotel names

b) Open the above cursor and use it to generate the hotel numbers and names one by one

c) Release the above cursor

d) Create a stored procedure to update the room prices in hotel Hilton by 6% and in other hotels by 4%.

e) Use the above procedure to update the room prices.