CB3401 Database Management Systems and Security Syllabus:
CB3401 Database Management Systems and Security Syllabus – Anna University Regulation 2021
COURSE OBJECTIVES:
To learn the fundamentals of data models, conceptualize and depict a database system using ER diagram.
To study the principles to be followed to create an effective relational database and write SQL queries to store/retrieve data to/from database systems.
To know the fundamental concepts of transaction processing, concurrency control techniques and recovery procedure.
To understand the need of security in Database Management systems
To learn how to secure Database Management systems
UNIT I RELATIONAL DATABASES
Data Models – Relational Data Models – Relational Algebra – Structured Query Language – Entity-Relationship Model – Mapping ER Models to Relations – Distributed Databases – Data Fragmentation – Replication
UNIT II DATABASE DESIGN
ER Diagrams – Functional Dependencies – Non-Loss Decomposition Functional Dependencies – First Normal Form – Second Normal Form – Third Normal Form – Dependency Preservation – Boyce/Codd Normal Form – Multi-Valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form
UNIT III TRANSACTION MANAGEMENT
Transaction Concepts – ACID Properties – Serializability – Transaction Isolation Levels – Concurrency Control – Need for Concurrency – Lock-Based Protocols – Deadlock Handling – Recovery System – Failure Classification – Recovery Algorithm.
UNIT IV DATABASE SECURITY
Need for database security – SQL Injection Attacks – The Injection Technique – SQLi Attack Avenues and Types
UNIT V ACCESS CONTROL AND ENCRYPTION
Database Access Control – SQL based access definition – Cascading Authorizations – Rolebased access control – Inference – Database encryption
TOTAL: 45 PERIODS
COURSE OUTCOMES:
At the end of this course, the students will be able to:
CO1: Model an application’s data requirements using conceptual modeling and design database schemas based on the conceptual model.
CO2: Formulate solutions to a broad range of query problems using relational algebra/SQL.
CO3: Demonstrate an understanding of normalization theory and apply such knowledge to the normalization of a database.
CO4: Run transactions and estimate the procedures for controlling the consequences of concurrent data access.
CO5: Understand and handle security issues in database management systems
TEXT BOOKS:
1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Seventh Edition, Tata McGraw Hill, 2021.
2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2016.
3. William Stallings, Lawrie Brown, “Computer Security: Principles and Practice”, Fourth Edition, Pearson, 2019.
REFERENCES:
1. C.J. Date, A. Kannan and S. Swamynathan, “An Introduction to Database Systems”, Pearson Education, Eighth Edition, 2006.
2. Raghu Ramakrishnan and Johannes Gehrke, “Database Management Systems”, Third Edition, McGraw Hill, 2014.
3. Narain Gehani and Melliyal Annamalai, “The Database Book: Principles and Practice Using the Oracle Database System”, Universities Press, 2012.