Database Management System (CMP 222) — Semester III notes, Pokhara University BECE
Design and use of databases: the relational model, ER modelling, SQL, relational algebra, normalization, indexing, query processing, transactions, concurrency control and recovery.
55 files: lecture notes, question collections, lab reports and more for Database Management System.
Syllabus
- Database Management System.pdf
Extra Notes
- Authentication vs Authorization.jpg
- DAC vs MAC.jpg
- Security_levels.md
Files
- Full_Handwritten_DBMS.pdf
- Full_Note_DBMS.pdf
- Important_Qsn_for_Exam.pdf
NCIT Assignments
- DBMS_Assignment1_Arpan.pdf
- DBMS_Assignment2_Arpan.pdf
- DBMS_Assignment3_Arpan.pdf
- DBMS_Assignment4&7_Arpan.pdf
NCIT Lab Works
- Lab_Exam_DBMS_Arpan.pdf
- Lab1_Arpan Adhikari(Roll 9).docx
- Lab2_Arpan Adhikari(Roll 9).docx
- Lab3_Arpan Adhikari(Roll 9).docx
- Lab4_Arpan Adhikari(Roll 9).docx
- Lab5_Arpan Adhikari(Roll 9).docx
- Lab6&7_Arpan Adhikari(Roll 9).docx
- Lab8_Arpan Adhikari(Roll 9).docx
- Lab9_Arpan Adhikari(Roll 9).docx
- Lab10_Arpan Adhikari(Roll 9).docx
Unit 1_Introduction
- Chapter_1 Introduction.pdf
- Chapter1.pdf
Unit 2_ER and Relational Model
- Chapter_2 - ER Model - Part_1.pdf
- Chapter_2 - ER Model - Part_2.pdf
- Chapter2_ER and Relational Model.pdf
- Data Models.pdf
Unit 3_Structured Query Language
- Chapter3_SQL.pdf
- Formal Relational Query Language.pdf
- SQL Note.pdf
- SQL Practice Qsn.pdf
- SQL.pdf
Unit 4_Relational Database Design
- Chapter4_Relational Database design.pdf
- Relational Database - Part_1.pdf
- Relational Database - Part_2.pdf
Unit 5_Security
- Chapter5_Security.pdf
- Security.pdf
Unit 6_Query Processing and Optimization
- Chapter_6.pdf
- Chapter6_Query processing and optimization.pdf
Unit 7_Storage Management and Indexing
- Chapter_7 - Part_1.pdf
- Chapter_7 - Part_2.pdf
- Chapter_7 - Part_3.pdf
- Chapter_7 - Part_4.pdf
- Chapter7_Storage management and indexing.pdf
Unit 8_Transactions and Concurrency Control
- Chapter8_Transaction and Concurrency Control.pdf
- Concurrency Control.pdf
- Transactions.pdf
Unit 9_Crash Recovery
- Chapter9_Crash Recovery.pdf
- Recovery System.pdf
Unit 10_Emerging Trend in Databases
- DIstributed Database.md
- Distributed Database.pdf
- Object Based Databases.pdf
- OODB over Relational.md
- ORM.md
- SQL vs NoSQL.png