AKTU Database Management System (BMBIT03) Syllabus PDF – MBA 3rd Semester

Course Objectives

• 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.

Unit - I: 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

Unit - II: 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)

Unit - III: 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

Unit - IV: 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

Unit - V: 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 Outcomes

Suggested Readings

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