Question

explain characteristics of database ?

Answer 1

1.Manages Information
Eg: A system may have to maintain information of various employees working in its organization, their names,addresses, and other details which may in later instance be modified or deleted.

2.Easy to operate on data
Inserting more data, deleting unuseful data, updating, searching etc is easy.

3.Consistent
Let me give you a situation to understand this,suppose you are initiating a transaction wherein you have to transfer Rs 50 from Account A to B. Say account A contains Rs 300 and B contains Rs 200. You will execute the transaction in 2 steps. 1st subtract rs 50 from A and 2nd Add 50 to B. Now the database will reflect updated values A= 250 and B=250

Now imagine ,there occurs a system failure after 1st step of transaction. the database will reflect A=250 and B=200. that means rs 50 is destroyed by the system. This inconsistency is prevented by database approach. Either all changes are reflected (ie. A=250 and B=250) or none are (ie. A=300 and B=200).

4. Persistent
Once your transaction has completed successfully ( we say the transaction is committed), data will remain persistent, ie. it will not be lost or deleted until you do it manually.

5. Security of Data
Only authorized users are allowed to access the data.

6. Self describing Nature
DBMS contains data as well as data definition (stored in system catalog). In File Processing System data definition is a part of Application Programs.

7. Isolation between programs and data
As mentioned above, data definition is stored in catalog ( Not in programs). Hence, User doesn't need to make changes in programs if he changes the structure of the data.

8. Supports multiple views
Different users may have interest in different groups of data. User is allowed to view the data in which he is interested.
EG. one user is only interested for student mark list,other user is interested for courses attended by that student, these multi-user views are satisfied by DBMS

Answer 2

This is the answer of that question