UploadLanguage (EN)Support
BusinessMobileSocial MediaMarketingTechnologyArt & PhotosCareerDesignEducationPresentations & Public SpeakingGovernment & NonprofitHealthcareInternetLawLeadership & ManagementAutomotiveEngineeringSoftwareRecruiting & HRRetailSalesServicesScienceSmall Business & EntrepreneurshipFoodEnvironmentEconomy & FinanceData & AnalyticsInvestor RelationsSportsSpiritualNews & PoliticsTravelSelf ImprovementReal EstateEntertainment & HumorHealth & MedicineDevices & HardwareLifestyle
Upload
Sign in
Adeel Rasheed, profile picture
Uploaded byAdeel Rasheed
PPTX, PDF7,111 views

3 Level Architecture

The document discusses the three levels of database management system (DBMS) architecture: the internal level, conceptual level, and external level. The internal level defines how data is physically stored. The conceptual level describes the overall database structure and hides internal details. The external level presents different views of the database customized for specific user groups.

Education◦
Downloaded 245 times
1 / 8
2 / 8
3 / 8
4 / 8
5 / 8
Most read
6 / 8
Most read
7 / 8
Most read
8 / 8
 BY: Adeel Rasheed For More Slides: https://chauhantricks.blogspot.com/
 Three levels or layers of DBMS Architecture are:  External Level  Conceptual Level  Internal Level Architecture of DBMS

  Physical representation of the DB on the computer.  How the data is stored in the database?  At lowest level, it is stored in the form of bits with the physical addresses on the secondary storage device.  At highest level, it can be viewed in the form of files.  The internal schema defines the various stored data types. It uses a physical data model. Internal Level
  Conceptual level describes the structure of the whole database for a group of users.  It is also called as the data model.  Conceptual schema is a representation of the entire content of the database.  These schema contains all the information to build relevant external records.  It hides the internal details of physical storage.  It Represents:  entities, attributes, relations Conceptual Level
  The user’s view of the database.  Consists of a number of different external views of the DB.  Describes part of the DB for particular group of users.  The user is not aware of the existence of any attributes that are missing from the view.  It permits users to access data in a way that is customized to their needs, so that the same data can be seen by different users in different ways, at the same time. External Level
3 Level Architecture