1 / 21

Introduction To DBMS - Database Management System | What Is DBMS? | DBMS Explana

A Database is a collection of data. With the help of Database Management Systems, this data can be updated, retrieved, or deleted. In this video on Introduction to DBMS, we learn about what is a database, what really is a database management system and how it replaced the flat file system, then we will go through the components of DBMS and their applications and will have a look at the popular database management systems.<br>

Simplilearn
Download Presentation

Introduction To DBMS - Database Management System | What Is DBMS? | DBMS Explana

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s in it for you? What is a Database? What is Database Management System? Why DBMS? Components of DBMS Types of DBMS Application of DBMS Popular DBMS Software

  2. Data Database Sy

  3. Click here to watch the video

  4. Database System Database Database System Database Management System

  5. What is a Database?

  6. What is a Database? This structured information is often retrieved, managed, controlled and arranged to perform various data-processing operations A database is an ordered collection of information stored and read electronically from a computing system

  7. DBMS provides a platform for users to carry out different actions like database creation, updation, deletion and a lot more What is a Database Management System? All the processes are protected and secured. Even data consistency is maintained during multiple users Database Management System is an application software which is used to perform various operations on data. Example - MySQL

  8. Client Server Architecture

  9. Why DBMS? • Supports multi-user access • Used by both small and large businesses • No Redundancy and Integrity issues • Expensive • Can work with complicated transactions • It does not support multiuser access • Used by small businesses • Redundancy and Integrity issues • Cheap • Cannot work with complicated transactions Flat File System DBMS

  10. Components of DBMS Software Hardware Data Database Access Language Procedures

  11. Components of DBMS Software Hardware Data Database Access Language Procedures User

  12. Types of DBMS

  13. Types of DBMS • Data is organised in a graph like structure • Data entities has one to one or many to many relationship • Data is organised in tree like structure • Data entities has one to many relationship Hierarchical Model Network Model Object Oriented Model Relational Model • Data is stored in the form of objects • It is a combination of relational database features and OOPS concepts • Data is organised in two dimensional tables using rows and columns • Stored in fixed structures and updated using SQL

  14. Applications of DBMS

  15. Application of DBMS Banking Finance Universities Sales Airlines Manufacturing Telecommunication HR Management

  16. Advantages of DBMS Controls Database Redundancy • Data Integrity • Sharing of Data • Data Security • Privacy • Backup and Recovery • Data Consistency

  17. Disadvantages of DBMS c Cost of Hardware and software is quite high • Complex to use • Higher Impact of Failure • Huge Size

  18. Popular DBMS Software

More Related