-
01: Introduction
-
Introduction to databases
-
Select statements
- 01: Introduction
-
-
02: Conceptual Database Design
-
Conceptual database design
-
Aggregate queries
- 02: Conceptual Design
-
-
03: Logical Database Design
-
Logical database design
-
Join queries
- 03: Logical Design
-
-
04: Enhanced ER diagrams
-
Enhanced ER Modelling
-
Multi-table and Outer Joins
- 04: Enhanced ER Diagrams
-
-
05: Normalisation
-
Normalisation
-
Data Manipulation
- 05: Normalisation 1
-
-
06: Advanced Normalisation
-
Normalisation example
-
Normalisation beyond 3NF
-
Data Definition
- 06: Normalisation 2
-
-
07: Physical Database Design
-
Conceptual and Logical recap
-
Physical database design
-
Subqueries and views
- 07: Physical Database Design
-
-
08: Security, Indexes and Triggers
-
Database Security
-
Indexes, Triggers, User and Privileges
- 08: Security, Indexes and Triggers
-
-
9: Database Concurrency
-
Transaction Management
-
MySQL Backup and Recovery
- 09: Database Concurrency
-
-
10: Backup and Recovery
-
Backup and Recovery
-
Installing MongoDB
- 10: Backup and Recovery
-
-
11: NoSQL 1
-
NoSQL Databases
-
MongoDB - Create
-
MongoDB - Read
- 11: NoSQL 1
-
-
12: NoSQL 2
-
Document-oriented modelling
-
MongoDB - Update
-
MongoDB - Delete
- 12: NoSQL 2
-
04: Enhanced ER Diagrams
Enhanced ER Modelling
Advanced ER Modelling

In this lecture you will learn about how to model and transform Weak Entity Types, Recursive Relationships, and Multivalued Attributes into a set of relations
Enhanced Entity-Relationship Modelling

In this lecture you will learn about how Semantic concepts are incorporated into the original ER model and called the Enhanced Entity-Relationship (EER) model.
Worked Example

Here we construct an Enhanced Entity Relationship (EER) Diagram for a given scenario and convert the EER diagram into a set of relations.