RDBMS-Relational Database Management System

Introduction to DBMS– Data and Information -Database – Database Management System – Objectives- Advantages – Components - Architecture. ER Model: Building blocks of ER
Diagram –Relationship Degree – Classification – ER diagram to Tables – ISA relationship – Constraints – Aggregation and Composition – Advantages.

Relational Model: CODD’s Rule- Relational Data Model - Key - Integrity – Relational Algebra Operations – Advantages and limitations – Relational Calculus – Domain Relational Calculus -QBE.

Structure of Relational Database. Introduction to Relational Database Design - Objectives – Tools – Redundancy and Data Anomaly – Functional Dependency - Normalization – 1NF – 2NF – 3NF – BCNF. Transaction Processing – Database Security.

Introduction to SQL: Data Definition Commands – Data Manipulation Commands – SELECT Queries – Additional Data Definition Commands – Additional SELECT Query Keywords – Joining Database Tables. Advanced SQL: Relational SET Operators: UNION – UNION ALL – INTERSECT - MINUS.SQL Join Operators: Cross Join – Natural Join – Join USING Clause – JOIN ON Clause –Outer Join.

Sub Queries and Correlated Queries: WHERE – IN – HAVING – ANY and ALL – FROM. SQL Functions: Date and Time Function – Numeric Function – String Function – Conversion Function
PL/SQL: Structure - Elements – Operators Precedence – Control Structure – Iterative Control - Cursors - Procedure - Function - Packages – Exceptional Handling - Triggers.