ABCDEFGHIJKLMNOPQRSTUVWXYZ
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
WeekDateCategoryTopicsSupplementary Material ID
(Foreign Key to 2nd Sheet)
Readings
(Ch refers to the Textbook Chapters)
Comments
5
108/24LectureCourse Introduction; Relational ModelLN1-1Ch 1; Ch 2.1; Ch 2.2
6
108/26LectureSQL Basics; Set OperationsLN1-2Ch 6.1
7
208/31LectureJoinsLN2-1Ch 6.2
8
208/31GroupActivityGA1: SQL Basics; JoinsGA1
9
208/31ProjectProject description released
10
209/02LectureSubqueries; AggregationLN2-2Ch 6.4.3 - 6.4.7; Ch 8.1
11
209/02GroupActivityGA2: SubqueriesGA2
12
209/02HomeworkHW1 releasedHW1
13
209/04GroupActivityGA1 and GA2 due (at 11:59:59 PM CT)
14
209/05ProjectStage 0 due
15
309/07LectureDB Updates; Stored Procedures; ViewsLN3-1Ch 6.5
16
309/07GroupActivityGA3: AggregationGA3
17
309/09LectureConstraints; TriggersLN3-2Ch 7
18
309/09GroupActivityGA4: Constraints and TriggersGA4
19
309/11ProjectStage 1 due
20
309/11GroupActivityGA3 and GA4 due (at 11:59:59 PM CT)
21
409/14LectureER & UML ModelingLN4-1Ch 4.1-4.8
22
409/14GroupActivityGA6: Conceptual DesignGA6GA5 has been omitted
23
409/16ProjectConceptual and Logical DB DesignLN4-2Ch 3.1-3.5
24
409/16HomeworkHW1 due
25
409/17HomeworkHW2 releasedHW2
26
509/21LectureFunctional dependenciesLN5-1Ch 3.6.1-3.6.5
27
509/21GroupActivityGA7: Functional DependenciesGA7
28
509/23LectureNormal Forms: BCNFLN5-2Ch 3.6.6
29
509/23GroupActivityGA8: BCNFGA8
30
509/23LiteratureReviewStage 0 due
31
509/25GroupActivityGA6 and GA7 due (at 11:59:59 PM CT)
32
509/26ProjectStage 2 due (updated from 09/25 to 09/26)
33
609/28LectureNormal Forms: 3NFLN6-1, LN6-2
34
609/30LectureStorage and IndexingLN6-3Ch 13.1 - 13.2; Ch 14.1
35
610/02GroupActivityGA8 due (at 11:59:59 PM CT)
36
610/03HomeworkHW2 due (updated from 10/02 to 10/03)
37
710/05LectureIndexing: B+ treesLN7-1Ch 14.2
38
710/07LectureIndexing: Hash TablesLN7-2Ch 14.3
39
710/07GroupActivityGA10GA10
40
710/07GroupActivityGA11GA11
41
810/12ProjectFront/Back-End DevelopmentLN8-1
42
810/12HomeworkHW3 releasedHW3
43
810/14LectureTransactions in SQL; Isolation LevelsLN8-2Ch 8.6
44
810/14GroupActivityGA9: 3NFGA9
45
810/15LiteratureReviewStage 1 due (updated from 10/12 to 10/15)
46
810/16GroupActivityGA9 due (at 11:59:59 PM CT)
47
910/19LectureSerializable Isolation LevelCh 18.1-18.4
48
910/19ExamMidterm 1: Part I
49
910/21ExamMidterm 1: Part II
50
910/23ProjectStage 3 due (updated from 10/16 to 10/23)
51
1010/26LectureSerializable Isolation LevelLN10-1Ch 18.1-18.4
52
1010/26GroupActivityGA12: TransactionsGA12
53
1010/26GroupActivityGA13: SerializabilityGA13
54
1010/28LectureRelational Algebra; Physical PlanLN10-2Ch 5.1-5.2
55
1010/28GroupActivityno GA
56
1010/30GroupActivityGA12 and GA13 due
57
1011/02HomeworkHW3 due (updated from 10/26 due to Midterm schedule change)
58
1111/02LectureQuery ProcessingLN11-1
59
1111/02GroupActivityGA14: Relational Algebra (no deadline set)
60
1111/03HomeworkHW4A released (updated from 10/28 to 11/03)
61
1111/04LectureQuery Optimization Part 1LN11-2
62
1211/09LectureQuery Optimization Part 2LN12-1Ch 16.2-16.3
63
1211/10ProjectStage 4 due: Project Midterm Demo (updated from 11/04)
64
1211/11ProjectIn-class project demo
65
1211/11LectureQuery Optimization Part 2Ch 16.4-16.6
66
1211/13HomeworkHW4A due (updated from 11/11 to 11/13)
67
1211/14HomeworkHW4A solution released (grading will take time)
68
1311/16ExamMidterm 2-1
69
1311/17HomeworkHW4B releasedHW4B
70
1311/18LectureNoSQL Overview; MongoDBLN13-2
71
1311/20HomeworkHW5 released
72
BR11/23BreakFall Break
73
BR11/25BreakFall Break
74
BR11/27HomeworkHW4B due
75
BR11/27ExtraCreditExtra credit project due
76
1411/30LectureMongoDB: aggregationLN14-1
77
1411/30LectureGraph Databases; Neo4j
78
1412/02ProjectStage 5 due: Project Final Demo
79
1512/07ExamMidterm 2-2
80
1412/07HomeworkHW5 due (11:59:59 PM)
81
1512/11LiteratureReviewStage 2 due (updated)
82
1512/10ProjectStage 6 due (removed from project description as well)
83
12/21Our internal deadline for finalizing final grades
84
12/23University deadline for reporting final grades (by 2PM)
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100