Database Management Systems Ind Engg & Mang 5th Sem Syllabus for BE 2017 Regulation Anna Univ (Open Elective I) detail syllabus for Industrial Engineering & Management (Ind Engg & Mang), 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 ind engg & mang 5th sem syllabus for be 2017 regulation anna univ you can visit Ind Engg & Mang 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 Ind Engg & Mang, 2017 regulation do visit Ind Engg & Mang 5th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.