Skip to main content

Database Management System (DBMS)

DBMS

A DBMS (Database Management System) is a collection of programs that enables you to store, modify and extract information from a database.
In simple words we can say that the DBMS is a type of system which manages the data in database like to add new data, modify the data and delete the existing data. DBMS can be used in many places like Banking to manage the records of the account and transaction, Schools to manage the record of the student and their fees, Payroll Management System to manage the details related to the employees like, attendance, salary, etc, and there are many more field we can use the facility DBMS. 

Advantages of DBMS

1. Stop data redundancy and inconsistency – Data redundancy is a situation created within a database in which the same piece of data is present at two separate places.

Here are two tables in a database in which a common field is present in the table i.e. “Student_Name”, so if you use this type of database structure then this database is called data inconsistent and data redundant database.
Note – Student_Id columns are key fields which are used to relate the tables for data sharing.
Data redundancy means repetition or duplication of data.
Data inconsistency is a situation when similar data is stored at different location.
2. Data Sharing – Facility to use data resources with multiple users from a central location is known as Data sharing. In DBMS all data is stored at a central location from where users can easily access it simultaneously.
3. Security – Database stores valuable or sensitive data. DBMS provides some security feature that helps to prevent unauthorized data access. DBMS provides security for data by ensuring that only authorized users are able to access the database.
4. Data Integrity – Data integrity means the unification of data. In other words the term data integrity refers to the accuracy and consistency of data by making each field unique as required by user.
5. Data Backup and recovery – DBMS also provide data backup facility and recovery when there is in need for portable data.

Labels:

Comments

Post a Comment

Students you can ask your doubts in comment section

Popular posts from this blog

Q & A Chapter 1 | Internet Basics | Class 10 CBSE | Computer Application

 Q & A of Chapter 1 Internet Basics A. Tick the correct options – 1. (b) TCP/IP 2. (a) Internet Service Provider 3. (a) URL 4. (b) HTTP 5. (a) Bridge 6. (a) home page 7. (d) All of these 8. (b) Domain Naming System 9. (b) Rules 10. (d) ARPANET B. Very Short Answer Type Questions – 1. In the URL http://www.myfirm.co.in/about.html , what do the following components depict? (a) http                                                 (b) in (a) Http represents a type of server and the protocol on the Internet (b) ‘in’ represents the domain extension of the website. 2. In the URL http://www.favmusic.com/contactus.html what does www.favmusic stand for? www.favmusic represents the domain name i.e. favmusic in www. 3. W...
Post a Comment
Read more

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 | QBasic | Class 7 CBSE | Computer Application

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 A. Tick the correct option. 1. (d) screen mode 0 2. (b) 640 x 350 3. (d) White 4. (a) Lower-Right 5. (c) PSET 6. (c) Generate a tone for a short duration B. Fill in the blanks. 1. CIRCLE 2. PAINT 3. PLAY 4. Graphic 5. Pixels 6. Box C. True or False. 1. True 2. False 3. False 4. True 5. True 6. True D. Answer the following questions. 1. What is the use of SCREEN statement? The SCREEN statement is used to set the screen mode for displaying graphics. There are many screen modes and each screen modes have their own number which is from SCREEN 1 to SCREEN 13. The various screen modes differ in resolution. 2. What is a pixel? How is it related to resolution? The graphics which is displaying on the computer screen is made up of thousands of dots called pixel. Pixel stands for picture element. The number of pixels in an image determines the resolution of the image. Higher the resolution, cleaner the image will appear. 3. What is the differenc...
Post a Comment
Read more

Thymeleaf function on button click with multiple parameter

how you can write the onclick attribute using Thymeleaf syntax: <button type = "button" th:onclick= "|rejectSalaryPayment(' ${response.uuid} ', ${dto.id} )|" >Reject Salary Payment</button> This assumes that the response.uuid and dto.id variables are available in the current Thymeleaf context. If they are not, you will need to provide the appropriate values or expressions to evaluate them. Also note that the onclick attribute is written using the Thymeleaf expression syntax ( |...| ), which allows you to include string literals and variable expressions within the same attribute value. 
Post a Comment
Read more