1.

Explain the difference between a 2-tier and 3-tier architecture in a DBMS.

Answer»

The 2-tier architecture refers to the CLIENT-server architecture in which applications at the client end DIRECTLY COMMUNICATE with the database at the server end without any middleware involved.
Example – Contact Management System created using MS-Access or Railway Reservation System, etc.

The above picture represents a 2-tier architecture in a DBMS.

The 3-tier architecture contains another layer between the client and the server to provide GUI to the users and make the system much more secure and accessible. In this type of architecture, the application present on the client end interacts with an application on the server end which further communicates with the database system.

Example – Designing registration form which contains a text box, label, button or a large website on the Internet, etc.

The above picture represents a 3-tier architecture in a DBMS.

Recommended Tutorials:

SQL Interview Questions
DBMS MCQ
SQL Server Interview Questions
MySQL Interview Questions
MongoDB Interview Questions
PL SQL Interview Questions
Features of DBMS
Difference Between DBMS and RDBMS
File System vs DBMS



Discussion

No Comment Found