Database Architecture: DBMS Class Notes

Updated: Aug 18

Mobiprep has created last-minute notes for all topics of Database Architecture to help you with the revision of concepts for your university examinations. So let’s get started with the lecture notes on Database Architecture.

  1. DBMS

  2. Data Modelling

  3. Database Architecture

  4. Relational Model

  5. Backup and Recovery

  6. Functional Dependencies

  7. Normalization

  8. Deadlock

  9. Transaction and Concurrency Control

  10. Files and Storage

  11. Relational Algebra

  12. Entity Relationship Model

  13. Indexing

Our team has curated a list of the most important questions asked in universities such as DU, DTU, VIT, SRM, IP, Pune University, Manipal University, and many more. The questions are created from the previous year's question papers of colleges and universities.

  1. Define Data Abstraction.

  2. What are the three levels of Abstraction in DBMS?

  3. Explain the two tier architecture of DBMS.

  4. Explain the three tier architecture of DBMS.

Database Architecture

Question 1 - Define Data Abstraction.

Answer - Data Abstraction is the process of hiding the background and implementation details that are irrelevant to the end-user. Data abstraction allows the user to view only the essential information. Using data abstraction, the user can easily interact with the database, without knowing the database implementation.


Question 2 - What are the three levels of Abstraction in DBMS?

Answer - There are three levels of database abstraction. They are:

  1. Physical level - The Physical level is the lowest data abstraction level. It deals with the physical storage of data in the disks or some other secondary storage devices. It explains the ordering of records on the disks and the different indexing methods used. This level is usually hidden from the application programmers.

  2. Logical Level or Conceptual Level - This level deals with the organization of data (generally in the form of tables). It deals with the attributes and records of the tables, and also the relationship between the tables. Details of the physical level are removed at this level using abstraction. This level is used by Database Administrators and Application programmers.

  3. View level - The View level is the highest level of abstraction. It provides the abstracted view tailored to a user. All the internal implementations of the database are abstracted in this level. The data is presented in a useful form for each user.

levels of Abstraction in DBMS
Levels of Abstraction


Question 3 - Explain the two tier architecture of DBMS.

two tier architecture of DBMS

Answer - The DBMS Two-Tier architecture is similar to the Client-Server model. The user application programs are on the Client side, and the database is one the server side. Here, the user application can directly communicate with the Database Server, by establishing a communication link. The two tier architecture can be understood clearly from the following block diagram.


Question 4 - Explain the three tier architecture of DBMS.

three tier architecture of DBMS

Answer - The DBMS Three-Tier architecture consists of three major components. They are:

  1. Client-side application (or) user interface

  2. Server-side application

  3. Database system

Here, unlike the 2 two-tier architecture, the client application cannot directly communicate with the database. Instead, it communicates with the application on the server side, which in turn retrieves the required data from the database.

23 views0 comments

Recent Posts

See All