Database Chapter 2

Question 1

Three Level Architecture

Answer 1

1.External Level
2.Conceptual Level
3.Internal Level

Question 2

External Level

Answer 2

Users’s view of the database

Question 3

Conceptual Level

Answer 3

Desribes what data is stored and relationships among the data

Question 4

Internal Level

Answer 4

Describes how the data is stored physically in the database

Question 5

Three Level Architecture advantage

Answer 5

1.User’s view is immune to changes made in other views
2.User should be able to access the same data
3.Internal structure should not be affected when changes are made to physical aspects of storage
4.Conceptual level can be change without affecting all users