COMP 440: Database Design


Getting Help

  • Mahdi's email address: mahdi dot ebrahimi at csun dot edu
  • Mahdi's office hours:
    • Mondays: 10:45AM - 11:45AM via Zoom
    • Also available by appointment

Weekly Course Materials

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

Project Team Members

Team number Team member Demo Date
#1
  1. Jolean Wejbe
  2. Maya Zeng
  3. Vardan Torosyan
    TBA
#2
  1. Zyre Lagarile
  2. Marco Reyes
  3. Matthew Chalifoux
    TBA
#3
  1. Sason Abkarian
  2. Codi Yost
    TBA
#4
  1. Jacob Rush
    TBA
#5
  1. Hannah Alcantara
  2. Jacob Hagen
  3. Patrick Ishkhanyan
    TBA
#6
  1. Mitchell Berbera
  2. Lissett Laguna
  3. Edgar Chavez
    TBA
#7
  1. Hillard Staggs
  2. Alex Reyes
  3. Glen Roe
    TBA
#8
  1. Nate Will
  2. Joseph Held
    TBA
#9
  1. Evan Johnson
  2. Steven Herrera
  3. Jack Kouyoumdjian
    TBA
#10
  1. Brandon Hartman
    TBA