4- Course Content :-

1- Basic Concepts Review: DBMS definitions and terminologies; DBMS architecture; Relational DBMS model.

2- The Relational Model Review: Relational Data Objects; Relational Algebra; Relational Calculus; SQL and ORACLE DBMS.

3- DATABASE DESIGN: Fundamental Dependencies; Further Normalization I: 1NF, 2NF, 3NF, BCNF.

4- DATABASE DESIGN: Further Normalization II: Higher Normal Forms; and The Entity/Relationship Model.

5- DATA PROTECTION: Recovery; and Concurrency.

6- DATA PROTECTION: Security; and Integrity.

7- FURTHER TOPICS: Views; Optimization; Domain, Relations, and Data Types; and Missing Information.

8- OBJECT ORIENTED SYSTEMS: Basic OO Concepts & A Gradle-to-Grave Example.

9- OBJECT ORIENTED SYSTEMS: Toward an OO/Relational Rapprochements.

10- FURTHER TOPICS: Distributed Database and Client/Server Systems.

11- Web databases and NoSQL.