TABFlux

Home Courses Universities Programs Forum

Guides Contact Us

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

Forum Privacy Policy Terms of Service Contact Us Contributors

database mgmt system - Syllabus | TABFlux

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 BIM BIT BCT

TabFlux . Database Management System . TU . BIM

Database Management System

0%

Course Title: Database Management System

Course No: IT 220

Nature of the Course: Theory + Lab

Semester: 4

Credit Hours: 3

Course Description

Course Objectives

Course Contents

1. Database Concepts and Architecture

4 hrs

1.1. Database, Database Management System, Database Users, Database Administrator, advantages 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 Modelling Using Entity-Relational Model and Relational Model

8 hrs

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

2.2. Entity Types, Entity Sets, Attributes, and Keys; Relationship Types, Relationship Sets, Roles, and Structural Constraints

2.3. Weak Entity Types

2.4. ER Diagrams, Naming Conventions, and Design Issues

2.5. Relationship Types of Degree Higher Than Two

2.6. Concepts of Specialization and Generalization; Constraints and Characteristics of Specialization and Generalization

2.7. Converting ER Diagrams to Tables

3. The Relational Algebra and Relational Calculus

5 hrs

3.1. Introduction of Relational Algebra

3.2. Unary Relational Operations: SELECT and PROJECT

3.3. Relational Algebra Operations from Set Theory

3.4. Binary Relational Operations: JOIN and DIVISION

3.5. Additional Relational Operations

3.6. The Tuple Relational Calculus

3.7. The Domain Relational Calculus

4. Database Normalization

4 hrs

4.1. Informal Design Guidelines for Relational Schemas

4.2. Functional Dependencies

4.3. Normal Forms Based on Primary Keys

4.4. First, Second and Third Normal Forms

4.5. Boyce-Codd Normal Form

4.6. Multivalued Dependency and Fourth Normal Form

4.7. Properties of Relational Decomposition

15 hrs

5.1. Data Definition Language and Data Types, Specifying Constraints, Domain Types in SQL, Schema Definition in SQL

5.2. Data Manipulation Language

The select Clause, The where Clause, The from Clause, The Rename Operation, Tuple Variables, String Operations, Ordering the Display of Tuples, Duplicate Tuples

5.3. Set Operations

5.4. Aggregate Functions

5.5. Null Values

5.6. Nested Subqueries

Set Membership, Set Comparison, Test for Empty Relations, Test for the Absence of Duplicate Tuples

5.7. Derived Relations: Views

5.8. Modification of the Database: Deletion, Insertion, Updates, Update of a view

5.9. Joined Relations: Join types and Conditions

5.10. Basic concepts of Stored Procedure, DML Triggers, and Indexing

6. Transaction Processing, Concurrency Control and Recovery Techniques

8 hrs

6.1. Introduction to Transaction Processing; Transaction and System Concepts; Desirable Properties of Transactions

6.2. Serializable Schedule

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

6.4. Recovery Concepts

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

6.6. Recovery Technique Based on Immediate Update

6.7. Shadow Paging

6.8. Database Backup and Recovery from Catastrophic Failures

7. Advanced Topics

4 hrs

7.1. Database Performance Tuning

7.2. Database Security

7.3. Concept of Parallel and Distributed Databases

7.4. Concept of Data Warehousing and Data Mining, BigData, and NoSQL databases

Laboratory Works

1.SQL statements to create databases and tables
2.Inserting and deleting data
3.Updating data
4.Writing select queries
5.Project work

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.
4.Principles of Distributed Database Systems; M. Tamer Ozsu and Patrick Valduriez; Fourth Edition; Springer 2020
5.Database Management Systems; Third Edition; Raghu Ramakrishnan, Johannes Gehrke; McGraw-Hill
6.A First Course in Database Systems; Jaffrey D. Ullman, Jennifer Widom; Third Edition; Pearson Education Limited.

Notes:

Source:

The course covers different concepts of database management systems including database system concepts and architecture, ER diagram, relational model, relational Calculus, SQL, normalization, transaction processing, concurrency control, and database recovery. This course also covers some advanced concepts of databases such as performance tuning, security, parallel and distributed database, data warehousing, data mining and bigdata.

The main objective of this course is to introduce different concepts of database management system from theoretical and practical aspects.

The laboratory work includes writing SQL statements to create databases and tables, inserting and deleting data, updating data, and writing select queries. The students are required to undertake a project work. The project work can be done individually or in group (at most 4 students).

This syllabus follows the official BIM curriculum of Tribhuvan University. In case of any doubt or revision, the university’s published syllabus shall be considered authoritative.https://www.fomecd.edu.np/syllabuses