Database Engineering

Introduction to Database Systems and its Applications Database System Architecture Data Abstraction Data Independence Data Models – Network Hierarchical and Relational Data Models – Relational and Object-Oriented Data Models Entity Relationship (ER) Model Mapping ER Relational Model Data Definitions Languages Data Manipulation Integrity Constraints and Data Manipulation Operations. Relation Query Language Fundamental Relation Algebra Operations Extended Relation Algebra Operations Tuple and Domain Relational Calculus SQL QBE Domain and Data Dependency Armstrong’s Axioms Dependency Preservation Lossless Design Normal Forms – 1NF 2NF 3NF BCNF Higher Normal Forms – 4NF 5NF Comparison of Oracle and DB2.