Data Mining Module 2: Relational Database Design

Lecture 2.1 Relational Database Design

Lecture 2.2 Normalization Rules

Lecture 2.3 Types of Relationships

Lecture 2.4 Entity–Relationship (ER) Model

Lab 2: Use ER Diagrams to Design Relational Databases

Objectives:

  • To learn how to create ER diagrams

  • Design relational databases with ER diagrams

Data:

  • None