Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study
Guide
Latest Updated 2024/2025
?
, Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study Guide
Latest Updated 2024/2025
Chapter 15
Database Connectivity and Web Technologies
Discussion Focus
Begin by making sure that the students are familiar with the basic vocabulary. The following two questions
are a good place to start. (You may want to examine the contents of Appendix F, “Client/Server Systems.”)
There is some irony in the Web development arena … the microcomputer was supposed to liberate the
end user from the mainframe computer’s “fat server, thin client” environment. However, the Web has, in
effect, brought us back to the old mainframe structure in which most processing is done on the server
side, while the client is the source and recipient of data/information requests and returns.
1. Describe the following: TCP/IP, Router, HTML, HTTP, and URL.
Transmission Control Protocol/Internet Protocol (TCP/IP) is the basic network protocol that determines the
rules used to create and route “packets” of data between computers in the same or different networks.
Each computer connected to the Internet has a unique TCP/IP address. The TCP/IP address is divided in two
parts used to identify the network and the computer (or host)
Router is a special hardware/software equipment that connects multiple and diverse networks. The router
is in charge of delivering packets of data from a local network to a remote network. Routers are the traffic
cops of the Internet, monitoring all traffic and moving data from one network to another.
, Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study Guide
Latest Updated 2024/2025
HTML stands for Hyper Text Markup Language is the standard document-formatting language for Web
pages. HTML allows documents to be presented in a Web browser in a standard manner.
URL stands for Uniform Resource Locator. An URL identifies the address of a resource on the Internet. The
URL is an abbreviation (ideally easily remembered) that uniquely identifies an internet resource, for
example www.amazon.com, www.faa.gov, and www.mtsu.edu.)
HTTP stands for Hyper Text Transfer Protocol. HTTP is the standard protocol used by the Web browser and
Web server to communicate—that is, to send requests and replies between servers and browsers. HTTP
uses TCP/IP to transmit the data between computers.
470
, Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study Guide
Latest Updated 2024/2025
Chapter 15
Database Connectivity and Web Technologies
2. Describe the client/server model for application processing.
Client/server is a term used to describe a computing model for the development of computerized
systems. This model is based on the distribution of functions between two types of independent and
autonomous processes: servers and clients. A client is any process that requests specific services from
server processes. A server is a process that provides requested services for clients. Client and server
processes can reside in the same computer or in different computers connected by a network.
The client/server model makes possible the division of the application processing tasks into three
main components: presentation logic, processing logic, and data storage.
The presentation logic formats and presents data in output devices, such as the screen, and
manages the end-user input. The application uses presentation logic to manage the graphical user
interface at the client end.
The processing logic component refers to the application code that performs data validation, error
checking, and business logic processing. The processing logic component represents the business
rules. For example, the processing logic “knows” that a sales transaction generates an invoice
record, an inventory update, and a customer’s account receivable update. The processing logic
performs several functions, including enforcement of business rules, managing information flows
within the business, and mapping the real-world business transactions to the actual computer
database.
The data storage component deals with the actual data storage and retrieval from permanent
storage devices. For example, the data manipulation logic is used to access the data in a database
and to enforce data integrity.
Connectivity and Web
Technologies
Comprehensive Exam Study
Guide
Latest Updated 2024/2025
?
, Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study Guide
Latest Updated 2024/2025
Chapter 15
Database Connectivity and Web Technologies
Discussion Focus
Begin by making sure that the students are familiar with the basic vocabulary. The following two questions
are a good place to start. (You may want to examine the contents of Appendix F, “Client/Server Systems.”)
There is some irony in the Web development arena … the microcomputer was supposed to liberate the
end user from the mainframe computer’s “fat server, thin client” environment. However, the Web has, in
effect, brought us back to the old mainframe structure in which most processing is done on the server
side, while the client is the source and recipient of data/information requests and returns.
1. Describe the following: TCP/IP, Router, HTML, HTTP, and URL.
Transmission Control Protocol/Internet Protocol (TCP/IP) is the basic network protocol that determines the
rules used to create and route “packets” of data between computers in the same or different networks.
Each computer connected to the Internet has a unique TCP/IP address. The TCP/IP address is divided in two
parts used to identify the network and the computer (or host)
Router is a special hardware/software equipment that connects multiple and diverse networks. The router
is in charge of delivering packets of data from a local network to a remote network. Routers are the traffic
cops of the Internet, monitoring all traffic and moving data from one network to another.
, Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study Guide
Latest Updated 2024/2025
HTML stands for Hyper Text Markup Language is the standard document-formatting language for Web
pages. HTML allows documents to be presented in a Web browser in a standard manner.
URL stands for Uniform Resource Locator. An URL identifies the address of a resource on the Internet. The
URL is an abbreviation (ideally easily remembered) that uniquely identifies an internet resource, for
example www.amazon.com, www.faa.gov, and www.mtsu.edu.)
HTTP stands for Hyper Text Transfer Protocol. HTTP is the standard protocol used by the Web browser and
Web server to communicate—that is, to send requests and replies between servers and browsers. HTTP
uses TCP/IP to transmit the data between computers.
470
, Chapter 15 Database
Connectivity and Web
Technologies
Comprehensive Exam Study Guide
Latest Updated 2024/2025
Chapter 15
Database Connectivity and Web Technologies
2. Describe the client/server model for application processing.
Client/server is a term used to describe a computing model for the development of computerized
systems. This model is based on the distribution of functions between two types of independent and
autonomous processes: servers and clients. A client is any process that requests specific services from
server processes. A server is a process that provides requested services for clients. Client and server
processes can reside in the same computer or in different computers connected by a network.
The client/server model makes possible the division of the application processing tasks into three
main components: presentation logic, processing logic, and data storage.
The presentation logic formats and presents data in output devices, such as the screen, and
manages the end-user input. The application uses presentation logic to manage the graphical user
interface at the client end.
The processing logic component refers to the application code that performs data validation, error
checking, and business logic processing. The processing logic component represents the business
rules. For example, the processing logic “knows” that a sales transaction generates an invoice
record, an inventory update, and a customer’s account receivable update. The processing logic
performs several functions, including enforcement of business rules, managing information flows
within the business, and mapping the real-world business transactions to the actual computer
database.
The data storage component deals with the actual data storage and retrieval from permanent
storage devices. For example, the data manipulation logic is used to access the data in a database
and to enforce data integrity.
