Week | Date | Topic | Readings | Posted Materials | Deliverables |
---|---|---|---|---|---|
1 | Jan. 11 | Course Overview | Chapter 1 | Course overview, database application desciption, information stewardship paper desciption | |
Jan. 13 | Database Environment | Chapter 2 | Chapter 1 slides, Chapter 2 slides | ||
Jan. 15 | Introduction to SQL, LIKE and Aggregate Functions | Chapter 6, pages 133-151 | Slides, lab 1, Hotel Reservations data model and sample extension, answers | ||
2 | Jan. 18 | Martin Luther King Jr. Birthday | |||
Jan. 20 | Database Architecture | Chapter 3, pages 57-65, 77-79 | Chapter 3 | ||
Jan. 22 | SQL GROUP BY, HAVING, Subqueries | Chapter 6, pages 151-157 | Slides, lab 2, answers, quiz 1, answers | ||
3 | Jan. 25 | Information Stewardship, European Directive 95/46/EC | Chapter 21 | Chapter 21 | |
Jan. 27 | Relational Model | Chapter 4 | Chapter 4 | ||
Jan. 29 | SQL JOINS using Microsoft SQLServer | Chapter 6, pages 158-172 | Slides, lab 3, answers, database overview from Arizona State University | Information Stewardship - topic and references | |
4 | Feb. 1 | DB Systems Lifecycle | Chapter 10 | Chapter 10 slides (few from Chapter 11) | |
Feb. 3 | Information Stewardship Discussions | No Readings | |||
Feb. 5 | SQL JOIN and Multi-Table Queries | No new readings | Slides, exercise, answers, lab 4, answers, SPJ DB, quiz 2, answers | ||
5 | Feb. 8 | Entity-Relationship Modeling | Chapter 12, pages 321-334 | Slides | |
Feb. 10 | Multiplicity in ER Diagrams | Chapter 12, pages 335-342Section 2.1, pages 102-107 | Exercises, answers | ||
Feb. 12 | SQL DDL (SQLServer) | Chapter 7, pages 175-192 | Slides, lab 5, answers, SQLServer script for Questions 1 & 2 | DB Application - application description | |
6 | Feb. 15 | President's Day | |||
Feb. 17 | Conceptual Design Studio #1 | No Readings | Yappers description and conceptual model | Information Stewardship - thesis and arguments | |
Feb. 19 | Exam 1 | Review, 2015 exam, answers, exam, answers | DB Application - list of tasks | ||
7 | Feb. 22 | Go over exam | |||
Feb. 24 | Conceptual Design Studio #2 | No Readings | Jefferson Dance Club description and conceptual model | ||
Feb. 26 | SQL Views | Chapter 7 pages 193-203 | ODBC Slides, lab 6, answers | ||
8 | Feb. 29 | Conceptual Model to Logical Model | Chapter 17 | Slides, class exercise, answers | |
March 2 | Relational Algebra | Chapter 5, pages 109-122 | Slides, class exercise, answers | Email the following to me by midnight March 3rd: Project mission statment, objectives and list of tasks | |
March 4 | Project - Task list and conceptual model presentations | No new readings | DB Application - conceptual model | ||
9 | March 7 | Relational Algebra continued | Chapter 5, pages 119-122 | Exercise, answers |
|
March 9 | Normalization - Functional Dependencies | Chapter 14, pages 365-378 | Chapter 14 slides, class exercise, answers | ||
March 11 | Normalization | Lab 7, sales data in Excel, lab answers |
Information Stewardship - final paper due by beginning of class DB Applications - logical model, interface and CRUD matrix |
||
Spring Break, March 14-18 | |||||
10 | March 21 | Boyce-Codd Normal Form | Chapter 14, pages 378-389 & Chapter 15, pages 393-405 | Exercise, answer | |
March 23 | Boyce-Codd Normal Form continued | Exercise, answer | |||
March 25 | Mini Spring Break | ||||
11 | March 28 | When Not to Normalize | Chapter 19, pages 495-508 | Slides, quiz 3, answers | |
March 30 | Indexes | Chapter 18, pages 485-494 | Chapter 18 slides | ||
April 1 | Exam 2 | Review, 2015 exam, answers, exam, exam answers |
|
||
12 | April 4 | Project - DB Prototype Presentations |
DB Application - user interface, data in tables, |
||
April 6 | SQL Injection | ||||
April 8 | SQL Injection and Prepared Statements | Slides, lab 8, answers, script to recreate StudentInformation table if it gets deleted | |||
13 | April 11 | Query Optimization | Chapter 23, pages 627-630 | Chapter 23 slides | |
April 13 | Concurrency Control and Transactions | Chapter 22, pages 569-597 | Chapter 22 slides, class exericse | ||
April 15 | Transactions | Script to create MySQL db, lab, partial answers | Draft report due | ||
14 | April 18 | eXtensible Markup Language, XML | Chapter 31, pages 1055-1058, 1063-1074, 1081-1087, 1091-1101 | Chapter 31 slides, class exericse | |
April 20 | NoSQL (Not Only SQL) | Slides | |||
April 22 | MySQL Workbench and Triggers | Chapter 8, pages 223-229 | MySQLWorkbench slides | ||
15 | April 25 | Big Data and Data Mining | Big data and data mining slides | ||
April 27 | Map-Reduce | Map-reduce slides | |||
April 29 | Project Presentations to Clients | DB Application - completed | |||
16 | May 2 | Project Reflection, Review | DB Application - final report and application, peer review, reflection paper, | ||
May 4 | Final Exam, Wednesday,8:00am-10:00am (11:00 if needed) | Review, 2015 exam, answers |