Database Management System

Database Management System syllabus

• 1.1 Introduction to data, database, Database system, DBMS
• 1.2 Field, Record, Objects, Primary Key, Alternate key, Candidate key
• 1.3 Advantages of using DBMS
• 1.4 DDL (Data Definition Language) and DML (Data Manipulation Language)
• 1.5 Database Model: Network Model, Hierarchical Model, Relational database model
• 1.6 Concept of Normalization: 1NF, 2NF, 3NF
• 1.7 Centralized Vs. Distributed Database
• 1.8 Database Security

Important Questions from Database Management System - NEB Class 12  Computer Science

Short Answer Questions:

• Differentiate between Database and DBMS. Explain the top-down methodology
  of Database design.
• Explain the benefits of a centralized database System.
• Write the advantages and disadvantages of DBMS.
• Define primary key, candidate key, and alternate key. Write the importance of the
  primary key with a suitable example.
• Explain DDL and DML with some common commands.
• Differentiate between centered and distributed database systems.
• Short Notes
  • Data and information
  • Field and record
  • Data Dictionary
  • DDL
  • DML
  • Primary Key
  • Relationship