COMP 440: Database Design

Resources

Getting Help

  • Mahdi's email address: mahdi dot ebrahimi at csun dot edu
  • Mahdi's office hours:
    • MoTuWe: 11AM - 12PM 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
3-1 Intermediate SQL - Part 1 [slides]
[video1] , [video2] , [video3] , [video4] , [video5] 		Chapter 4
3-2 Advanced SQL [slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] 		Chapter 5
3-3 SQL Practice - Part 2
3-4 Relational Algebra [slides]
[video1] , [video2] 		Chapter 2
4 Exam 1 Review Exam Review (Chapters 1-5) Exam 1 on Monday, 8/10/2026 at 9:00 AM via Canvas
5-1 Database Design - ER Diagram [slides]
ER Case Study 		Chapter 6
5-2 Transfer ER to Relational Schema [slides] Chapter 6
6-1 Database Design: Normalization [slides]
Normalization Example 		Chapter 7
6-2 Exam 2 Review Exam 2 Review (Chapters 6 and 7) Exam 2 on Tuesday, 8/18 at 9:00 AM via Canvas

Project Team Members

Team numberTeam memberDemo Date
#1 1.Narek Sarkiskian shahbolaghi, 2.Liam Binell, 3.Jonathan Aghachi Tuesday, 8/18 @ 1:30PM
#2 1.Naveed Shirzadi, 2.Martha Alejandra Salmeron Pinto, 3.Salmeron Pinto Monday, 8/17 @ 2PM
#3 1.Juan Aguilar, 2.Andrei Keanan David Monday, 8/17 @ 3PM
#4 1.Leo Aghazaryan Monday, 8/17 @ 5:30PM
#5 1.Erendira Miranda, 2.Aleksandar Hristov TBD
#6 1.Anthony Langer, 2.Mohammed Shariff Tuesday, 8/18 @ 2:30PM
#7 1.Carlos Bautista, 2.Bachviet Nguyen, 3.Hirbod Jabbarnezhad Monday, 8/17 @ 5PM
#8 1.Eddy Moussa, 2.Carlos Diaz, 3.Winter Tomas Monday, 8/17 @ 2:30PM
#9 1.Luca Anna, 2.Erik Ghazaryan, 3.Ivan Juarez Tuesday, 8/18 @ 3:30PM
#10 1.Rajvir Singh Tuesday, 8/18 @ 10:15AM
#11 1.Vahe Tovmasian, 2.Astghik Ghazaryan Tuesday, 8/18 @ 11AM
#12 1.Alberto Gonzalez, 2.Moe Nasir, 3.Jalal Swati Monday, 8/17 @ 4PM