Course content is arranged by assignment:

Assignment 1 Key Topics: Creation of relational databases, primary and foreign keys, cascade constraint, and understanding of attribute formatting.

Assignment 2 Key Topics: Joins, Subqueries

Assignment 3 Key Topics: candidate keys, functional dependencies (partial and transitive), first normal form, third normal form, closures and subsets

Assignment 4 Key Topics: functional dependencies, third normal form, minimal cover, projections, dependency preservation, nonadditive joins

Assignment 5 Key Topics: PL/SQL (Loops, Cursors, Traversal), Adding Records to Tables, Triggers