Question:

a) Given the following relation:

Location(loc_id, bldg_code, room, capacity)

The underlined field is a primary key.

(i) Write a PL/SQL program using the implicit cursor to display the building code of location id 5.

(ii) Write a PL/SQL program that uses an explicit cursor to retrieve and display the room value for every record in the location table in which the building code value is "LIB".

(b) Write a PROLOG program that answers the question about family members and relationships. Include predicates and rules which define sister, brother, father, mother, grandchild, grandfather and uncle. The program should be able to answer queries such as the following:

- father(X,Bob)
- grandson(X,Y)
- uncle(Bill, Sue)
- mother(mary, X)