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