Database Management Systems detail syllabus for Mech & Auto (Mech & Auto), 2017 regulation is taken from Anna University official website and presented for students of Anna University. The details of the course are: course code (CS8492), Category (ES), Contact Periods/week (3), Teaching hours/week (3), Practical Hours/week (0). The total course credits are given in combined syllabus.
For all other mech & auto 5th sem syllabus for be 2017 regulation anna univ you can visit Mech & Auto 5th Sem syllabus for BE 2017 regulation Anna Univ Subjects. 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 Mech & Auto, 2017 regulation do visit Mech & Auto 5th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.