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 . BCA-OLD

Database Management System

0%

Course Title: Database Management System

Course No: CACS255

Nature of the Course: Theory + Lab

Semester: 4

Full Marks: 20 + 20 + 60

Pass Marks: 8 + 8 + 24

Credit Hours: 3

Course Description

Course Objectives

Course Contents

1. Introduction to DBMS

3 hrs

1.1. Introduction of Database Management System

1.2. Objective of Database Management System

1.3. Importance of DBMS, Merit and Demerit of DBMS

1.4. Application of DBMS

2. Database Design, Architecture and Model

6 hrs

2.1. Overview of The Database Designing Process and View of Data

2.2. Structure of Database Management System, Level Database Architecture and Data Independence

2.3. Database Languages: DDL, DML, QBE

2.4. Data Models: Hierarchical, Network, Relational, E-R Model, Object Base Data Model

2.5. E-R Diagram: Concepts, Relationship, Entity Relationship Diagram

2.6. Weak Entity Sets, Strong Entity Set, Aggregation, Generalization

2.7. Converting ER Diagrams to Tables

3. Relational Database Model

4 hrs

3.1. Structure of RDBMS and Terminology

3.2. Database Schema and Schema Diagram

3.3. Keys: Super, Candidates, Primary, Foreign, Composite etc. and Relationship

3.4. Introduction to Relational Algebra

3.5. Relational Algebra Operations: Select, Project, Cartesian Product, Union, Set Difference, Natural Join, Outer Join

4. Database Normalization

4 hrs

4.1. Definition and Importance of Normalization

4.2. Functional Dependencies

4.3. Normalization: 1NF, 2NF, 3NF, BCNF and 4NF

5. Creating and Altering Database and Tables (SQL)

6 hrs

5.1. Introduction to SQL

5.2. Creating Database with Different Type of Arguments and Alter Database

5.3. Creating Normal Tables and Complex Tables with Different Type of Constraints (Key, Check, Default)

5.4. Alter Tables: Adding and Dropping Attributes and Other Constraints

5.5. Drop Statement: Table, Database

6. Manipulating and Querying Data

8 hrs

6.1. Adding Data with INSERT Statement

6.2. Retrieving Data with SELECT Statement and FROM Clause and Filter Data with WHERE Clause

6.3. Order and Grouping Data with ORDER and GROUP by Clause

6.4. Summarizing the Select Statement

6.5. Retrieving Data from Different Tables using: INNER JOINS, OUTER JOIN and CROSS JOIN

6.6. Building Nested Queries, Manipulate Data Using UPDATE Statement and Removing Rows Using DELETE Statement

6.7. Creating and Altering View

7. Developing Stored Procedures, DML Triggers and indexing

5 hrs

7.1. Managing Stored Procedures, Create, Alter, Drop, Execute Stored Procedure

7.2. Encryption, Passing Data To Stored Procedures, Parameter Default, Returning Data From Stored Procedure

7.3. Output Parameter Using The Return Statement

7.4. Transaction Flow, Creating Triggers, Triggers Limitation

7.5. Disabling Trigger, Developing Multi Row Enabled Triggers

7.6. Basic Concept of Indexing, Ordered Indices, Type of Indexing, Multiple Key Access

7.7. Creating And Dropping Index

8. Query Processing and Security

5 hrs

8.1. Overview of Query Processing, Measuring of Query Cost

8.2. Selection Operation, Sorting, Joining Evaluation of Expression

8.3. Query Optimization

8.4. Database Administrator: DBA Roles and Responsibilities

8.5. Database Security Issues, Types of Security, Access Protection

8.6. User Accounts and Database Audits, Discretionary Access Control

8.7. Mandatory Access Control, Data Encryption And Decryptions

9. Transaction and Concurrency Control

4 hrs

9.1. Transaction Concept, Simple Transaction Model

9.2. Atomicity and Durability, Transaction Isolation, Serializability

9.3. Transaction Isolation and Atomicity and Transaction Isolation Levels

9.4. Introduction, Lock-Based Protocol, Dead-Lock Handling

9.5. Multiple Granularity, Time-Based Protocol

Laboratory Works

1.Laboratory Works

Text Books

1.Abraham Silberschatz, “Database System Concept”, 6th Edition, McGraw Hill

Reference Books

1.Elmasri – Navathe, “Fundamental of Database System”, 5th Edition, Pearson
2.James R. Groff and Paul N. Weinberg, “The complete Reference SQL”, 3rd Edition
3.Jason Price, “Oracle Database 11g SQL”, McGraw Hill, 2007
4.Robert Vieria, “Microsoft SQL Server 2008 Programming”, Wiley India

Notes:

Source:

This course offers both theoretical as well as practical knowledge of database management system so that students can handle back end of software while developing any types of application packages.

The general objectives of this subject are to provide the basic concept, theory and practices in design and implementation of DBMS. Students will also be good for handling different type of data transaction by using SQL commands.

Lab works should be done covering all the topics listed above using Oracle and a small project work should be carried out using the concept learnt in this course. Project should be assigned on Individual Basis.

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