Database Reference
In-Depth Information
1.4.2 Database Designers
They are responsible for identifying the data to be stored in the database and for choosing
appropriate structure to represent and store the data. It is the responsibility of database de-
signers to communicate with all prospective of the database users in order to understand
their requirements so that they can create a design that meets their requirements. The data-
base designer is responsible for defining the detailed database design, including tables,
indexes, views, constraints, triggers, stored procedures, and other database specific con-
structs needed to store, retrieve, and delete objects. Database Designers are also identify
the data (entities and attributes), relationships between the data and constraints on the data.
He/she maps the logical database design into a set of tables and integrity constraints. He
designs any security measures required on the data.
1.4.3 End Users
End Users are the people who interact with the database through applications or utilities.
The various categories of end users are:
Casual End Users - These Users occasionally access the database but may need different
information each time. They use sophisticated database Query language to specify their re-
quests. For example: High level Managers who access the data weekly or biweekly.
Native End Users - These users frequently query and update the database using standard
types of Queries. The operations that can be performed by this class of users are very lim-
ited and effect precise portion of the database.
For example, reservation clerks for airlines/hotels check availability for given request and
make reservations. Also, persons using Automated Teller Machines (ATM's) fall under this
category as he has access to limited portion of the database.
Standalone end Users/On-line End Users - Those end Users who interact with the data-
base directly via on-line terminal or indirectly through Menu or graphics based Interfaces.
For example, user of a text package, library management software that store variety of lib-
rary data such as issue and return of topics for fine purposes.
1.4.4 Application Programmers
As we know Computer programs as being composed of three parts:
a. input
b. processing
c. output
