FA2021 CS411: Schedule and Lecture Slides

	A	B	C	D	E	F	G
1	Recap: Note that (Date, Category) can serve as a KEY of this relation
2	Note: LiteratureReview is only for graduate students (4 credit option)
3
4	Week	Date	Category	Topics	Supplementary Material ID (Foreign Key to 2nd Sheet)	Readings (Ch refers to the Textbook Chapters)	Comments
5	1	08/24	Lecture	Course Introduction; Relational Model	LN1-1	Ch 1; Ch 2.1; Ch 2.2
6	1	08/26	Lecture	SQL Basics; Set Operations	LN1-2	Ch 6.1
7	2	08/31	Lecture	Joins	LN2-1	Ch 6.2
8	2	08/31	GroupActivity	GA1: SQL Basics; Joins	GA1
9	2	08/31	Project	Project description released
10	2	09/02	Lecture	Subqueries; Aggregation	LN2-2	Ch 6.4.3 - 6.4.7; Ch 8.1
11	2	09/02	GroupActivity	GA2: Subqueries	GA2
12	2	09/02	Homework	HW1 released	HW1
13	2	09/04	GroupActivity	GA1 and GA2 due (at 11:59:59 PM CT)
14	2	09/05	Project	Stage 0 due
15	3	09/07	Lecture	DB Updates; Stored Procedures; Views	LN3-1	Ch 6.5
16	3	09/07	GroupActivity	GA3: Aggregation	GA3
17	3	09/09	Lecture	Constraints; Triggers	LN3-2	Ch 7
18	3	09/09	GroupActivity	GA4: Constraints and Triggers	GA4
19	3	09/11	Project	Stage 1 due
20	3	09/11	GroupActivity	GA3 and GA4 due (at 11:59:59 PM CT)
21	4	09/14	Lecture	ER & UML Modeling	LN4-1	Ch 4.1-4.8
22	4	09/14	GroupActivity	GA6: Conceptual Design	GA6		GA5 has been omitted
23	4	09/16	Project	Conceptual and Logical DB Design	LN4-2	Ch 3.1-3.5
24	4	09/16	Homework	HW1 due
25	4	09/17	Homework	HW2 released	HW2
26	5	09/21	Lecture	Functional dependencies	LN5-1	Ch 3.6.1-3.6.5
27	5	09/21	GroupActivity	GA7: Functional Dependencies	GA7
28	5	09/23	Lecture	Normal Forms: BCNF	LN5-2	Ch 3.6.6
29	5	09/23	GroupActivity	GA8: BCNF	GA8
30	5	09/23	LiteratureReview	Stage 0 due
31	5	09/25	GroupActivity	GA6 and GA7 due (at 11:59:59 PM CT)
32	5	09/26	Project	Stage 2 due (updated from 09/25 to 09/26)
33	6	09/28	Lecture	Normal Forms: 3NF	LN6-1, LN6-2
34	6	09/30	Lecture	Storage and Indexing	LN6-3	Ch 13.1 - 13.2; Ch 14.1
35	6	10/02	GroupActivity	GA8 due (at 11:59:59 PM CT)
36	6	10/03	Homework	HW2 due (updated from 10/02 to 10/03)
37	7	10/05	Lecture	Indexing: B+ trees	LN7-1	Ch 14.2
38	7	10/07	Lecture	Indexing: Hash Tables	LN7-2	Ch 14.3
39	7	10/07	GroupActivity	GA10	GA10
40	7	10/07	GroupActivity	GA11	GA11
41	8	10/12	Project	Front/Back-End Development	LN8-1
42	8	10/12	Homework	HW3 released	HW3
43	8	10/14	Lecture	Transactions in SQL; Isolation Levels	LN8-2	Ch 8.6
44	8	10/14	GroupActivity	GA9: 3NF	GA9
45	8	10/15	LiteratureReview	Stage 1 due (updated from 10/12 to 10/15)
46	8	10/16	GroupActivity	GA9 due (at 11:59:59 PM CT)
47	9	10/19	Lecture	Serializable Isolation Level		Ch 18.1-18.4
48	9	10/19	Exam	Midterm 1: Part I
49	9	10/21	Exam	Midterm 1: Part II
50	9	10/23	Project	Stage 3 due (updated from 10/16 to 10/23)
51	10	10/26	Lecture	Serializable Isolation Level	LN10-1	Ch 18.1-18.4
52	10	10/26	GroupActivity	GA12: Transactions	GA12
53	10	10/26	GroupActivity	GA13: Serializability	GA13
54	10	10/28	Lecture	Relational Algebra; Physical Plan	LN10-2	Ch 5.1-5.2
55	10	10/28	GroupActivity	no GA
56	10	10/30	GroupActivity	GA12 and GA13 due
57	10	11/02	Homework	HW3 due (updated from 10/26 due to Midterm schedule change)
58	11	11/02	Lecture	Query Processing	LN11-1
59	11	11/02	GroupActivity	GA14: Relational Algebra (no deadline set)
60	11	11/03	Homework	HW4A released (updated from 10/28 to 11/03)
61	11	11/04	Lecture	Query Optimization Part 1	LN11-2
62	12	11/09	Lecture	Query Optimization Part 2	LN12-1	Ch 16.2-16.3
63	12	11/10	Project	Stage 4 due: Project Midterm Demo (updated from 11/04)
64	12	11/11	Project	In-class project demo
65	12	11/11	Lecture	Query Optimization Part 2		Ch 16.4-16.6
66	12	11/13	Homework	HW4A due (updated from 11/11 to 11/13)
67	12	11/14	Homework	HW4A solution released (grading will take time)
68	13	11/16	Exam	Midterm 2-1
69	13	11/17	Homework	HW4B released	HW4B
70	13	11/18	Lecture	NoSQL Overview; MongoDB	LN13-2
71	13	11/20	Homework	HW5 released
72	BR	11/23	Break	Fall Break
73	BR	11/25	Break	Fall Break
74	BR	11/27	Homework	HW4B due
75	BR	11/27	ExtraCredit	Extra credit project due
76	14	11/30	Lecture	MongoDB: aggregation	LN14-1
77	14	11/30	Lecture	Graph Databases; Neo4j
78	14	12/02	Project	Stage 5 due: Project Final Demo
79	15	12/07	Exam	Midterm 2-2
80	14	12/07	Homework	HW5 due (11:59:59 PM)
81	15	12/11	LiteratureReview	Stage 2 due (updated)
82	15	12/10	Project	Stage 6 due (removed from project description as well)
83		12/21		Our internal deadline for finalizing final grades
84		12/23		University deadline for reporting final grades (by 2PM)
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100