Page 263 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes

Lab Exercise Create a student database with important columns like, Student name, Roll
No, Course Name, Subject Name, Year etc.. and also make a web page with all necessary
fields to display all information on the page.

14.6 Summary

This unit covers the features of database for web, Server Side Database Communication with
CGI, Chains of Communication, using Perl 5 and the DBI Module to Communicate With Databases,
DBI Module and API, Getting the Pieces, Running CGI Applications on a Single Station Local
Area Network along with JDBC.
14.7 Keywords

Chains of communication: A Web Database follows the client-server database model. A Database
Engine sits on some central computer somewhere and serves data to multiple web-based clients.

Database administrator: Data administrator is one who oversees the data integrity of the
database.
DBI module: The DBI Module is an incredibly useful tool because it abstracts away the need to
learn how to communicate with every type of database out there. Consider what a pain it would
be if you had to write a CGI script for every proprietary database engine.
URL: Uniform Resource Locator

14.8 Self Assessment

Choose the appropriate answer:
1. URL stands for:
(a) Uniform Resource Location
(b) Uniform Resource Locator
(c) Uniform Region Locator

(d) Uniform Region Location
2. CGI stands for
(a) Common Gateway Interface
(b) Communication Gateway Interface
(c) Common Gateway interchange
(d) Communication Gateway Interchange

3. ODBC stands for
(a) Open Database Communication
(b) Open Database Connectivity
(c) Open Database Connection
(d) Open Document Connectivity

256 LOVELY PROFESSIONAL UNIVERSITY