DATABASE MANAGEMENT SYSTEM (DBMS) – COMPLETE NOTES
SEE Computer Science | Class 10
CDC New Curriculum – 2083Complete 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
ReplyDeleteThis is a very informative and well-written blog. I really enjoyed reading the content because it explains the topic in a simple and easy-to-understand way. The information shared here is useful for both beginners and people who already have some knowledge about the subject. I especially liked how the important points were explained with clarity and practical details. Blogs like this are helpful because they provide valuable knowledge without making the topic complicated. Thank you for sharing such useful information. I will definitely visit your blog again to read more interesting and informative articles. Keep sharing quality content like this. Best Fashion Designing institute in Delhi NCR
Art & Craft Institute in Delhi
business analytics course in delhi ncr