COMP 440: Database Design

Resources

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]
[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 Exam Review (Chapters 1 - 3 and Chapter 6) Midterm Exam on Wed, 11/02 at class time via Canvas
(09:30 AM - 10:45 AM)
10 Transfer ER to Relational Schema [slides] 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
15 Database Design: Normalization - Part 1 [slides] Chapter 7
16 Database Design: Normalization - Part 2 [slides]
Normalization Example 		Chapter 7
16 Final Exam Review Exam Review (Chapters 4 - 7) Final Exam on Wed, 12/14 at 8:00 AM via Canvas

Project Team Members

Team number Team member Demo Date
#1
  1. Jolean Wejbe
  2. Maya Zeng
  3. Vardan Torosyan
    Wed, 11/30/2022 @ 9:00 AM
#2
  1. Zyre Lagarile
  2. Marco Reyes
  3. Matthew Chalifoux
    Sat, 12/10/2022 @ 9:00 AM
#3
  1. Sason Abkarian
  2. Codi Yost
    Fri, 12/09/2022 @ 2:00 PM
#4
  1. Jacob Rush
    Fri, 12/09/2022 @ 12:00 PM
#5
  1. Hannah Alcantara
  2. Jacob Hagen
  3. Patrick Ishkhanyan
    Mon, 12/05/2022 @ 8:45 AM
#6
  1. Mitchell Berbera
  2. Lissett Laguna
  3. Edgar Chavez
    Thu, 12/08/2022 @ 1:30 PM
#7
  1. Hillard Staggs
  2. Alex Reyes
  3. Glen Roe
    Wed, 11/30/2022 @ 8:15 AM
#8
  1. Nathan Will
  2. Joseph Held
    Mon, 12/12/2022 @ 10:00 AM
#9
  1. Evan Johnson
  2. Steven Herrera
  3. Jack Kouyoumdjian
    Wed, 12/7/2022 @ 11 AM
#10
  1. Brandon Hartman
    Thu, 12/08/2022 @ 12:15 PM
#11
  1. Hyeong Woo Ko
  2. Craig Edmondson
    TBA
#12
  1. Anthony Schanen
    Fri, 12/09/2022 @ 8:00 AM
#13
  1. Yazn Sarah
    Sat, 12/10/2022 @ 9:30 AM