$($a$)$ Data, information and knowledge have an important relationship and it is a

process in building the understanding on certain context.

$($i$)$ Explain the relationship between data, information and knowledge.

$(3$ marks$)$

$($ii$)$ Figure $2$ shows the order form for the customer to order Ready to Eat

pack food. Identify ONE $(1)$ way the data shown in Figure $2$ can be

transformed into information and knowledge.

$(7$ marks$)$

Figure $2$ : Ready to Eat Food Order Form

$($b$)$ Use the tables shown below to answer questions $($i$)$ to $($iv$).$ The following tables

form part of a database held in a Hotel relational DBMS:

where Hotel contains hotel details and hotelNo is the primary key;

Room contains room details for each hotel and $($roomNo$,$ hotelNo$)$ forms the

primary key;

Booking contains details of the bookings and $($hotelNo$,$ guestNo, dateFrom$)$ forms

the primary key;

Guest contains guest details and guestNo is the primary key.

$($i$)$ List all hotels.

$(2$ marks$)$

$($ii$)$ List all single rooms with a price below $20$ per night.

$(4$ marks$)$

$($iii$)$ List the names and addresses of all guests.

$(3$ marks$)$

$($iv$)$ List the price and type of all rooms at the Grosvenor Hotel.

$(6$ marks$)$