PART A 13 MARKS DATA MODELLING QUESTIONS Students are required to answer ALL questions from this part. Questions 1 and 2 in this part relate to the ER model given below. The ER model illustrates the entities and relationships for modelling a bank loan service. Assume the bank has two types of staff administration officer (abbreviated to Admin) and loan officer. Clients borrow money from the bank. Examine the ER model below and answer all the questions that follow questions in this section relate to the ER model given below.

Question 1

Data Modelling According to the ER model given above, answer either yes or no to the following questions: (a) Can a loan officer have more than one qualification? (1 mark)

(b) Can a loan officer serve more than one client? (1 mark)

(c) Can a bank staff member be both an administration officer and a loan officer? (1 mark)

(d) Is it possible for a client to have no loans? (1 mark)

Question 2

Converting ER models Convert the ER model given in Part A into a set of relations that satisfy Third Normal Form (3NF). You do not need to show your workings. You do not need to justify that they are in 3NF at this stage. You do not need to show sample data. Just show your relations. You should write your relations in either format shown below:

Question 3

Relational model and Normalisation The following table identifies the information that doctors in a hospital made treatments for patients. You may assume that the combination of PatientID, DoctorID and TreatDate uniquely identify each row/tuple in this relation.

ER model: STAFF StafflD OfficeNo Phone StaffType StaffType- "L ADMIN ServiceArea LOANOFFICER Qualification) PrivilegeLevel serve CLIENT BORROW BorrowlD LOAN ClientNo Name Address Annuallncome LoanNo LoanType InterestRate Amount