Introduction - Data Independence - The Three Levels Of Architecture - The External Level - Conceptual Level - Internal Level - Client/Server Architecture- System Structure , Instance and schema, Data Models, Types of DBMS
Keys - CODD’s Rules, Design Issues -ER – Model –Attribute types- Weak Entity Sets - Extended ER Features –ER to Relational Mapping, Structure Of Relational Databases
Normalization –Anomalies- Functional Dependency: Armstrong’s axioms- closure of a relation and closure of attribute– Lossless decomposition-1NF, 2NF, 3NF, Boyce - Codd Normal Form
The Relational Algebra -- Query Processing and Optimization: Evaluation of Relational algebra expressions-Query Equivalence-Transaction Processing: ACID properties, states of a transaction-Introduction to concurrency control-Deadlock-Recovery.
Built in SQL functions- Set operations, Sub Queries-Joins-DCL – TCL- Views – Sequences – Index – Locks PL/SQL Basics – Exceptions – Cursors - Stored Functions – Triggers