















Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Database Architecture, Data Independence, DBMS functionalities, Three levels, Objective, Physical representation, Refers to permanent structure are the main points of this lecture.
Typology: Slides
1 / 23
This page cannot be seen from the preview
Don't miss anything!
Database Architecture
Data Independence
A basis for understanding DBMS functionalities
Three levels at which data can be described
Separate users view from the physical representation
Why? Different views of same data Consolidated representation Both ways easy change
Depicted by three schemas or three models
Refers to permanent structure or intention of database
Level 1 External View
The way users think about data
External View
Users may have different views of the same data e.g. date, time etc.
External View
Virtual/calculated data: that is not actually stored in the database but is created when needed e.g. age, statistical data etc. Docsity.com
External View
User’s external view is created after considering data access, reports, and the transactions needs.
External View
External schema evolves as user needs are modified over time
Level 2 Logical or Conceptual View
A complete description of the information content of the database
Conceptual Schema
The entire information structure of the database, as seen by the DBA The community view of data
Conceptual Schema
Contains record types representing entities, data item types with their attributes, relationships and constraints on data.
Conceptual Schema
Contains Semantic information about the data meaning, security and integrity information