Database Management Systems detailed syllabus for Information Technology (IT) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the IT students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Information Technology 3rd Sem scheme and its subjects, do visit IT 3rd Sem 2019 regulation scheme. The detailed syllabus of database management systems is as follows.
Course Objective:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Unit I
Relational Databases
Purpose of Database System – Views of Data – Data Models – Database System Architecture – Introduction to Relational Databases – Relational Model – Keys – Relational Algebra – Relational Calculus – SQL Fundamentals – Advanced SQL features – Triggers -Embedded SQL.
Suggested Activities:
- Creating tables with key constraints, adding and removing constraints with referential integrity using DDL commands.
- Flipped classroom on relational algebra operations (selection, projection, joins etc.).
- Write SQL queries for demonstrating CRUD operations, aggregate functions and various join operations using DML commands.
- Create stored procedures for executing complex SQL transactions.
- Create triggers for alerting user/system while manipulating data.
Suggested Evaluation Methods:
- Tutorials on DDL, DML and DCL queries.
- Quizzes on relational algebra operations.
- Demonstration of created stored procedures and triggers.
Unit II
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
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.
Suggested Activities:
- Checking serializability among transactions.
- Flipped classroom on concurrency control protocols.
- Study of crash recovery algorithm (ARIES).
Suggested Evaluation Methods:
- Tutorials on serializability and crash recovery algorithm
- Quizzes on concurrency control protocols.
Unit IV
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Unit V
Advanced Topics
Overview of Distributed Databases – Data Fragmentation – Replication – XML Databases -XML Schema – NOSQL Database: Characteristics – CAP theorem – Types of NoSQL Datastores: Column Oriented, Document, Key-Value and Graph Types – Applications -Current Trends.
Suggested Student Activities:
- Design of distributed database using fragmentation.
- Creation of XML document based on XML schema.
- Creation of document and column oriented databases and simple manipulation.
Suggested Evaluation Methods:
- Tutorials on fragmenting database tables and writing simple SQL queries.
- Assignments on creation of XML schema and validating XML documents.
- Demonstration of created document and column-oriented databases.
Course Outcome:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Text Books:
- Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Sixth Edition, Tata McGraw Hill, 2014.
- Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2017.
References:
- C. J. Date, A. Kannan, S. Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.
- Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, Fourth Edition, Tata McGraw Hill, 2010.
- G. K. Gupta, “Database Management Systems”, Tata McGraw Hill, 2011.
- Carlos Coronel, Steven Morris, Peter Rob, “Database Systems: Design, Implementation and Management”, Ninth Edition, Cengage Learning, 2011.
For detailed syllabus of all other subjects of Information Technology, 2019 regulation curriculum do visit IT 3rd Sem subject syllabuses for 2019 regulation.
For all Information Technology results, visit Anna University IT all semester results direct link.