COMP 440: Database Design

Resources

Getting Help

  • Mahdi's email address: mahdi dot ebrahimi at csun dot edu
  • Mahdi's office hours:
    • Monday/Wednesday: 11:50AM - 12:30PM via Zoom (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-1 Introduction to SQL - Part 1 [slides]
[video1] , [video2] , [video3] 		Chapter 3
Reference Book Database
2-2 Introduction to SQL - Part 2 [Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] 		Chapter 3
2-3 SQL Practice - Part 1
2-4 Database Design - ER Diagram [slides]
ER Case Study 		Chapter 6
3-1 Transfer ER to Relational Schema [slides] Chapter 6
3-2 Intermediate SQL - Part 1 [slides]
[video1] , [video2] , [video3] , [video4] , [video5] 		Chapter 4
4-1 Intermediate SQL - Part 2 [Slides from previous week used] Chapter 4
4-2 SQL Practice - Part 2
4-3 Advanced SQL [slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] 		Chapter 5
5-1 Midterm Exam Review Exam Review (Chapters 1,3,4,5) Midterm Exam on Mon, 08/07 at 12:30 PM via Canvas
5-2 Relational Algebra [slides]
[video1] , [video2] 		Chapter 2
6 Database Design: Normalization [slides]
Normalization Example 		Chapter 7
7 Final Exam Review Final Exam Review (Chapters 2, 6, 7) Final Exam on Tuesday, 08/22 at 12:30 PM via Canvas

Project Team Members

Team number Team member Demo Date
#1 1.Andres Esparza, 2.Prissila Fabian, 3.Shihao Yu Thursday, 8/17 after lecture
#2 1.Brian Kaddu, 2.Carlos Solorzano, 3.Raymond Gharapeti Babayans Thursday, 8/17 at 2:00 PM
#3 1.Manpreet Dhindsa, 2.Eric Lorback, 3.Brian Kelly Thursday, 8/17 at 12:00 PM
#4 1.Christopher Olivo, 2.Ryan Bosdet, 3.Hampig Kodjanian Monday, 8/21 at 3:00 PM
#5 1.Samuel Hernandez, 2.Hannah Xie, 3.Grant Freedman Monday, 8/21 at 12:30 PM
#6 1.Jean Hanna, 2.Gabriel Sosa, 3.Jacob Yousif Monday, 8/21 at 1:00 PM
#7 1.Jesse Cruz, 2.Alfredo Gonzalez, 3.Omar Garcia Monday, 8/21 at 12:00 PM
#8 1.Sevada Ghazaryan, 2.Christian Jaime, 3.Melchor Abalos Friday, 8/18 at 2:30 PM
#9 1.Luis Hernandez Monday, 8/21 at 1:30 PM
#10 1.Ricardo Santana, 2.Anthony Merzoian Monday, 8/21 at 3:30 PM
#11 1.Hyeong Woo Ko Tuesday, 8/15 after lecture
#12 1.Alma Dollente Monday, 8/21 at 2:00 PM