Introduction of DBMS and File Sharing System Avnish Jani , Assistant Professor Computer Science & Engineering
Introduction of DBMS and File Sharing System Lecture 1
A Database-management system is a collection of interrelated data and a set of programs to access those data. The collection of data, usually referred to as the database . The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient. DBMS
Sales:- Accounting, Human Resources Manufacturing Banking and Finance:- Banking, Credit card Transactions, Finance Universities Airlines Telecommunications Web-Based Services:- Social Media, Online Retailers, Online advertisers Document Databases Navigation systems Database System Applications
Keeps information about instructors, students, departments and course offerings. One way to keep information is to store in operating system files. To allow users to manipulate the information, the system has number of application programs that manipulates the files. Programmers develop these application programs to meet the needs of the University. New application programs are added to the system as the need arises. File Processing System (University Organization)
Data Redundancy and Inconsistency Difficulty in accessing data Data Isolation Integrity Problems Atomicity Problems Concurrent access anomalies Security Problems File Processing System Limitations