Page 162 - DMGT505_MANAGEMENT_INFORMATION_SYSTEM

Unit 8: Databases and Data Warehouses

3. Effective communication tool Notes
4. Integrated with the relational database model.

Figure 8.7: ER Model

Customer-name Customer-street

Customer-id Customer-city Account-no. Balance

Customer Depositor Account

However, this model suffers from serious limitations:

1. Limited constraint representation
2. Limited relationship representation
3. No data manipulation language
4. Loss of information content

Self Assessment

Fill in the blanks:
6. A ................................... database contains multiple tables, each similar to the one in the
“flat” database model.

7. ................................... is a simple and powerful query language that is capable of answering
simple to most complex queries.
8. ................................... is the analysis of data objects that are used in a business or other
context and the identification of the relationships among these data objects.
9. A set represents a ................................... relationship between the owner & the member.

8.4 Database on the Web

Traditionally databases were available to users with login access to the CDS server itself or by
means of Client/Server software. More recently we have been able to provide an increasing
number of systems directly via the CDS website.

8.4.1 Web Database

A web database is a database for the internet. You can get access to your data via the internet
from anywhere in the world or you can create a database driven website by using such databases.
A web database stores large amount of information in an organized format that is easily accessible
from scripting languages (like PHP).
In web databases, modifications can be performed without any hassles. That makes the dense
editing of the html code obsolete.

LOVELY PROFESSIONAL UNIVERSITY 157