📘 DATABASE MANAGEMENT SYSTEM (DBMS) – COMPLETE NOTES 💻 SEE Computer Science | Class 10 📚 CDC New Curriculum – 2083

 

DATABASE MANAGEMENT SYSTEM (DBMS) – COMPLETE NOTES

DOWNLOAD PDF NOTES

SEE Computer Science | Class 10

CDC New Curriculum – 2083

Complete study notes covering the major concepts of Database Management System (DBMS) in a simple, organized, and exam-focused format.

Topics Covered:

• Database – Definition, Importance & Applications

• Manual and Computerized Database

• Data and Information

• DBMS – Features, Advantages & Disadvantages

• RDBMS

• Database Data Types

• Tables, Rows and Columns

• Field (Attribute) and Record (Tuple)

• Entity

• Primary Key, Foreign Key & Composite Key

• Database Relationships – 1:1, 1:M & M:N

• MySQL – Features, Advantages & Applications

• Relational Tables

• Query and Report

• MySQL Constraints

• DDL – CREATE, ALTER, DROP, TRUNCATE & RENAME

• DML – SELECT, INSERT, UPDATE & DELETE

• WHERE Clause & LIKE Operator

• SQL Queries and Practical Examples

• MySQL Installation and Basic Practical Tasks

• Important MCQs and Question-Answers

Useful for:

SEE preparation, class notes, revision, theory examinations, and practical preparation.

Prepared by: Deepak Shrestha