The Tradition of Sharing

Help your friends and juniors by posting answers to the questions that you know. Also post questions that are not available.

To start with, Sr2Jr’s first step is to reduce the expenses related to education. To achieve this goal Sr2Jr organized the textbook’s question and answers. Sr2Jr is community based and need your support to fill the question and answers. The question and answers posted will be available free of cost to all.

Fundamentals of Database Systems

Fundamentals Of Database Systems

Elmasri Navathe
Review Questions
And Database Users



Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application.


Definitions of following terms:

Data: Data is a relative entity or object. Ex-name, age, class..

Database: A Database is a collection of related data with an implicit meaning.

DBMS: A database management system is a software system that helps users to create and maintains a database. This system contains the processes of defining, constructing, manipulating and sharing databases from various users and applications.

Database System: Data base system is nothing but database and DBMS software together we call as data base system.

Database catalog: Database catalog contains information such as the structure of each file, the type and storage format of each data item and various constraints on the data.

Program-data independence: The structure of data files is stored in the DBMS catalog separately from the access programs is known as program – data independence.

User view: It is the view that may be a subset of the database or it contains virtual data is derived from the database files but is not explicitly stored.

DBA: Database Administrator is an administrator who is responsible for authorizing access to the database.DBA manages and coordinates the resources and acquires software and hardware resources.

End-user: An end user is a person whose job requires access to the database for querying, updating and generating the reports.

Canned transaction: The main aim of canned transaction is using standard types of queries and updates for querying and updating database.

Deductive database systems: This type of database systems provides capability for defining deduction rules for new information from the stored database.

Persistent object: Persistent means object is stored permanently in an object –oriented DBMS and it survives to terminate the program execution and then retrieved directly by another program.

Meta-data: It is information about structure of each file, type and storage format of each data and various constraints on the data is called meta-data.

Transaction-processing application: This application is designed to maintain database integrity in a known, consistent state.

0 0



Thanks for the answer.

Post the discussion to improve the above solution.