# DBMS for Class 10 IT (Code 402) - Database Fundamentals
> Learn Database Management System basics for CBSE Class 10 IT. Covers RDBMS, Primary Keys, SQL commands (DDL/DML), and data types with clear examples.

Tags: dbms, class-10-it, sql, rdbms, database-management, cbse-code-402, computer-science
## Database Management System | Class 10 IT (Code 402)
* Comprehensive guide for Unit 3 of the Information Technology curriculum.

## Data vs. Information
* **Data:** Raw facts like '10' or 'Rahul'.
* **Information:** Processed data with context, e.g., 'Rahul is in Class 10'.

## What is a DBMS?
* Software to define, manipulate, and manage data.
* Examples: MySQL, Oracle, MS Access.

## Popular Databases 2023-2024
* PostgreSQL (49%)
* MySQL (45%)
* SQLite (30%)
* MongoDB (28%)
* Microsoft SQL Server (25%)

## Key Benefits
* Reduces redundancy and inconsistency.
* Facilitates data sharing and ensures security.

## Relational Data Model (RDBMS)
* Stores data in 'Relations' (Tables).
* Most popular format used by MySQL and OpenOffice Base.

## Database Components
* **Table:** Organized set of elements.
* **Record (Tuple):** A single row.
* **Field (Attribute):** A single column.

## Keys in Database
* **Primary Key:** Unique identifier for a record; cannot be NULL.
* **Foreign Key:** Cross-reference field linking to another table's primary key.

## Common Data Types
* **Numeric:** Integer, Decimal, Float.
* **Alphanumeric:** CHAR (fixed), VARCHAR (variable).
* **Binary:** BLOB (images/sounds).
* **Date/Time:** Calendars and timestamps.

## SQL Commands
* **DDL (Data Definition):** CREATE, ALTER, DROP.
* **DML (Data Manipulation):** INSERT, UPDATE, DELETE, SELECT.

## Database Objects
* **Forms:** User-friendly interfaces for data entry.
* **Reports:** Formatted summaries for printing.

## Relationship Types
* One-to-One
* One-to-Many
* Many-to-Many
---
This presentation was created with [Bobr AI](https://bobr.ai) — an AI presentation generator.