Scribd
Upload
2 views1 page

Class10 Database Management Notes

The document provides an overview of Database Management Systems (DBMS), covering key concepts such as databases, their structure, relationships, queries, forms, and reports. It explains the advantages of using DBMS, the organization of data in tables, and the types of relationships between records. Additionally, it outlines how queries can be used to manipulate data and the purpose of forms and reports in data management.

Uploaded by

saacheemohanty
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

Class10 Database Management Notes

The document provides an overview of Database Management Systems (DBMS), covering key concepts such as databases, their structure, relationships, queries, forms, and reports. It explains the advantages of using DBMS, the organization of data in tables, and the types of relationships between records. Additionally, it outlines how queries can be used to manipulate data and the purpose of forms and reports in data management.

Uploaded by

saacheemohanty
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Class 10 – Database Management System (DBMS)

1. Database Basics
• Database: Organized collection of related data.
• DBMS: Software to manage databases (e.g., Base, MySQL, MS Access).
• Advantages: Reduces duplication, ensures security & consistency, easy updates.

2. Structure of a Database
• Table: Stores data in rows (records) & columns (fields).
• Field Types: Text, Number, Date/Time, Currency, Boolean.
• Primary Key: Unique field identifying each record.
• Foreign Key: Links two tables.

3. Relationships
• One-to-One: Each record linked to one in another table (e.g., Student–ID Card).
• One-to-Many: One record linked to many others (e.g., Teacher–Students).
• Many-to-Many: Multiple records linked both ways (e.g., Students–Subjects).

4. Queries
• Retrieve, filter, or modify data based on conditions.
• Types: Select, Update, Delete Queries.
• Example: Show students scoring >90.
• Operators: =, <, >, <=, >=, AND, OR, BETWEEN, LIKE.

5. Forms
• User-friendly interface for data entry/editing.
• Created using Form Wizard.
• Benefits: Easy data entry, prevents mistakes, shows one record at a time.

6. Reports
• Present data in formatted printable layout.
• Created using Report Wizard.
• Components: Header, Footer, Title, Detail Section.
• Use: For summaries, e.g., student marks report.

— End of Notes —

You might also like