-
Notifications
You must be signed in to change notification settings - Fork 7
/
cs4400.summer2016
95 lines (88 loc) · 2.79 KB
/
cs4400.summer2016
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
---
layout: default
title: CS 4400 - Summer 2016
---
<h2>Weekly Schedule</h2>
<ul>
<li>Lecture: 4 days per week from 08:30 - 09:30</li>
</ul>
<h2>Lecture Schedule</h2>
<p>
Topics link to slides, where available.
</p>
<ul>
<li>FoDS means <a href="http://www.amazon.com/Fundamentals-Database-Systems-7th-Edition/dp/0133970779" target="_blank">Fundamentals of Database Systems</a>, the course textbook.
</ul>
BEGIN_SCHEDULE
Week 1
2016-05-16;
2016-05-17; Arrival and Check In
2016-05-18; Orientations
2016-05-19; intro-cs4400
2016-05-20; intro-databases
Week 2
2016-05-23; <b>No Class</b>
2016-05-24; database-concepts
2016-05-25; er-models
2016-05-26; er-models
2016-05-27; eer-models
Week 3
2016-05-30; <a href="slides/eer-exercise.html">EER Exercise</a>
2016-05-31; conceptual-design-process
2016-06-01; Review
2016-06-02; Field Trip
2016-06-03; <b>Exam 1</b>
Week 4
2016-06-06; <b>No Class</b>
2016-06-07; relational-model
2016-06-08; relational-model
2016-06-09; Project Work Day; <b>Phase 1 Due</b>
2016-06-10; relational-algebra
Week 5
2016-06-13; <b>No Class</b>
2016-06-14; relational-algebra
2016-06-15; relational-algebra
2016-06-16; Review
2016-06-17; <b>Exam 2</b>
Week 6
2016-06-20; er-relational-mapping
2016-06-21; basic-relational-design
2016-06-22; sql-ddl-crud
2016-06-23; sql-ddl-crud
2016-06-24; <b>No Class</b>
Week 7
2016-06-27; <b>No Class</b>
2016-06-28; sql-queries
2016-06-29; sql-queries
2016-06-30; sql-advanced
2016-07-01; sql-advanced; Withdrawal deadline: 2 July
Week 8
2016-07-04; <b>No Class</b>
2016-07-05; In-class exercise: <a href="exercises/sakila-queries.sql">sakila-queries.sql</a>
2016-07-06; In-class exercise: <a href="exercises/sakila-queries.sql">sakila-queries.sql</a>
2016-07-07; In-class exercise: <a href="exercises/sakila-queries.sql">sakila-queries.sql</a>
2016-07-08; In-class exercise answers: <a href="exercises/sakila-queries-answers.sql">sakila-queries-answers.sql</a>
Week 9
2016-07-11; Database web app development: <a href="https://github.com/csimpkins/sakila-demo">https://github.com/csimpkins/sakila-demo</a>
2016-07-12; relational-design; <b>Phase 2 Due</b>
2016-07-13; advanced-relational-design
2016-07-14; <b>Bastille Day - No class</b>
2016-07-15; <b>No Class</b>
Week 10
2016-07-18; advanced-relational-design; <a href="exercises/bcnf-decomposition.pdf">BCNF Decomposition Exercise</a>
2016-07-19; Review
2016-07-20; <b>Exam 3</b>
2016-07-21; <b>Exam 3 SQL Queries</b>
2016-07-22; <b>No Class</b>
Week 11
2016-07-25; Project Work Day
2016-07-26; storage-structures; Project work day for students not taking final
2016-07-27; index-structures; Project work day for students not taking final
2016-07-28; Project Demos
2016-07-29; Project Demos;
Finals Week
2016-08-01;
2016-08-02; Final Exam, 12:00-15:00; Project Demos, Phase 3 Due
2016-08-03;
2016-08-04;
2016-08-05; Departure