2 a) Using appropriate diagrams and examples describe the concept of ANSI-SPARC database architecture, illustrate the principles
Question:
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.
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan