Database Management Systems Detailed Syllabus for B.Tech third year first 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) third year first sem is as follows.
B.Tech. III Year I Sem. L/T/P/C
Course Code: CS512OE 3/0/0/3
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, Taylorm& Francis Group.
- Introduction to Database Systems, C. J. Date, Pearson Education
For all other B.Tech 3rd Year 1st Sem syllabus go to JNTUH B.Tech Computer Science and Engineering 3rd Year 1st 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.