Kambiz Saffarizadeh

Assistant Professor of Management at Marquette University

CIS3730 - Database Management Systems (MySQL)

Name:Kambiz Saffarizadeh
Office:Robinson College of Business, 35 Broad Street, 9th Floor, Room 910
Email:k.saffarizadeh@gmail.com | ksaffarizadeh1@gsu.edu
Office Hours:Tuesday 1:00 PM to 3:30 PM or by appointment
Time:Thursday 4:30 – 7:00 PM
Location:Aderhold Learning Center 202

Course Outline

Class Type / NumberDateTopicActivities before Class
Lecture 1Jan 11
  • Introduction
  • Getting familiar with MySQL Workbench Environment and Jupyter
  • The Relational Model
CanceledJan 18
  • Class was canceled due to inclement weather
Lecture 2Jan 25
  • Basic SQL
  • Single-table Queries
  • Read and practice Lecture_1.pptx
  • Install MySQL Server and MySQL Workbench on your machine and redo the activities from Lecture 1
Lecture 3Feb 1
  • Quiz 1
  • Multi-table Queries
  • Set Operators
  • Read and practice Lecture_2.pptx
  • Using MySQL try out all the SQL commands your learned
  • Submit Problem Set 1
Lecture 4Feb 8
  • Quiz 2, 3 (two sections)
  • Nested Queries
  • Aggregation & GROUP BY
  • Read and practice Lecture_3.pptx
Review 1Feb 15
  • Quiz 4
  • NULL Values & Outer Joins
  • Review & In-class Exercise
  • Read and practice Lecture_4.pptx
  • Submit Problem Set 2
Test 1Feb 22Test I Semester midpoint:  February 27
Lecture 5Mar 1
  • Create Database
  • Create/Alter/Delete Tables
  • Insert/Delete/Modify Tuples
  • The E/R Model Part I
  • Start looking for project teammates and a project topic
Lecture 6Mar 8
  • Quiz 5
  • The E/R Model Part II
  • Read and practice Lecture_5.pptx
  • Finalize your project team and topic
Spring BreakMar 15
  • Good time to review the course material!
  • Also have fun!
Lecture 7Mar 22
  • Quiz 6
  • Design Theory: Part I
  • Normal Forms and Functional Dependencies
  • Finding Functional Dependencies
  • Read and practice Lecture_6.pptx
Lecture 8Mar 29
  • Quiz 7
  • Design Theory: Part II
  • Boyce-Codd Normal Form (BCNF)
  • Multi-Value Dependencies (MVDs)
  • Decomposition
  • Read and practice Lecture_7.pptx
  • Submit Problem Set 3
Lecture 9Apr 5
  • Quiz 8
  • Transactions & Concurrency
  • Indexes
  • Views
  • Read and practice Lecture_8.pptx
  • Submit Problem Set 4
Lecture 10Apr 12
  • Quiz 9
  • Data Security
  • XML, JSON, NoSQL
  • Data Mining
  • Read and practice Lecture_9.pptx
Review 2Apr 19
  • Quiz 10
  • Review & Course Wrap-up
  • In-class Exercise
  • Read and practice Lecture_10.pptx
  • Submit the Class Project
Test 2Apr 26Test II
GradesMay 3
  • Final grades will be posted on PAWS on May 3 at 5PM.
  • The detailed grades will be made available on iCollege.