5 IT 3-DATABASE MANAGEMENT SYSTEMS |
Units: I |
INTRODUCTION TO DATABASE SYSTEMS: Overview and History of DBMS.
File System v/s DBMS .Advantage of DBMS Describing and Storing Data in a
DBMS. Queries in DBMS. Transaction management and Structure of a DBMS.
|
Units: II |
ENTITY RELATIONSHIP MODEL: Overview of Data Design Entities, Attributes
and Entity Sets, Relationship and Relationship Sets. Features of the ER Model-
Key Constraints, Participation Constraints, Weak Entities, Class Hierarchies,
Aggregation, Conceptual Data Base, Design with ER Model-Entity vs Attribute,
Entity vs Relationship Binary vs Ternary Relationship and Aggregation vs ternary
Relationship Conceptual Design for a Large Enterprise. |
Units: III |
RELATIONSHIP ALGEBRA AND CALCULUS: Relationship Algebra
Selection and Projection, Set Operations, Renaming, Joints, Division,
Relation Calculus, Expressive Power of Algebra and Calculus.
|
Units: IV |
SQL QUERIES PROGRAMMING AND TRIGGERS: The Forms of a Basic SQL
Query, Union, Intersection and Except, Nested Queries ,Correlated Nested
Queries, Set-Comparison Operations, Aggregate Operators, Null Values and
Embedded SQL, Dynamic SQL, ODBC and JDBC, Triggers and Active
Databases.
|
Units: V |
SCHEMA REFINEMENT AND NORMAL FORMS: Introductions to Schema
Refinement, Functional Dependencies, Boyce-Codd Normal Forms, Third Normal
Form, Normalization-Decomposition into BCNF Decomposition into 3-NF.
|
|