The Relational Model and Logical Design

(a) In the context of the relational data model, describe the following terms:

(i) relation 

(ii) primary key 

(iii) foreign key 

(iv) null                                                                                                                  (12 marks)

Question 2

Normalisation

(a) Explain the following data dependency terms and give examples from the student relation below:

(i) Functional dependency 

(ii) Full functional dependency 

(iii) Partial functional dependency 

(iv) Transitive dependency