UNIQUE SERIES AKTU Syllabus
BMBIT03

Database Management System

L-T-P3-0-0 Session2025-26 TypeTheory
Appears in 1 semester

MBA General · Sem 3 (Specialization: Information Technology (IT))

Download PDF

Syllabus

5 units
Unit1

Unit 1: 6 hrs

Introduction to Database Systems: Basic concepts: Data, information, fields, records, files, databases; Evolution and need for database systems in business; Data models: Hierarchical, network, relational, object-oriented; File-oriented systems vs. Database systems; Three-layered architecture of DBMS; Applications and advantages/disadvantages of DBMS

Unit2

Unit 2: 8 hrs

Data Modelling & Database Design: Entity-Relationship (ER) Model - Entities, attributes, relationships, constraints, ER diagrams, extended features (generalization, specialization, aggregation); Relational database model - Structure, keys (primary, foreign), integrity constraints, Normalization (1NF, 2NF, 3NF, BCNF); Relational schema and table design; Role and responsibilities of the Database Administrator (DBA)

Unit3

Unit 3: 8 hrs

Relational Query Languages: Structured Query Language (SQL) -Data Definition Language (DDL), Data Manipulation Language (DML), Creating, altering, and deleting tables, Data types, constraints, aggregate functions, Joins, sub-queries, views, transaction control commands (commit, rollback); Relational algebra and calculus - Operators: Selection, projection, join, set operations

Unit4

Unit 4: 8 hrs

Database Implementation & Management: Database storage and physical structures - Indexing, B-trees, hashing; Query processing and optimization - Evaluation strategies, query cost analysis; Backup, recovery, and disaster management; Concurrency control: Locking, timestamping, deadlocks; Transaction management and ACID properties

Unit5

Unit 5: 10 hrs

Security, Authorization, and Advanced Topics: Database security: Authentication, authorization, privileges, threats; Auditing, access controls, violation handling; Data integrity and constraints; Distributed databases and client-server architecture basics; Introduction to data warehousing, OLAP, OLTP, and data mining concepts Practical Applications & Case Studies: Use of commercial and open-source DBMS (e.g., MySQL, Oracle, SQL Server); Case studies from finance, marketing, HR, retail, and e-commerce sectors; Designing and demonstrating a relational database for a business use case

Course Objectives6 points
  • To understand the core principles and architecture of database systems.
  • To develop ER models and relational schema for real-world applications.
  • To formulate complex SQL queries and apply normalization techniques.
  • To analyze query optimization and transaction management strategies.
  • To examine database security, recovery, and concurrency mechanisms.
  • To explore emerging concepts in distributed databases and data warehousing.
Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

  1. CO1Understand fundamental database concepts and the need for DBMS in modern organizations. (Understanding)K2
  2. CO2Apply data modeling techniques to design relational databases and use SQL for data manipulation. (Applying)K3
  3. CO3Analyze database normalization and indexing methods for data integrity and performance. (Analyzing)K4
  4. CO4Evaluate transaction management, backup, and recovery mechanisms. (Evaluating)K5
  5. CO5Design and implement secure, scalable databases and understand trends in warehousing and data mining. (Creating)K6

Suggested Readings

  1. Chakrabarti- Advance Database Management System (Wiley Dreamtech)
  2. Beynon- Davies P- Database Systems (Palgrave, 2003)
  3. Karthikeyan- Understanding Database Management System (Acme Learning)
  4. Hoffer- Modern Database Management (Pearson Education, 6th edition)
  5. Alexis and Leo- Database Management System (Vikas, 2003.)
  6. Majumdar and Bhattacharya- Database Management System (Tata Mc Graw Hill, 1996).
  7. Navathe- e-Fundamentals of Database Systems (Pearson Education, 3rd Ed.)

Official AKTU syllabus

This subject is on page 48, 49 of the original AKTU PDF.

Official AKTU syllabus PDF ↗