COMP 440: Database Design


Getting Help

  • Mahdi's email address: mahdi dot ebrahimi at csun dot edu
  • Mahdi's office hours:
    • Monday/Wednesday: 10:35AM - 11:00AM 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-1 Exam 1 Review Exam Review (Chapters 1-5) Exam 1 on Thursday, 08/08 at 11:00 AM via Canvas
4-2 Database Design - ER Diagram [slides]
ER Case Study
Chapter 6
5-1 Transfer ER to Relational Schema [slides] Chapter 6
5-2 Database Design: Normalization [slides]
Normalization Example
Chapter 7
6 Exam 2 Review Exam 2 Review (Chapters 6, 7) Exam 2 on Tuesday, 08/20 at 11:00 AM via Canvas

Project Team Members

Team numberTeam memberDemo Date
#1 1.Jacob Spier, 2.Gerardo Anthony Marioni, 3.Abigail Rosas Monday, 8/19/2024 at 11:00 AM
#2 1.Alejandro Ortega, 2.Vanessa Juarez, 3.Christopher Lagos Monday, 8/19/2024 at 12:00 PM
#3 1.Mirta Mazariego Tuesday, 8/20/2024 at 10:00 AM
#4 1.Ali Maamoun, 2.Jittapatana (Patrick) Prayunpruk, 3.Cailin Jefferson, 4.Adrian Carreno Thursday, 8/15/2024 at 12:30 PM
#5 1.Narek Asaturyan, 2.Adrian Leon, 3.Lilianna Rosales Tuesday, 8/20/2024 at 10:30 AM
#6 1.Ashot Gharibyan, 2.Mohammed I Hussain, 3.Timothy Tracy Friday, 8/16/2024 at 10:30 AM
#7 1.Vinicius Bosque, 2.Federico Bailaque, 3.Daniel Barlam Monday, 8/19/2024 at 11:30 AM
#8 1.Miguel Datoc Sunday, 8/18/2024 at 9:00 AM
#9 1.Zaid Alabwaini, 2.Amgad Fahim, 3.Christian Javalios Tuesday, 8/20/2024 at 12:00 PM
#10 1.Arash Asadi, 2.Mitra Farsi Tuesday, 8/20/2024 at 10:30 PM
#11 1.Edward Orlov, 2.Rucha Kothikar, 3.Pragya Sangwan Sunday, 8/18/2024 at 10:00 AM
#12 1.Chance Chime Tuesday, 8/20/2024 at 12:30 PM