A Database Management system is the group of interrelated
data and a set of programs to access that data. DBMS must provide efficient techniques in order to protect the
data from accidental system crashes. A primary aim of the database system is to provide a convenient
and efficient way to store and retrieve data stored in a database. The DBMS must ensure that the chances of getting anomalous
results when the data is used by more than one set of user. DBMS system can be used in the fields such as transportation,
education, banking, sales, manufacturing, human resource etc.
o The first general purpose DBMS was developed by Charles
Bachman in early 1960s. Edgar Codd has suggested a new data representation
technique known as relational model. SQL 1999 was standardized by ANSI and ISO in late 1980s. Different disadvantages of file system with respect to database
system are listed below
1 Data redundancy and inconsistency.
2 Difficulty in accessing data
3 Data isolation
4 Concurrent data anomalies
5 Security problems
6 Integrity problems
7 Atomicity problems The following are the advantages of DBMS
1. Controlling Data redundancy
2. Elimination of inconsistency
3. Better services to the users
4. Better flexibility
5. Integrity is improved
- Teacher: Saptarshi chakraborty