Purbanchal University
BBA V Semester
LH: 48
Course Title: Database Management
Area of Study: Core
Credit Hours: 3
Course Code: IT 355
Course Objectives:
This course introduces the principles of database management systems (DBMS) and covers the design, implementation, and management of databases. It emphasizes the use of SQL for data manipulation and explores various types of database architectures.
Course Contents:
Unit 1: Introduction to Database Systems LH6
• Overview of database systems
• Importance and applications of databases
• Database System Vs. File System
• Purpose and Advantages of Database Systems
• Types of database systems : hierarchical, network, relational, and object-oriented
• Components of a database system
Unit 2: Database Design LH 8
• Database design concepts and terminology
• Principles of Database Design
• Functional Dependencies
• Entity-Relationship (ER) modeling
• Converting ER diagrams to relational schema
• Normalization : 1NF, 2NF, 3NF, BCNF
Unit 3: Structured Query Languages (SQL) LH 12
• Introduction to SQL and its syntax
• Data Definition Language (DDL) commands
• Data Manipulation Language(DML) commands
• Basic SQL Queries : CREATE, SELECT, INSERT, UPDATE, DELETE, COUNT, GROUP BY, SUM, ORDERBY, DROP, ALTER, CHECK, UPDATE, MIN,MAX,HAVING
• SQL Functions and Expressions
• Sub queries and nested queries
• Views and indexes
• SQL Constraints and Keys
Unit 4: Database Management and Administration LH 6
• Roles and responsibilities of a database administrator
• Backup and recovery strategies
• Database security and access control
• Performance tuning and optimization techniques
Unit 5: Database Security LH 6
• Database Security and Integrity
• Authentication and Authorization
• Security Models and Policies
• Encryption Techniques
Unit 6: Query Processing LH 4
• Introduction to Transaction, ACID property and concurrency control
• Query Optimization Techniques
• Step in query Processing
Unit 7: IT Governance and Ethics LH 6
• Cloud database and database as a service (DBaaS)
• Big data technologies and their impact on database
• Database management in the context of IoT
• Future trends in database systems
Reference Books:
1. Rob, P., & Coronel, C. (2018), Database Systems: Design, implementation & management (13th ed.), Cengage Learning
2. Elmasri, R., & Navathe, S.B. (2016), Fundamentals of database systems (7th ed.), Pearson
3. Coronel, C., & Morris, S. (2015), Database design using UML and SQL (3rd ed.), Cengage Learning.
4. Sadalage, P. J., & Fowler, M. (2013), NoSQL distilled: A brief guide to the emerging world of polyglot persistence, Addison-Wesley
5. Immon, W.H., & Imhoff, C. (2005), Corporate information factory (2nd ed.), Wiley.
6. Gupta, A. (2017), Fundamentals of database management systems, Cambridge University Press
