What are the characteristics of relational database management system?

Answer 1

characteristic of relational data base system

There are a number of characteristics that distinguish the database approach with the file-based approach. In this section, we describe in detail some of those important characteristics.

Self-Describing Nature of a Database System : Database System contains not only the database itself but also the descriptions of data structure and constraints (meta-data). These information is used by the DBMS software or database users if needed. This separation makes database system totally different from traditional file-based sytem in which data definition is a part of application programs

Insulation between Program and Data : In the filed base sytem, the structure of the data files is defined in the application programs so if user want to change the structure of a file, all the programs access to that files might need to be changed. On the other hand, in database approach, data structure is stored in the system catalog not in the programs so such changes might not occurs.

Support multiple views of data: A view is a subset of the database which is defined and dedicated for particular users of the system. Multiple users in the system might have different views of the system. Each view might contains only the interested data of an user or a group of user.

Sharing of data and Multiuser system: A multiuser database system must allow multiple users access the database at the same time. As the result, the multiuser DBMS must have concurrency control strategies to ensure that several user try to access the same data item at a time do so in the manner so that the data always be correct.

Answer 2

Data :- data is know fact that can be recorded and that have implicit meaning.

Record:- it is the collection of related data e.g. in file EMPLOYEE record

Data It:- it is used together for representing a particular data element.

File:- File name of each data item is known as the field name.

Answer 3

Data. • Hardware. • Software. • Users

Answer 4

compactness, speed, drudgery, currency