Database Management Systems Med Ele 5th Sem Syllabus for BE 2017 Regulation Anna Univ (Open Elective I) detail syllabus for Medical Electronics (Med Ele), 2017 regulation is collected from the Anna Univ official website and presented for students of Anna University. The details of the course are: course code (OIT551), Category (OE), Contact Periods/week (3), Teaching hours/week (3), Practical Hours/week (0). The total course credits are given in combined syllabus.
For all other med ele 5th sem syllabus for be 2017 regulation anna univ you can visit Med Ele 5th Sem syllabus for BE 2017 regulation Anna Univ Subjects. For all other Open Elective I subjects do refer to Open Elective I. The detail syllabus for database management systems is as follows.
Course Objective:
- To learn the fundamentals of data models
- To learn conceptual modeling using ER diagrams.
- To study SQL queries and database programming
- To learn proper designing of relational database.
- To understand database security concepts
- To understand Information retrieval techniques
Unit I
For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Unit II
Database Querying
Relational Algebra – SQL: fundamentals – DDL – Specifying integrity constraints – DML – Basic retrieval queries in SQL – Complex SQL retrieval queries – nested queries – correlated queries – joins – aggregate functions. Creating a table, populating data, adding integrity constraints, querying tables with simple and complex queries.
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 complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life 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:
Upon completion of the course, the students will be able to:
- Understand relational data model, evolve conceptual model of a given problem, its mapping to relational model and Normalization
- Query the relational database and write programs with database connectivity
- Understand the concepts of database security and information retrieval systems
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 detail syllabus of all other subjects of BE Med Ele, 2017 regulation do visit Med Ele 5th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.