{"id":5222,"date":"2024-11-29T19:56:33","date_gmt":"2024-11-29T14:26:33","guid":{"rendered":"https:\/\/cbsepython.in\/?p=5222"},"modified":"2024-11-29T19:56:33","modified_gmt":"2024-11-29T14:26:33","slug":"introduction-to-dbms-class-10-notes","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/introduction-to-dbms-class-10-notes\/","title":{"rendered":"Chapter 8 Introduction to DBMS Class 10 Notes IT 402"},"content":{"rendered":"

Introduction to DBMS Class 10 Notes (Database Management System)<\/strong><\/h2>\n
    \n
  1. Data and Information<\/strong><\/li>\n<\/ol>\n
      \n
    • Data<\/strong>: Data is raw, unorganized facts that need to be processed. Examples include numbers, text, or symbols. For instance, \u201c27\u201d or \u201cBlue\u201d are just data on their own.<\/li>\n
    • Information<\/strong>: Information is processed, organized data that makes sense. When data is put together meaningfully, it becomes information. For example, \u201cAge: 27\u201d provides specific details that are understandable.<\/li>\n<\/ul>\n
        \n
      1. Databases and DBMS<\/strong><\/li>\n<\/ol>\n
          \n
        • Database<\/strong>: A database is a collection of data organized to be easily accessed, managed, and updated. It can store various data types like text, numbers, and images.<\/li>\n
        • Database Management System (DBMS)<\/strong>: DBMS is software that helps to create, manage, and manipulate databases. It acts as a bridge between the user and the database, making data handling easy.<\/li>\n<\/ul>\n
            \n
          1. Advantages of Database<\/strong><\/li>\n<\/ol>\n
              \n
            • Data Storage Efficiency<\/strong>: Databases store data in an organized way, saving space.<\/li>\n
            • Data Security<\/strong>: Databases allow users to set permissions, protecting sensitive data.<\/li>\n
            • Data Consistency<\/strong>: Since data is centralized, changes made in one place are reflected everywhere.<\/li>\n
            • Reduced Data Redundancy<\/strong>: A database avoids duplication, making data storage more efficient.<\/li>\n
            • Easy Data Sharing<\/strong>: Multiple users can access the database simultaneously, improving teamwork and accessibility.<\/li>\n<\/ul>\n
                \n
              1. Data Models<\/strong><\/li>\n<\/ol>\n

                Data models are the frameworks for organizing data within a database. Different models have different ways of arranging and relating data.<\/p>\n

                  \n
                • Hierarchical Data Model<\/strong>\n
                    \n
                  • Structure: This model organizes data in a tree-like structure with a single “root” (main data point) and various “child” nodes.<\/li>\n
                  • Relationship: It supports a one-to-many relationship where each parent has multiple children, but each child has only one parent.<\/li>\n
                  • Use: Common in file systems and some legacy database systems.<\/li>\n<\/ul>\n<\/li>\n
                  • Network Data Model<\/strong>\n
                      \n
                    • Structure: This model connects data in a graph format where nodes (data points) can have multiple connections.<\/li>\n
                    • Relationship: It supports many-to-many relationships, meaning a data point can have several “parent” and “child” nodes.<\/li>\n
                    • Use: Used in more complex systems needing direct links between multiple data items, like telecommunications and organizational charts.<\/li>\n<\/ul>\n<\/li>\n
                    • Relational Data Model<\/strong>\n
                        \n
                      • Structure: Data is stored in tables (rows and columns).<\/li>\n
                      • Relationship: Tables can be related to each other through unique identifiers (keys) like primary keys and foreign keys.<\/li>\n
                      • Use: This is the most popular model and is commonly used in modern DBMS like MySQL, SQL Server, and LibreOffice Base.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
                          \n
                        1. Relational Database Model<\/strong><\/li>\n<\/ol>\n

                          The relational database model is a popular approach in DBMS where data is organized in tables related to each other.<\/p>\n

                            \n
                          • RDBMS Terminology<\/strong>\n
                              \n
                            • Table<\/strong>: A collection of rows and columns where data is stored.<\/li>\n
                            • Row (Record)<\/strong>: A single, horizontal entry in a table representing data for one item.<\/li>\n
                            • Column (Field)<\/strong>: A vertical entity in a table that holds specific information.<\/li>\n
                            • Primary Key<\/strong>: A unique identifier for each record in a table.<\/li>\n
                            • Foreign Key<\/strong>: A field in one table that links to the primary key of another table.<\/li>\n
                            • Attribute<\/strong>: Another term for a column in a table, representing data characteristics.<\/li>\n
                            • Tuple<\/strong>: Another name for a row in a table, containing related data.<\/li>\n<\/ul>\n<\/li>\n
                            • Objects of an RDBMS<\/strong>\n
                                \n
                              • Tables<\/strong>: The basic unit where data is stored in rows and columns.<\/li>\n
                              • Queries<\/strong>: Tools that help users fetch specific data by setting conditions.<\/li>\n
                              • Forms<\/strong>: User-friendly interfaces to enter or modify data in tables.<\/li>\n
                              • Reports<\/strong>: Customized formats to display data for easy analysis and understanding.<\/li>\n
                              • Indexes<\/strong>: Speed up data retrieval by organizing data in a specific order.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                These topics cover the basics of Database Management Systems, focusing on how data is managed, stored, and accessed efficiently in a structured format within a database.<\/p>\n

                                 <\/p>\n","protected":false},"excerpt":{"rendered":"

                                Introduction to DBMS Class 10 Notes (Database Management System) Data and Information Data: Data is raw, unorganized facts that need to be processed. Examples include numbers, text, or symbols. For instance, \u201c27\u201d or \u201cBlue\u201d are just data on their own. Information: Information is processed, organized data that makes sense. When data is put together meaningfully, […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-5222","post","type-post","status-publish","format-standard","hentry","category-information-technology-for-cbse-class-10"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/5222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=5222"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/5222\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=5222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=5222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=5222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}