Database Management Systems detailed syllabus for Electronics & Instrumentation Engineering (EIE) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the EIE 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 Electronics & Instrumentation Engineering 8th Sem scheme and its subjects, do visit EIE 8th Sem 2019 regulation scheme. For Professional Elective-VII scheme and its subjects refer to EIE Professional Elective-VII syllabus 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 the other subjects of Electronics & Instrumentation Engineering 8th Sem, visit EIE 8th Sem subject syllabuses for 2019 regulation.
For all Electronics & Instrumentation Engineering results, visit Anna University EIE all semester results direct link.