Database Management Systems Mechatronics 8th Sem Syllabus for BE 2017 Regulation Anna Univ (Professional Elective V) detail syllabus for Mechatronics Engineering (Mechatronics), 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 (CS8492), Category (PE), Contact Periods/week (3), Teaching hours/week (3), Practical Hours/week (0). The total course credits are given in combined syllabus.
For all other mechatronics 8th sem syllabus for be 2017 regulation anna univ you can visit Mechatronics 8th Sem syllabus for BE 2017 regulation Anna Univ Subjects. For all other Professional Elective V subjects do refer to Professional Elective V. The detail syllabus for database management systems is as follows.
Course Objective:
- To learn the fundamentals of data models and to represent a database system using ER diagrams.
- To study SQL and relational database design.
- To understand the internal storage structures using different file and indexing techniques which will help in physical DB design.
- To understand the fundamental concepts of transaction processing- concurrency control techniques and recovery procedures.
- To have an introductory knowledge about the Storage and Query processing 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 Design
Entity-Relationship model – E-R Diagrams – Enhanced-ER Model – ER-to-Relational Mapping -Functional Dependencies – Non-loss Decomposition – First, Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form
Unit III
Transactions
Transaction Concepts – ACID Properties – Schedules – Serializability – Concurrency Control – Need for Concurrency – Locking Protocols – Two Phase Locking – Deadlock – Transaction Recovery -Save Points – Isolation Levels – SQL Facilities for Concurrency and Recovery.
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
Distributed Databases: Architecture, Data Storage, Transaction Processing – Object-based Databases: Object Database Concepts, Object-Relational features, ODMG Object Model, ODL, OQL -XML Databases: XML Hierarchical Model, DTD, XML Schema, XQuery – Information Retrieval: IR Concepts, Retrieval Models, Queries in IR systems.
Course Outcome:
Upon completion of the course, the students will be able to:
- Classify the modern and futuristic database applications based on size and complexity
- Map ER model to Relational model to perform database design effectively
- Write queries using normalization criteria and optimize queries
- Compare and contrast various indexing strategies in different database systems
- Appraise how advanced databases differ from traditional databases.
Text Books:
- Abraham Silberschatz, Henry F. Korth, S. Sudharshan, Database System Concepts, Sixth Edition, Tata McGraw Hill, 2011.
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Sixth Edition, Pearson Education, 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.
- G.K.Gupta,Database Management Systems, Tata McGraw Hill, 2011.
For detail syllabus of all other subjects of BE Mechatronics, 2017 regulation do visit Mechatronics 8th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.