Database Management Detailed Syllabus for B.Tech second year second 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 (R16) second year second sem is as follows.
B.Tech. II Year II Sem. L/T/P/C
Course Code: CS402ES 4/0/0/4
Course Objectives:
- To understand the basic concepts and the applications of database systems.
- To master the basics of SQL and construct queries using SQL.
- To understand the relational database design principles.
- To become familiar with the basic issues of transaction processing and concurrency control.
- To become familiar with database storage structures and access techniques.
Course Outcomes:
- Demonstrate the basic elements of a relational database management system.
- Ability to identify the data models for relevant problems.
- Ability to design entity relationship model and convert entity relationship diagrams into RDBMS and formulate SQL queries on the data.
- Apply normalization for the development of application software.
UNIT – I Introduction: Database System Applications, Purpose of Database Systems, View of Data,
Database Languages – DDL, DML, Relational Databases, Database Design, Data Storage and Querying, Transaction Management, Database Architecture, Data Mining and Information Retrieval, Specialty Databases, Database Users and Administrators, History of Database Systems. Introduction to Data base design: Database Design and ER diagrams, Entities, Attributes and Entity sets, Relationships and Relationship sets, Additional features of ER Model, Conceptual Design with the ER Model, Conceptual Design for Large enterprises. Relational Model: Introduction to the Relational Model, Integrity Constraints over Relations, Enforcing Integrity constraints, Querying relational data, Logical data base Design: ER to Relational, Introduction to Views, Destroying /Altering Tables and Views.
UNIT – II Relational Algebra and Calculus: Preliminaries, Relational Algebra, Relational calculus – Tuple relational Calculus, Domain relational calculus, Expressive Power of Algebra and calculus. SQL: Queries, Constraints, Triggers: Form of Basic SQL Query, UNION,INTERSECT, and EXCEPT, Nested Queries, Aggregate Operators, NULL values Complex Integrity Constraints in SQL, Triggers and Active Data bases, Designing Active Databases..
UNIT – III Schema Refinement and Normal Forms: Introduction to Schema Refinement, Functional Dependencies-Reasoning about FDs,Normal Forms,Properties of Decompositions, Normalization, Schema Refinement in Database Design, Other Kinds of Dependencies.
TEXT BOOKS:
- Data base Management Systems, Raghu Ramakrishnan, Johannes Gehrke, McGraw Hill Education (India) Private Limited, 3rd Edition. (Part of UNIT-I, UNIT-II, UNIT-III, UNIT-V)
- Data base System Concepts, A. Silberschatz, Henry. F. Korth, S. Sudarshan, McGraw Hill Education(India) Private Limited l, 6th edition.( Part of UNIT-I, UNIT-IV)
REFERENCE BOOKS:
- Database Systems, 6th edition, R Elmasri, Shamkant B.Navathe, Pearson Education.
- Database System Concepts, Peter Rob & Carlos Coronel, Cengage Learning.
- Introduction to Database Management, M. L. Gillenson and others, Wiley Student Edition.
- Database Development and Management, Lee Chao, Auerbach publications, Taylor & Francis Group. Introduction to Database Systems, C. J. Date, Pearson Education.
For all other B.Tech 2nd Year 2nd Sem syllabus go to JNTUH B.Tech Computer Science and Engineering 2nd Year 2nd Sem Course Structure for (R16) 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.