Database Management Systems Syllabus for B.Tech Third sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.
The detailed syllabus for Database Management Systems B.Tech 2016-2017 (R13) thirdsem is as follows
OBJECTIVES
- To expose the students to the fundamentals of Database Management Systems.
- To make the students understand the relational model.
- To familiarize the students with ER diagrams.
- To expose the students to SQL.
- To make the students to understand the fundamentals of Transaction Processing and Query Processing.
- To familiarize the students with the different types of databases.
- To make the students understand the Security Issues in Databases.
UNIT I INTRODUCTION TO DBMS [10 hours]
File Systems Organization – Sequential, Pointer, Indexed, Direct – Purpose of Database System- Database System Terminologies-Database characteristics- Data models – Types of data models – Components of DBMS- Relational Algebra. LOGICAL DATABASE DESIGN: Relational DBMS – Codd’s Rule – Entity-Relationship model – Extended ER Normalization – Functional Dependencies, Anomaly- 1NF to 5NF- Domain Key Normal Form – Denormalization.
UNIT II SQL & QUERY OPTIMIZATION [8 hours]
SQL Standards – Data types – Database Objects- DDL-DML-DCL-TCL-Embedded SQL-Static Vs Dynamic SQL – QUERY OPTIMIZATION: Query Processing and Optimization – Heuristics and Cost Estimates in Query Optimization.
UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL [8 hours]
Introduction-Properties of Transaction- Serializability- Concurrency Control – Locking Mechanisms- Two Phase Commit Protocol-Dead lock.
Download iStudy Android App for complete Anna University syllabus, results, timetables and all other updates. There are no ads and no pdfs and will make your life way easier.
[TOTAL: 45 PERIODS]
OUTCOMES: At the end of the course, the student should be able to:
- Design Databases for applications.
- Use the Relational model, ER diagrams.
- Apply concurrency control and recovery mechanisms for practical problems.
- Design the Query Processor and Transaction Processor.
- Apply security concepts to databases.
TEXT BOOK:
- Ramez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”, Fifth Edition, Pearson Education, 2008.
REFERENCES:
- Abraham Silberschatz, Henry F. Korth and S. Sudharshan, “Database System Concepts”, Sixth Edition, Tata McGraw Hill, 2011.
- C.J.Date, A.Kannan and S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.
- Atul Kahate, “Introduction to Database Management Systems”, Pearson Education, New Delhi, 2006.
- Alexis Leon and Mathews Leon, “Database Management Systems”, Vikas Publishing House Private Limited, New Delhi,
- Raghu Ramakrishnan, “Database Management Systems”, Fourth Edition, Tata McGraw Hill, 2010.
- G.K.Gupta,”Database Management Systems”, Tata McGraw Hill, 2011.
- Rob Cornell, “Database Systems Design and Implementation”, Cengage Learning, 2011.
For all other B.Tech IT 3rd sem syllabus go to Anna University B.Tech Information Technology (IT) 3rd Sem Course Structure for (R13) Batch. All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.
Do share with friends and in case of questions please feel free drop a comment.