2 a) Using appropriate diagrams and examples describe the concept of ANSI-SPARC database architecture, illustrate the principles of logical and physical data independence. 

2 b) Describe referential integrity and how you would represent it in a relational model. 

2 c) Identify and describe the 5 (five) major duties of a database administrator. 

Question 3

3a) Differentiate between Data Control Language and Transaction Control Language 

3b) Use examples to differentiate: (i) Truncate and Delete [4] (ii) Composite Attribute and Multivalued Attribute [4] (iii) Cardinality and Relationship 

3c) Identify and explain five (5) key characteristics of a relational model. 

Answer rating: 100% (QA)

Question 2 2a ANSISPARC Database Architecture The ANSISPARC American National Standards Institute Standards Planning and Requirements Committee database architecture is a framework that was developed ... View the full answer