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
Unit V: Access Control And Encryption
Database Access Control – SQL based access definition – Cascading Authorizations – Rolebased access control – Inference – Database encryption
Text Books:
- Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Seventh Edition, Tata McGraw Hill, 2021.
- Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2016.
- William Stallings, Lawrie Brown, “Computer Security: Principles and Practice”, Fourth Edition, Pearson, 2019.
References:
- C.J. Date, A. Kannan and S. Swamynathan, “An Introduction to Database Systems”, Pearson Education, Eighth Edition, 2006.
- Raghu Ramakrishnan and Johannes Gehrke, “Database Management Systems”, Third Edition, McGraw Hill, 2014.
- Narain Gehani and Melliyal Annamalai, “The Database Book: Principles and Practice Using the Oracle Database System”, Universities Press, 2012.
Related Posts On Semester – IV:
- CS3452 – Theory of Computation
- CS3491 – Artificial Intelligence and Machine Learning
- CB3491 – Cryptography and Cyber Security
- GE3451 – Environmental Sciences and Sustainability
Must Read For More: