CS 3140 Database Systems

zyBooks Activities - zyBooks "participation" activities and readings are should be read before the class they are assigned.  Each section usually takes on average 10 minutes complete (although some might take a little more time and some might take a little less time).  "Challenge" activities are more like regular homework and should be tried as you read the material so that you have time to ask questions about them in class. Both zyBooks participation and challenge activities for the week are due each Friday at midnight (11:59:59pm).

Lab Work - At different points in the class, we will pause from regular lectures to implement a learned concept during a lab (in-class or on your own). These labs are meant to give you experience outside of your textbook chapter with a real database. In-class labs are typically meant to be finished within the regular class period, but if they are not completed in class, they must be completed by the due date.

Week #1
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
8/25		Get the online textbook First Day Introduction Introduction to Databases
8/27	zyBooks 1.1 - 1.2	Introduction to Databases	Have the online textbook
8/29	zybBooks 1.3 - 1.5 Start lab 1A (blackboard)	Introduction to Databases Getting started with Lab 1A	zyBooks participation and challenges due for week #1

Week #2
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
9/1	Holiday, no class
9/3	zyBooks 2.1	Relational Database and Basic SQL Class ends early for Lab 1A help	Lab 1A Due
9/5	zyBooks 2.2-2.4	Relational Database and Basic SQL	zyBooks participation and challenges due for week #2

Week #3
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
9/8	zyBooks 2.5-2.6 Labs 2A, 2B, 2C (blackboard)	Relational Database and Basic SQL
9/10	zyBooks 2.7	Relational Database and Basic SQL Class Notes - NULL Logic	Lab 2A, 2B, 2C due
9/12	zyBooks 2.8 labs 2D, 2E, 2F (blackboard)	Relational Database and Basic SQL test database script - Do not double-click the file. First open workbench, connect to your database, then open this file by selecting File -> Open SQL Script answers - Contains the answers to the questions in the test database script	zyBooks participation and challenges due for week #3

Week #4
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
9/15	zyBooks 2.9 - 2.10	Relational Database and Basic SQL	labs 2D, 2E, 2F due
9/17	zyBooks 2.11 - 2.12 Labs 2G, 2H, 2I (blackboard)	Relational Database and Basic SQL
9/19	Review	Exam 1 Study Guide	Labs 2G, 2H, 2I due zyBooks participation and challenges due for week #4

Week #5
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
9/22	Exam 1 Room Sabin 102	45 minute eLearning test, 5x8 notecard allowed
9/24	zyBooks 2.13	Normal Forms Practice Exercise - Normal Forms (Part 1) Class Notes - Normal Forms (Part 1)
9/26 No Class	zyBooks 2.14	Normal Forms Class Notes - Normal Forms (Part 2) Watch Class Video Here	zyBooks participation and challenges due for week #5

Week #6
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
9/29	zyBooks 3.1	Advanced SQL Sakila Database EER Diagram Workbench script - Practice along with the lecture
10/1	zyBooks 3.2	Advanced SQL Class Notes - Local Variables Workbench script - Practice along with the lecture
10/3	zyBooks 3.3 Lab 3A (blackboard)	Advanced SQL Workbench script - Practice along with the lecture	zyBooks participation and challenges due for week #6

Week #7
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
10/6	zyBooks 3.4	Advanced SQL Practice Exercise - JOIN Practice Workbench script - Practice along with the lecture	Lab 3A due
10/8	zyBooks 3.5 Labs 3B,3C, 3D (blackboard)	Advanced SQL
10/10	zyBooks 3.6 (to be continued on Monday)	Advanced SQL Workbench script - Practice along with the lecture	Labs 3B, 3C, 3D zyBooks participation and challenges due for week #7

Week #8
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
10/13	zyBooks 3.6 Labs 3E, 3F (blackboard)	Continue previous lecture Workbench script - Practice along with the lecture
10/15	zyBooks 3.7	Advanced SQL	labs 3E, 3F due
10/17	Review	Exam 2 Study Guide The following links can give you additional practice. Be sure to glance at the solution before solving each problem to make sure the solution doesn't contain elements no discussed in class, then try to solve the problem yourself. Subquery Practice JOIN Practice Aggregate Function Practice Wildcards, Order By, Group By Practice	zyBooks participation and challenges due for week #8

Week #9
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
10/20	No class	Exam Postponed, AWS Outage
10/22	Exam 2 Room Sabin 102	Exam 2 eLearning exam takes place in SABIN 102
10/24	zyBooks 4.1-4.2	Database Design	zyBooks participation and challenges due for week #9

Week #10
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
10/27	zyBooks 4.3	Database Design EER diagram developed in class
10/29	In-class lab work day Lab 4A	Lab 4A - Create a basic EER Diagram	Database Design
10/31	zyBooks 4.4	Database Design   Section EER diagram developed in class	Lab 4A due zyBooks participation and challenges due for week #10

Week #11
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
11/3	zyBooks 4.5	Database Design Section EER diagram developed in class
11/5	zyBooks 4.6	Database Design
11/7	zyBooks 4.7-4.8	Database Design Final EER diagram developed in class	zyBooks participation and challenges due for week #11

Week #12
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
11/10	zyBook 4.9	Database Design
11/12	zyBooks 5.1 Lab 5A	Database Programming Starter code - Demonstrates how to use python to interace with sakila Unsafe Code - Demonstrates SQL injection and how to prevent it
11/14	Review	Review for Exam #3	Lab 5A due zyBooks participation and challenges due for week #12

Week #13
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
11/17	Exam in SABIN 102	Exam #3
11/19		Introduction to the Final Database Project (due 12/11 at 11:59pm)
11/21	No Class	No class, holding office hours for questions about the project

Thanksgiving Break

Week #14
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
12/1	Project Work Day	Quick Topics: (1) Creating a discovery statement for your new database (2) Forward Engineering your EER diagram into a database (3) Starting data importing
12/3	Project Work Day	Quick Topics: (1) Common Errors and Importing Data with Foreign Keys
12/5	Project Work Day	Quick Topics: (1) Creating sql file for your queries with comments (phase 2)

Week #15
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
12/8	Project Work Day	Quick Topics: (1) Python Questions (phase 3) (2) Turning everything in
12/10	Project Work Day	Project Work Day	Final Project Due Friday 12/11 at 11:59pm
12/12	Optional Final Review Project Work Day	Optional Final Review Study Guide

Finals Week
Date	Activities Assigned	Topics/Notes	Due Today by 11:59pm
12/16 (Tues)	Sabin 102	Optional Final from 1:00pm-2:50pm