DBMS- Database management system, Summaries of Database Management Systems (DBMS)

Download DBMS- Database management system and more Summaries Database Management Systems (DBMS) in PDF only on Docsity!

Database Management System

Lec 01

Topics

• (^) Basic Definitions
• (^) Database System Applications
• (^) File System vs DBMS

Database System Applications

• (^) Banking: all transactions
• (^) Airlines: reservations, schedules
• (^) Universities: registration, grades
• (^) Sales: customers, products, purchases
• (^) Online retailers: order tracking, customized recommendations
• (^) Manufacturing: production, inventory, orders, supply chain
• (^) Human resources: employee records, salaries, tax deductions

Drawbacks of File System

• (^) Data Redundancy: Data redundancy refers to the duplication of data, lets say we are managing the data of a college where a student is enrolled for two courses, the same student details in such case will be stored twice, which will take more storage than needed. Data redundancy often leads to higher storage costs and poor access time.
• (^) Data Inconsistency: Data redundancy leads to data inconsistency, lets take the same example that we have taken above, a student is enrolled for two courses and we have student address stored twice, now lets say student requests to change his address, if the address is changed at one place and not on all the records then this can lead to data inconsistency.
• (^) Data Isolation: Because data are scattered in various files, and files may be in different formats, writing new application programs to retrieve the appropriate data is difficult. (^) Munira Akter Lata, Lecturer, Dept. of Education, BDU 5

Advantages of DBMS

• (^) No Redundant Data: Redundancy removed by data normalization. No data duplication saves storage and improves access time.
• (^) Data Consistency and Integrity: As we discussed earlier the root cause of data inconsistency is data redundancy, since data normalization takes care of the data redundancy, data inconsistency also been taken care of as part of it
• (^) Data Security: It is easier to apply access constraints in database systems so that only authorized user is able to access the data. Each user has a different set of access thus data is secured from the issues such as identity theft, data leaks and misuse of data.

• (^) Privacy: Limited access means privacy of data.
• (^) Easy Access to Data: Database systems manages data in such a way so that the data is easily accessible with fast response times.
• (^) Easy Recovery: Since database systems keeps the backup of data, it is easier to do a full recovery of data in case of a failure.
• (^) Flexible: Database systems are more flexible than file processing systems.

Advantages of DBMS (Cont...)

Thank You