JNTUH B.Tech 2nd year (2-2) Database Management Systems gives you detail information of Database Management Systems R13 syllabus It will be help full to understand you complete curriculum of the year.<\/p>\n
Objectives<\/strong><\/p>\n UNIT-I<\/strong><\/p>\n Introduction <\/strong>Database System Applications, Purpose of Database Systems, View of Data – Data Abstraction, Instances and Schemas, Data Models, Database Languages – DDL, DML, Database Architecture, Database Users and Adminnistrators, History of Data base Systems.<\/p>\n Introduction to Data base design , ER diagrams, Beyond ER Design, Entities, Attributes nd 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, Introduction to Views Destroying\/ altering Tables and Views.<\/p>\n UNIT-II<\/strong><\/p>\n Relational Algebra and Calculus<\/strong>\u00a0Relational Algebra – Selection and Projection, Set operations, Renaming, Joins, Division, Examples of Algebra Queries, Relational calculus – Tuple relational Calculus – Domain relational calculus – Expressive Power of Algebra and calculus.<\/p>\n Form of Basic SQL Query – Examples of Basic SQL Queries, Introduction to Nested Queries, Correlated Nested Queries, Set – Comparison Operators, Aggregate Operators, NULL values – Comparison using Null values – Logical connectives – AND, OR and NOT – Impact on SQL Constructs, Outer Joins, Disallowing NULL values, Complex Integrity Constraints in SQL Triggers and Active Data bases.<\/p>\n UNIT-III<\/strong><\/p>\n Introduction to Schema Refinement<\/strong> – Problems Caused by redundancy, Decompositions – Problem related to decomposition, Functional Dependencies – Reasoning about FDS, Normal Forms – FIRST, SECOND, THIRD Normal forms – BCNF – Properties of Decompositions – Loss less join Decomposition, Dependency preserving Decomposition, Schema Refinement in Data base Design – Multi valued Dependencies – FOURTH Normal Form, Join Dependencies, FIFTH Normal form, Inclusion Dependencies.<\/p>\n\n