آموزش طراحی پایگاه داده رابطه‌ای - آخرین آپدیت

Module 1: Design Overview Module 1: Design Overview

• Instructor Welcome and Course Introduction Instructor Welcome and Course Introduction

• Entity Relationship (ER) Model Entity - Relationship (ER) Model

• Creating an Entity Relationship Diagram (ERD) Creating an Entity - Relationship Diagram (ERD)

• Extended ER Model/Diagram Extended ER Model/Diagram

Module 2: Functional Dependency (FD) Module 2: Functional Dependency (FD)

• Functional Dependency (FD) Functional Dependency (FD)

• Attribute Closure and Candidate Keys Attribute Closure and Candidate Keys

• Canonical (minimal) cover off FDs Canonical (minimal) cover off FDs

Module 3: Database Normalization Module 3: Database Normalization

• Database Normalization Database Normalization

• Boyce Codd Normal Form Boyce-Codd Normal Form

• Database Design Example (Normalization +ERD) Database Design Example (Normalization + ERD)

Summative Course Assessment Summative Course Assessment