Zeinalipour > Courses > EPL342 > Schedule

Schedule »

Week Content PDF
W01 Introduction I: Syllabus & Introduction to Databases »
01
syllabus
  Introduction II: Database Users and Database System Concepts and Architecture »
02
W02 Introduction III: Database System Concepts and Architecture »
03
  Entity-Relationship Model I: Data Modeling Using the Entity-Relationship (ER) Model »
04
W03 Entity-Relationship Model II: Data Modeling Using the Entity-Relationship (ER) Model »
05
  Entity-Relationship Model III: ER + The Enhanced Entity-Relationship (EER) Model »
Assignment 1 (Entity-Relationship Model) Announced
06
W04 Relational Model I »
07
  Relational Model II + Relational Algebra I »
Assignment 1 (Entity-Relationship Model) Due
Project Phase 1 (Entity-Relationship & Relational Model) Announcement (in Laboratory)
08
W05 Relational Algebra II »
09
W06 Relational Algebra III »
Assignment 2 (Relational Model & Relational Algebra) Announced
10
  ER-to-Relational Mapping »
11
W07 SQL-DDL I: Introduction to SQL-DDL Data Types »
Project Phase 1 (Entity-Relationship & Relational Model) Due (in Laboratory)
Project Phase 2 (Implementation) Begins (in Laboratory)
12
  SQL-DDL II »
13
W08 SQL-DML I »
Assignment 2 (Relational Model & Relational Algebra) Due
14
  MIDTERM Exam: Check Lecture 1 for exact date.

This is a closed book exam: no books, notebooks, notes, etc.
-
W09 SQL-DML II »
15
  SQL-DML III »
16
W10 SQL-DML IV »
Assignment 3 (Structured Query Language (SQL)) Announced
17
  Advanced SQL: Internal Database Programming »
18
W11 Advanced SQL: Internal Database Programming »
Assignment 3 (Structured Query Language (SQL)) Due
19
  Advanced SQL: External Database Programming »
20
W12 Functional Dependencies and Normalization I »
21
  Functional Dependencies and Normalization II »
22
W13 Functional Dependencies and Normalization III »
Assignment 4 (Functional Dependencies and Normal Forms) Announced
23
  Functional Dependencies and Normalization IV »
Project Phase 2 (Implementation) Due (in Laboratory)
24
Exams FINAL Exam
This is a closed book exam: no books, notebooks, notes, etc. allowed
-