5 CS 3-DATABASE MANAGEMENT SYSTEMS |
Units: I |
INTRODUCTION TO DATABASE SYSTEMS: Overview and History of DBMS. File System vs 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.
|
|