No products in the cart.

Ask questions which are clear, concise and easy to understand.

Ask Question
  • 0 answers
  • 0 answers
  • 1 answers

Suneha S 4 years, 7 months ago

What is the question
  • 1 answers

Akshat Yadav 5 years, 9 months ago

What is prism
  • 0 answers
  • 1 answers

Sia ? 3 years, 5 months ago

enabled=false means you can see the control but you can't make any actions on it. visible=false means you can not view the controlEnable means use can view the control but can't operate or use controlVisible means user can't see the control exist.

  • 1 answers

Pushp Raj 5 years, 9 months ago

36÷100=0.36
  • 0 answers
  • 1 answers

Manish Bishnoi 5 years, 9 months ago

Kendriya vidyalaya bsf Jodhpur but phone number kyo chahiye
  • 1 answers

Somveer Singh 5 years, 9 months ago

What?
  • 0 answers
  • 1 answers

Gaurav Seth 5 years, 9 months ago

It is a collection of programs that enables users to create, maintain database and control all the access to the database. It is a computer based record keeping system. DBMS is a software package that manages database, e.g. MySQL, INGRES, MS-ACCESS etc.DBMS is actually a tool that is used to perform any kind of operation on data in database.

Need:

It can be used for:

It provides us with the many functionalities and is more advantageous than the traditional file system in many ways listed below:

1) Processing Queries and Object Management:
In traditional file systems, we cannot store data in the form of objects. In practical-world applications, data is stored in objects and not files. So in a file system, some application software maps the data stored in files to objects so that can be used further.
We can directly store data in the form of objects in a database management system. Application level code needs to be written to handle, store and scan through the data in a file system whereas a DBMS gives us the ability to query the database.

2) Controlling redundancy and inconsistency:
Redundancy refers to repeated instances of the same data. A database system provides redundancy control whereas in a file system, same data may be stored multiple times. For example, if a student is studying two different educational programs in the same college, say ,Engineering and History, then his information such as the phone number and address may be stored multiple times, once in Engineering dept and the other in History dept. Therefore, it increases time taken to access and store data. This may also lead to inconsistent data states in both places. A DBMS uses data normalization to avoid redundancy and duplicates.

3) Efficient memory management and indexing:
DBMS makes complex memory management easy to handle. In file systems, files are indexed in place of objects so query operations require entire file scans whereas in a DBMS , object indexing takes place efficiently through database schema based on any attribute of the data or a data-property. This helps in fast retrieval of data based on the indexed attribute.


 

4) Concurrency control and transaction management:
Several applications allow user to simultaneously access data. This may lead to inconsistency in data in case files are used. Consider two withdrawal transactions X and Y in which an amount of 100 and 200 is withdrawn from an account A initially containing 1000. Now since these transactions are taking place simultaneously, different transactions may update the account differently. X reads 1000, debits 100, updates the account A to 900, whereas Y also reads 1000, debits 200, updates A to 800. In both cases account A has wrong information. This results in data inconsistency. A DBMS provides mechanisms to deal with this kind of data inconsistency while allowing users to access data concurrently. A DBMS implements <a href="http://quiz.geeksforgeeks.org/acid-properties-in-dbms/">ACID</a>(atomicity, durability, isolation,consistency) properties to ensure efficient transaction management without data corruption.

5) Access Control and ease in accessing data:
A DBMS can grant access to various users and determine which part and how much of the data can they access from the database thus removing redundancy. Otherwise in file system, separate files have to be created for each user containing the amount of data that they can access. Moreover, if a user has to extract specific data, then he needs a code/application to process that task in case of file system, e.g. Suppose a manager needs a list of all employees having salary greater than X. Then we need to write business logic for the same in case data is stored in files. In case of DBMS, it provides easy access of data through queries, (e.g., SELECTqueries) and whole logic need not be rewritten. Users can specify exactly what they want to extract out of the data.

6) Integrity constraints: Data stored in databases must satisfy integrity constraints. For example, Consider a database schema consisting of the various educational programs offered by a university such as(B.Tech/M.Tech/B.Sc/M.Sc/BCA/MCA) etc. Then we have a schema of students enrolled in these programs. A DBMS ensures that it is only out of one of the programs offered schema , that the student is enrolled in, i.e. Not anything out of the blue. Hence, database integrity is preserved.

Apart from the above mentioned features a database management also provides the following:

  • Creation of a database.
  • Retrieval of information from the database.
  • Updating the database.
  • Managing a database.
    • Multiple User Interface
    • Data scalability, expandability and flexibility: We can change schema of the database, all schema will be updated according to it.
    • Overall the time for developing an application is reduced.
    • Security: Simplifies data storage as it is possible to assign security permissions allowing restricted access to data.
  • 0 answers
  • 1 answers

Kritika Singh 5 years, 9 months ago

Mouse,keyboard,screen,CPU,UPS,speakers,joystick etc
  • 0 answers
  • 1 answers

Chakresh Singh 5 years, 9 months ago

Which ch
  • 2 answers

Jasmitha Do Your Best 5 years, 9 months ago

This is in Sanskrit na

Priya Piu 5 years, 9 months ago

Letters
  • 3 answers

Chakresh Singh 5 years, 9 months ago

Learn ans by writing and by heart

Jasmitha Do Your Best 5 years, 9 months ago

Me also the problem of hindi

Jasmitha Do Your Best 5 years, 9 months ago

Learn with your book and with focus
  • 0 answers
  • 1 answers

Anushka Nagar 5 years, 9 months ago

Black money is earned by take bribe and white money is earned by self hard working
  • 1 answers

Chakresh Singh 5 years, 9 months ago

E commerce stands for electric commerce in which the financial business transaction are done online over computer network
  • 1 answers

Keerthi Vasu 4 years, 7 months ago

I
  • 1 answers

Anushka Nagar 5 years, 9 months ago

Goa
  • 1 answers

Kastu Shukla 5 years, 9 months ago

Kah rakshti Kah rakshti
  • 1 answers

L Sunitha 4 years, 7 months ago

Tertiary sector

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App