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