Database Management Systems (DBMS) PDF

Database Management Systems (DBMS) Welcome to Unit 3 of our exploration into Database Management Systems (DBMS). This presentation, prepared by Aastha Gupta of Class 10th B, will provide an overview of DBMS, its key components, data models, and advantages. We'll delve into the world of organized dat...

Database Management Systems (DBMS) Welcome to Unit 3 of our exploration into Database Management Systems (DBMS). This presentation, prepared by Aastha Gupta of Class 10th B, will provide an overview of DBMS, its key components, data models, and advantages. We'll delve into the world of organized data storage, retrieval, and management, exploring various types of DBMS and their applications in modern computing. SK by Simran Kaur What is a DBMS? A Database Management System (DBMS) is software that provides an interface between the database and its users or applications. It allows for efficient management, storage, and retrieval of data. Some popular examples of DBMS include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server. Database Organized collection of data DBMS Software Interface between database and users Users Interact with the database through DBMS Key Components of Database Management System Database An organized collection of data. DBMS Software The interface between database and the users. Data The actual data that is being stored and managed. Storage Manager Manages data storage on disks. What is Data Model? A data model is the structure of a database, designed in different ways depending on the data being stored. It describes the manner in which data will be stored and retrieved. A data model consists of components for describing the data, relationships among them, and the constraints that hold data. Data Model Structure Data Relationships Visual representation of how data is organized and related within Illustration of how different data elements are connected in a a database. data model. Types of Data Model 1 Hierarchical DBMS Data organized in a tree-like structure. 2 Network DBMS Multiple records linked to the same master file. 3 Relational DBMS (RDBMS) Data stored in tables with relationships between them. Hierarchical DBMS In the hierarchical model, data is organized into a tree-like structure. The data is stored in the form of records, which are collections of fields and their data values. All these records are linked to each other at various levels, forming a hierarchy. An example of this model is how a company's data might be stored, with departments at the top level, employees within departments, and employee details at the lowest level. 1 Root Top-level entity (e.g., Company) 2 Parent Nodes Mid-level entities (e.g., Departments) 3 Child Nodes Lower-level entities (e.g., Employees) Network DBMS In the network model, multiple records are linked to the same master file. It can be visualized as an inverted tree where the master is at the bottom and the branches contain information linked to the master. This model allows for more complex relationships between data elements. An example of this model is how a company's data might be represented, with interconnected relationships between departments, projects, and employees. Master Record Central entity (e.g., Company) Member Records Related entities (e.g., Departments, Projects) Set Relationships Connections between master and member records Relational DBMS (RDBMS) The Relational Database Model, proposed by E. F. Codd in 1970, is based on setting relationships between two or more tables in the same database. It's the most commonly used database model. Data elements are stored in different tables made up of rows and columns, with relationships established through common fields. SQL-based systems are examples of RDBMS. This model allows for efficient data retrieval and manipulation through structured query language. Tables Relationships SQL Data stored in rows and columns Connections between tables via Language for querying and common fields managing relational databases Advantages of DBMS 1 Organized Data Data is stored in an organized manner, enabling fast and accurate retrieval. 2 Data Analysis Facilitates easy analysis of data based on certain criteria, such as finding maximum, minimum, or average values. 3 Data Sharing Allows sharing of data across different applications, promoting reusability. 4 Reduced Data Redundancy Minimizes duplicate data across tables, improving efficiency. Conclusion A Database Management System (DBMS) is critical for managing, storing, and retrieving data efficiently in modern computing environments. Its advantages include improved data security, reduced redundancy, and enhanced data access. By providing a structured approach to data management, DBMS enables organizations to make better use of their information resources. Efficient Management Enhanced Security DBMS provides tools for organizing and accessing data effectively. DBMS offers improved protection for sensitive information.