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)
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.
Step by Step Solution
3.42 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
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 ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database System Concepts
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
7th Edition
0078022150, 978-0078022159
