TABFlux

Home Courses Universities Programs Forum

© 2026 TABFlux. All rights reserved. Built for students, by students.

Forum Privacy Policy Terms of Service Contact Us Contributors

Database Management System

Database Management System (DBMS) is software that enables efficient creation, storage, retrieval, and management of data. It covers data models, SQL, normalization, transactions, concurrency control, and security, ensuring data integrity, consistency, and reliable access for applications.

Select University

Select Program

BSC-CSIT BDS BCA-OLD BIT BCT-NEW

TabFlux . Database Management System . TU . BIT

Database Management System

0%

Course Title: Database Management System

Course No: BIT202

Nature of the Course: Theory + Lab

Semester: 3

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Credit Hours: 3

Course Description

Course Objectives

Course Contents

1. Database Concepts and Architecture

4 hrs

1.1. Database, Database Management System, Database Users, and Benefits of Databases

1.2. Data Models, Schemas, and Instances

1.3. Three-Schema Architecture and Data Independence

1.4. Database Languages and Interfaces

1.5. The Database System Environment

1.6. Centralized and Client/Server Architectures for DBMSs

1.7. Classification of Database Management Systems

2. Data Modeling Using the Entity-Relational Model

5 hrs

2.1. Using High-Level Conceptual Data Models for Database Design

2.2. Entity Types, Entity Sets, Attributes, and Keys

2.3. Relationship Types, Relationship Sets, Roles, and Structural Constraints

2.4. Weak Entity Types

2.5. ER Diagrams, Naming Conventions, and Design Issues

2.6. Relationship Types of Degree Higher Than Two

2.7. Subclasses, Superclasses, and Inheritance

Specialization and Generalization

Constraints and Characteristics of Specialization and Generalization

3. The Relational Data Model and Relational Database Constraints

5 hrs

3.1. Relational Model Concepts

3.2. Relational Model Constraints and Relational Database Schemas

3.3. Update Operations, Transactions, and Dealing with Constraint Violations

3.4. Basic Relational Algebra Operations

10 hrs

4.1. Data Definition and Data Types

4.2. Specifying Constraints

4.3. Basic Retrieval Queries

4.4. Complex Retrieval Queries

4.5. INSERT, DELETE, and UPDATE Statements

5. Relational Database Design

7 hrs

5.1. Relational Database Design Using ER-to-Relational Mapping

5.2. Informal Design Guidelines for Relational Schemas

5.3. Functional Dependencies

5.4. Normal Forms Based on Primary Keys

5.5. General Definitions of Second and Third Normal Forms

5.6. Boyce-Codd Normal Form

5.7. Multivalued Dependency and Fourth Normal Form

5.8. Properties of Relational Decomposition

6. Transaction Processing and Concurrency Control, and Recovery

8 hrs

6.1. Introduction to Transaction Processing

6.2. Transaction and System Concepts

6.3. Desirable Properties of Transactions

6.4. Serializable Schedule

6.5. Two-Phase Locking and Timestamp Ordering Concurrency Control Techniques

7. Database Recovery Techniques

3 hrs

7.1. Recovery Concepts

7.2. NO-UNDO/REDO Recovery Based on Deferred Update

7.3. Recovery Technique Based on Immediate Update

7.4. Shadow Paging

7.5. Database Backup and Recovery from Catastrophic Failures

3 hrs

8.1. Structured and Unstructured Data

8.2. Introduction to NoSQL Databases

8.3. Discussion of basic architecture of Hbase, Cassandra and MongoDb

Laboratory Works

1.Database creation and basic SQL queries
2.Advanced SQL queries

Text Books

1.Fundamentals of Database Systems; Seventh Edition; Ramez Elmasri, Shamkant B. Navathe; Pearson Education
2.Database System Concepts; Sixth Edition; Avi Silberschatz, Henry F Korth, S Sudarshan; McGraw-Hill
3.NoSQL for Dummies; Adam Fowler; John Wiley & Sons, Inc.

Reference Books

1.Database Management Systems; Third Edition; Raghu Ramakrishnan, Johannes Gehrke; McGraw-Hill
2.A First Course in Database Systems; Jaffrey D. Ullman, Jennifer Widom; Third Edition; Pearson Education Limited

Notes:

Source:

The course covers the basic concepts of databases, database system concepts and architecture, data modeling using ER diagram, relational model, SQL, relational algebra and calculus, normalization, transaction processing, concurrency control, and database recovery.

The main objective of this course is to introduce the basic concepts of database, data modeling techniques using entity relationship diagram, relational algebra and calculus, basic and advanced features SQL, normalization, transaction processing, concurrency control, and recovery techniques.

The laboratory work includes writing database programs to create and query databases using basic and advanced features of structured query language (SQL).

This syllabus follows the official BIT curriculum of Tribhuvan University. In case of any doubt or revision, the university’s published syllabus shall be considered authoritative.