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.