{"id":5226,"date":"2024-12-01T20:56:25","date_gmt":"2024-12-01T15:26:25","guid":{"rendered":"https:\/\/cbsepython.in\/?p=5226"},"modified":"2024-12-01T20:56:25","modified_gmt":"2024-12-01T15:26:25","slug":"working-with-multiple-tables-class-10-notes","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/working-with-multiple-tables-class-10-notes\/","title":{"rendered":"Chapter 10 Working with Multiple Tables Class 10 Notes"},"content":{"rendered":"

Working with Multiple Tables Notes<\/strong><\/h2>\n

Editing and Deleting Tables<\/strong><\/h3>\n
    \n
  • Editing Tables<\/strong>: To change the structure of a table, such as adding, deleting, or modifying fields:\n
      \n
    • Open the table in Design View.<\/li>\n
    • Modify field names, data types, or add new fields as needed.<\/li>\n<\/ul>\n<\/li>\n
    • Deleting Tables<\/strong>: If a table is no longer needed, you can delete it:\n
        \n
      • Right-click on the table name and choose “Delete” from the menu.<\/li>\n
      • Be cautious, as deleting a table permanently removes all the data within it.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

        Relationships Between Tables<\/strong><\/h3>\n
          \n
        • Relationship<\/strong>: A relationship is a link between two tables based on a common field. Relationships help connect related data across multiple tables, making it easy to organize and retrieve information.<\/li>\n<\/ul>\n

          Types of Relationships<\/strong><\/h3>\n
            \n
          • One-to-One Relationship<\/strong>: Each record in Table A has only one matching record in Table B, and vice versa. Example: A student table and a library card table where each student has only one library card.<\/li>\n
          • One-to-Many Relationship<\/strong>: A record in Table A can have multiple matching records in Table B, but each record in Table B has only one match in Table A. Example: A customer table and an orders table where each customer can place many orders, but each order is linked to only one customer.<\/li>\n
          • Many-to-Many Relationship<\/strong>: Records in Table A can have multiple matching records in Table B, and records in Table B can have multiple matches in Table A. Example: A students table and a courses table, where each student can enroll in multiple courses, and each course can have many students.<\/li>\n<\/ul>\n

            Advantages of Relating Tables in a Database<\/strong><\/h3>\n
              \n
            • Data Organization<\/strong>: Relating tables reduces data duplication and helps keep the database organized.<\/li>\n
            • Easy Data Retrieval<\/strong>: Related tables make it simpler to gather related data through queries.<\/li>\n
            • Improved Data Accuracy<\/strong>: By connecting tables, databases can prevent redundant or conflicting information.<\/li>\n
            • Efficient Data Management<\/strong>: Managing related tables improves performance and helps save storage space.<\/li>\n<\/ul>\n

              Creating Relationships Between Tables<\/strong><\/h3>\n
                \n
              • To create a relationship:\n
                  \n
                • Open the Relationships window<\/strong> in LibreOffice Base.<\/li>\n
                • Drag a field (usually the primary key) from one table to the matching field in another table.<\/li>\n
                • Set the relationship type (One-to-One, One-to-Many, etc.) and confirm.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                  Referential Integrity<\/strong><\/h3>\n
                    \n
                  • Referential Integrity<\/strong>: This rule ensures that relationships between tables remain consistent. If a record in one table is related to records in another table, referential integrity makes sure that changes in one table don\u2019t break the link in another.<\/li>\n
                  • Purpose<\/strong>:\n
                      \n
                    • Prevents accidental deletion of records that are related to others.<\/li>\n
                    • Keeps data accurate and reliable across related tables.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                      These concepts form the foundation of working with multiple tables in a database, helping students understand how data can be efficiently managed and interconnected for better organization and retrieval.<\/p>\n

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

                      Working with Multiple Tables Notes Editing and Deleting Tables Editing Tables: To change the structure of a table, such as adding, deleting, or modifying fields: Open the table in Design View. Modify field names, data types, or add new fields as needed. Deleting Tables: If a table is no longer needed, you can delete it: […]<\/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-5226","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\/5226","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=5226"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/5226\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=5226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=5226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=5226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}