CB3401 - Database Management Systems and Security Syllabus Regulation 2021 Anna University

Subject code CB3401 deals with the database management systems and security subject. In this article, we try to provide the syllabus of the cb3401 database management systems and security syllabus based on the Affiliated Institutions of Anna University 2021 Regulation syllabus.

If you see nowadays, students are requesting brief descriptions of anything they want to know. Today social media platforms and search engines are running information throughout the world, just by searching the concept by the people. Especially when it comes to education, every subject in any field has been provided. There is a lot of demand to provide accurate education information in the market. Among them is aplustopper.com tries to give the best of its content for students. In this article, the CB3401 – Database Management Systems and Security Syllabus is given briefly without getting rid of a single concept of the subject from the Anna University B.E Computer Science and Engineering (Cyber security) syllabus.

If you want to know more about the syllabus of B.E Computer Science and Engineering (Cyber security) Syllabus connected to an affiliated institution’s four-year undergraduate degree program. We provide you with a detailed Year-wise, semester-wise, and Subject-wise syllabus in the following link B.E Computer Science and Engineering (Cyber security) Syllabus Anna University, Regulation 2021.

Aim Of Concept:

  • 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

CB3401 – Database Management Systems and Security Syllabus

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

CB3401 - Database Management Systems and Security Syllabus Regulation 2021 Anna University

Unit V: Access Control And Encryption

Database Access Control – SQL based access definition – Cascading Authorizations – Rolebased access control – Inference – Database encryption

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.

Related Posts On Semester – IV:

Must Read For More:

Anna University Syllabus 2021