Question

How many levels of abstraction a typical database should hold

Answer 1

Answer on Question #81231, Programming & Computer Science / Databases | SQL | Oracle | MS Access

Question.

How many levels of abstraction a typical database should hold

Solution.

A typical database should hold 3 levels of abstraction:

Physical (Internal) level: Lowest level of data abstraction. It determines the way data is stored and organized in database.

Conceptual (Logical) level: Intermediate level of data abstraction architecture. It describes the structure of database and what data is stored in it.

View (External) level: Highest level of data abstraction. It describes user interaction with database and involves external applications to access the data for particular users.