advantages and disadvantages of dbms & component of dbms

Ø  Advantage and disadvantage of DBMS –

Ø  Advantages –

·        Separation of application program.

·        Minimal data duplicity or data redundancy.

·        Easily retrieval of data using the Query Language.

·        Reduced development time and maintenance need.

·        We now have Database Management Systems capable of storing almost infinite data.

·        Seamless integration into the application programming languages which makes it very easier to add a database to almost any application or website.

Ø  Disadvantages of DBMS –

·        It's Complexity

·        Except MySQL, which is open source, licensed DBMSs are generally costly.

·        They are large in size.

Components of DBMS – The database management system can be divided into five major components, they are:

1. Hardware
2. Software
3. Data
4. Procedures
5. Database Access Language

Let's have a simple diagram to see how they all fit together to form a database management system.