Levels of Abstraction in Database Management System(DBMS) with example, Physical level, Logical level, View level

Levels of Abstraction in Database Management System(DBMS) with example, Physical level, Logical level, View level

Levels of Abstraction

Levels of Abstraction
1.) Physical level describes how a record (e.g., customer) is stored.


2.) Logical level describes data stored in database, and the
relationships among the data.
type customer = record
name : string;
street : string;
city : integer;
end;


3.) View level application programs hide details of data types.
Views can also hide information (e.g., salary) for security
purposes.