Database Management Systems detailed syllabus for Automobile Engineering (Auto) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the Auto 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 Automobile Engineering 6th Sem scheme and its subjects, do visit Auto 6th Sem 2019 regulation scheme. For Open Elective-I scheme and its subjects refer to Auto Open Elective-I 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
Dbms and Conceptual Data Modeling
Purpose of Database System – Data independence – Data Models – Database System Architecture – Conceptual Data modeling: ER models – Enhanced-ER Model. Introduction to relational databases – Relational Model – Keys – ER-to-Relational Mapping. Modeling of a library management system.
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
Database Programming
Database programming with function calls, stored procedures – views – triggers. Embedded SQL. ODBC connectivity with front end tools. Implementation using ODBC/JDBC and SQL/PSM, implementing functions, views, and triggers in MySQL / Oracle.
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
Database security issues – Discretionary access control – role based access – Encryption and public key infrastructures – challenges. Information Retrieval: IR Concepts, Retrieval Models, Queries in IR systems.
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:
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Sixth Edition , Pearson, 2011.
- Abraham Silberschatz, Henry F. Korth, S. Sudharshan, Database System Concepts, Sixth Edition, Tata McGraw Hill, 2011
References:
- C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.
- Raghu Ramakrishnan, Database Management Systemsll, Fourth Edition, McGraw-Hill College Publications, 2015.
For detailed syllabus of all the other subjects of Automobile Engineering 6th Sem, visit Auto 6th Sem subject syllabuses for 2019 regulation.
For all Automobile Engineering results, visit Anna University Auto all semester results direct link.