COMP 440: Database Design


Getting Help

  • Mahdi's email address: mahdi dot ebrahimi at csun dot edu
  • Mahdi's office hours:
    • Fridays: 1:15PM - 2:00PM via Zoom
    • Also available by appointment

Weekly Course Materials

Week Topic Course Materials Note
1-1 Course Overview [syllabus]
1-2 Introduction to Database [slides]
[video1] , [video2] , [video3]
Chapter 1
2 Introduction to SQL - Part 1 [slides]
[video1] , [video2] , [video3]
Chapter 3
Reference Book Database
3 and 4 Introduction to SQL - Part 2 [Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6]
Chapter 3
5 SQL Practice - Part 1
6 Intermediate SQL [slides]
[video1] , [video2] , [video3] , [video4] , [video5]
Chapter 4
7-1 Advanced SQL [slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6]
Chapter 5
7-2 SQL Practice - Part 2
8-9 Exam 1 Review Exam Review (Chapters 1, 3, 4) Exam 1 on Fri, 3/29 at 11:30 AM via Canvas
(Section 1: 11:30 AM - 12:45 PM)
10 - 11 Database Design - ER Diagram [slides]
ER Case Study
Chapter 6
12 Transfer ER to Relational Schema [slides] Chapter 6
13-14 Database Design: Normalization [slides]
Normalization Example
Chapter 7
15 Exam 2 Review Exam Review (Chapters 6 - 7) Exam 2 (online) on Fri, 05/10 at class time via Canvas
(Section 1: 11:30 AM - 1:15 PM)

Project Team Members

Team number Team member Demo Date
#1 1.Edwin Rivera, 2.Itzel Castaneda, 3.Zori badkerhanian Tue, 5/7 @ 12:00 PM
#2 1.David Helmi, 2.Aryaman Mehta, 3.Jorge Torrez Tue, 4/30 @ 2:30 PM
#3 1.Shelby Gallegos, 2.Daniel Barlam, 3.Rishabh Chadha Wed, 5/8 @ 1:30 PM
#4 1.Justin Reyes, 2.Kobi Sherman, 3.Neville Elieh Janvisloo Wed, 5/8 @ 3:00 PM
#5 1.Michael Buchinskiy, 2.Alek Ovsepyan, 3.Ahmad Satarzai Wed, 5/8 at 2:15 PM
#6 1.Jonathan Williams, 2.Justin Lee Fri, 5/10 @ 1:15 PM
#7 1.Christian Walsh, 2.Michael Green, 3.Richard Caldera Wed, 5/8 at 12:45 PM
#8 1.Raneen Kakar, 2.Shima Jabbari, 3.Ali Kiani Fri, 5/10 @ 12:40 PM
#9 1.Summer (Kyungwon) Shin, 2.Adrian Vergara Thu, 5/9 @ 5:00 PM
#10 1.Garrette Clarke, 2.Joseph Valdez, 3.Elijah Lockett Fri, 5/10 @ 3:00 PM