BIKESH SUNAR

admin

2 Followers

Asked Questions

Differentiate between DBMS and RDBMS with example.

DBMS	RDBMS
1.A software that provides a systematic way of creating, retrieving and managing data in database	1.A DBMS that is based on the relational model introduced by E.F.Codd
2. Normalization is not present in DBMS	2. Normalization is present in RDBMS.
3.DBMS does not apply any security with regardsto data manipulation.	3.RDBMS define the integrity constraint for the purpose of ACID (Atomocity, comnsistency, Isolation and Durability) property.
4.Suitable to store a small amount of...

What is relational database model? Write its advantages.

Relational data model is the primary data model, which is used widely around the world for the data stroage and processing . The model is simple and it has all the properties and capabilities requried tp process data with stroage efficiency.

Its advantage of relational database model are:

It is very easy low data redundancy.
Normalization of the database is possible.
Rapid processing of database is possible.
Since one table is linked with another, some...

Define DBMS. List out objectives of DBMS.

A Database management system(DBMS) is software designed to store, retrieve, define and manage data in a database

The objectives of DBMS are :

1.To provide a storage area for the mass amount of relevant data.

2. To make access to the data easy for the end-user.

3. To allow multiple users to be active at one time.

4.To allow the growth of the database.

5. To eliminate data redundancy (duplication of data).

6.To protect the data from the physical harm and unauthorized access.