DATABASE CONCEPTS CUSTOM
DATABASE CONCEPTS CUSTOM
8th Edition
ISBN: 9780134639864
Author: KROENKE
Publisher: PEARSON C
Expert Solution & Answer
Book Icon
Chapter 7, Problem 7.1RQ

Explanation of Solution

Web based application in three-tier Architecture:

In web based environment, a Web server and the DBMS (Database Management System) can execute on different system.

  • The major components of web database applications are web browser, web server and database.

The below diagram will illustrate the three-tier architecture as follows:

DATABASE CONCEPTS CUSTOM, Chapter 7, Problem 7.1RQ

The layers in the three-tier architecture are listed below:

  • Application (web browser)
  • Web server
  • DBMS server

Application (web browser):

  • Applications are developed using scripting language which executes on computers.
  • It will send a web page request to the web server.

Web server:

  • Server scripting code is used to control the code which returns back to the browser.
  • It will send a database request to the DBMS server.

DBMS server:

  • Results from databases are made by sending request for DBMS operations using SQL and SQL/PSM commands.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage