Databases (CS53001 Spring 2014)

 
Week Date Topics Reading Assignments
1 4/3 Introduction, Entity-Relationship model and design FC: 1, 4.1-4.4
DS: 1, 2
hw1
2 4/10 Database design, Relational model, Functional dependencies FC: 2.1-2.2, 3.1-3.5, 4
DS: 3, 4
hw2
3 4/17 Normal forms, Relational algebra, SQL: Schemas, Simple queries FC: 2.3-2.5, 5, 6.1-6.2
DS: 4, 5
hw3
4 4/24 SQL: Subqueries, Aggregation, Modifications FC: 6.2-6.5
DS: 5
hw4
5 5/1 SQL: Joins, Views, Indexes, Constraints FC: 6.3, 7.1-7.2, 8.1-8.4
DS: 5, 6
hw5
6 5/8 Midterm; Transactions, Authorization FC: 6.6, 10.1
DS: 10, class notes
hw6
7 5/15 Triggers, Stored procedures FC: 7.5, 9.1-9.4
DS: 6, class notes
hw7
8 5/16 Midterm review; Database connectivity, Web programming FC: 9.5-9.7
DS: 10
class notes
hw8
9 5/29 Data warehousing, Data mining class notes
DS: 7, App. G
hw9 (due Jun 9, Jun 5 for graduating students)
10 6/5 NoSQL Databases, Big Data, MapReduce class notes
DS: App. I, J
- 6/9 Final project deadline!