Kambiz Saffari (Saffarizadeh) > Courses > CIS3730 > Database Management Systems (MySQL) – Fall 2019

CIS3730: Database Management Systems (MySQL)

Schedule and Syllabus

This is the syllabus for the Fall 2019 iteration of the course.

table {
font-family: ‘Roboto’, sans-serif;
font-weight: 300;
padding: 0;
margin: 0;
font-size: 16px;
color: #333;
}

table a {
color: #428bca;
text-decoration: none;
}

Week Date Description Notes
1 Aug 27 Introduction

The Relational Model

Setting up Google Cloud and MySQL Workbench
2 Sep 3 Basic SQL

Single-table Queries
3 Sep 10 Multi-table Queries Submit Problem Set 1
4 Sep 17 Set Operators and Nested Queries Quiz 1
5 Sep 24 Data Aggregation
6 Oct 1 Create/Drop Database

Create/Alter/Drop Tables

Insert/Delete/Update Tuples

 Submit Problem Set 2
7 Oct 8 In-class Exercise (Comprehensive Examples) Quiz 2
8 Oct 15 Exam Review

Semester midpoint:  October 15
9 Oct 22 Test I
10 Oct 29 The E/R Model Part I
11 Nov 5 The E/R Model Part II Quiz 3

Finalize your project team and topic
12 Nov 12 Constraints and Database Integrity

Anomalies

Normalization (1NF, BCNF, 4NF)

 Submit Problem Set 3
13 Nov 19 Transactions and Concurrency

Indexes and Views

 Quiz 4

Submit Problem Set 4
No Class Nov 26 Thanksgiving Break
14 Dec 3 Exam Review and Course Wrap-up Submit Class Project
15 Dec 10 Test II
Dec 20 Final grades will be available on PAWS on Dec 20 at 5PM.
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:Wednesday 12:00 PM to 2:00 PM or by appointment

Course: CIS 3730 Database Management Systems

Semester: Fall 2019

Class (1). Time: Tuesday 12:45PM–3:15PM – Location: Langdale Hall 417

Class (2). Time: Wednesday 4:30PM–7:00PM – Location: Classroom South 310