Tentative schedule

No.

Day

Date

Topics

Reading List
7th Edition Ch
1
 Mon 5/8

Course introduction & objectives; Overview of database systems:

1, 2

Relational model

5

2 Wed 5/10

Relational algebra and SQL queries

8, 6, 7

Query execution; Project 1+

18
3 Fri 5/12 

WinRDBI

 

MariaDB (XAMPP)

 
4 Mon 5/15

Database design and normalization(top-down)

3, 4, 9, 14

Index, view, trigger, and stored procedure; Quiz-1 (Module 1)

 17, 7, 10
5 Wed 5/17

Design (Bottom-up), Query processing  

18

-Project 1;Query optimization; Project 2+

19
6 Fri 5/19

Transaction processing, serializability, 

20, 21

locks, concurrency protocols                                                          

 
7 Mon 5/22 

Time stamp ordering protocols

21

Quiz-2 (Modules 2,3,4)

 
8 Wed 5/24

Mid-term exam

  
9 Fri 5/26 

Web queries

 11

-Project 2 Web Databases and PHP queries; Project 3+

 
  Mon 5/29

Memorial Day (University Closed)

  
10 Wed  5/31

XML, Document Type Definition, Generating XML documents from databases

 13

 XML queries, XML schema

 
11 Fri 6/2 

Data mining, generating association rules

 28

Project 4+

 
12 Mon 6/5

Classification, clustering, Apriori algorithm

 

 -Project 3;  Frequent Pattern Tree algorithm; Quiz-3 (Modules 5,6,7)

  
13 Wed 6/7

Data warehouse schema: star, snow flake; OLTP and OLAP

29

Information retrieval and web search

  
14 Fri 6/9

NOSQL Databases

24

MongoDB and Hive

  
15 Mon 6/12

 Hadoop, DFS, and Map Reduce

25
 -Project 4;  Spark; Quiz-4 (Module 8)  
16 Wed 6/14

 Review

 
17
 Fri 6/16

Final exam (5:00pm - 7:15pm)

 

Project x+ : The specification for Project x will be made available

-Project x : The completed Project x must be submitted before the class begins