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