ECE

OIT551: Database Management Systems Syllabus for ECE 6th Sem 2019 Regulation Anna University (Open Elective-I)

Database Management Systems detailed syllabus for Electronics & Communication Engineering (ECE) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the ECE 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 & Communication Engineering 6th Sem scheme and its subjects, do visit ECE 6th Sem 2019 regulation scheme. For Open Elective-I scheme and its subjects refer to ECE Open Elective-I syllabus scheme. The detailed syllabus of database management systems is as follows.

Database Management Systems

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.
Get it on Google Play.

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.
Get it on Google Play.

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.
Get it on Google Play.

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.
Get it on Google Play.

Text Books:

  1. Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Sixth Edition , Pearson, 2011.
  2. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, Database System Concepts, Sixth Edition, Tata McGraw Hill, 2011

References:

  1. C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.
  2. Raghu Ramakrishnan, Database Management Systemsll, Fourth Edition, McGraw-Hill College Publications, 2015.

For detailed syllabus of all the other subjects of Electronics & Communication Engineering 6th Sem, visit ECE 6th Sem subject syllabuses for 2019 regulation.

For all Electronics & Communication Engineering results, visit Anna University ECE all semester results direct link.

Leave a Reply

Your email address will not be published. Required fields are marked *

*