Schedule

This schedule includes a week by week summary of in-class activities, pre-class and post-class responsibilities, dates of exams, and due dates of quizzes, individual assignments, and project deliverables.

WEEK 1

Week’s Topics:

  •  Course Overview
  •  Sample DB problem and IEEE Code of Conduct

To Do before January 10 class:

  • Read and start Assignment A1 (due on Friday, Jan 13), requires about 3 hours

Class meeting (Tuesday, January 10 ):

To Do before Jan 12 class:

Class meeting (Thursday, January 12 ):

To Do after Jan 12 class:

  • Submit Assignment A1 by Friday, January 13 at 11:59 pm
  • Submit Data Diary entries by Saturday, January 14 at 11:59 pm (required for 5265, optional for 3265)

WEEK 2

Week’s Topics:

  •  Relational Algebra
  •  Human Centered Design

To Do before January 17 class:

Class meeting (Jan 17):

To Do before Jan 19 class:

Class meeting (Jan 19):

To Do after Jan 19 class:

  • Quiz 2 RA on Blackboard by Friday, January 20 at 11:59 pm
  • Submit Assignment A2 on Blackboard by Saturday, January 21 at 11:59 pm
  • Submit Data Diary entries by Saturday, January 21 at 11:59 pm (required for 5265, optional for 3265)

WEEK 3

Week’s Topics:

  • SQL basics
  • Sustainable Design

To Do BEFORE January 24 class:

Class meeting (January 24):

To Do BEFORE January 26 class:

Class meeting (January 26):

To Do after Jan 26 class:

  • Quiz 4 SQL on Blackboard by Friday, January 27 at 11:59 pm
  • Submit Assignment A3 on Blackboard by Saturday, January 28 at 11:59 pm
  • Submit Data Diary entries by Saturday, January 28 at 11:59 pm (required for 5265, optional for 3265)

WEEK 4

Week’s Topics:

  • Intermediate SQL
  • Project topics and preferences

To Do BEFORE January 31 class:

Class meeting (January 31):

To Do BEFORE February 2 class:

Class meeting (February 2):

To Do after February 2 class:

  • Quiz 6 SQL on Blackboard by Friday, February 3 at 11:59 pm (no quiz)
  • Submit Assignment A4 on Blackboard by Saturday, February 4 at 11:59 pm
  • Submit Data Diary entries by Saturday, February 4 at 11:59 pm (required for 5265, optional for 3265)
  • Study for Exam 1 (2 hours estimate)

WEEK 5

Week’s Topics:

  • Exam
  • Project teams announced
  • Database Conceptual Design

To Do BEFORE February 7 class:

  • Study for Exam 1 (2 hour estimate).

In Class (February 7):

  • Exam 1

To Do BEFORE February 9 class:

In Class (February 9):

To Do after February 9 class:

  • Submit Data Diary entries by Saturday, February 11 at 11:59 pm (required for 5265, optional for 3265)

WEEK 6

Week’s Topics:

  • Constraints
  • Referential Integrity
  • Triggers
  • Project topic specification

To Do BEFORE February 14 class:

In Class (February 14):

To Do BEFORE February 16 class:

In Class (February 16):

To Do after February 16 class:

  • Quiz 8 SQL on Blackboard by Friday, February 17 at 11:59 pm
  • Submit Group Project Deliverable GPD1 on Blackboard by Friday, February 17 at 11:59 pm
  • Submit Data Diary entries by Saturday, February 18 at 11:59 pm (required for 5265, optional for 3265)

WEEK 7

Week’s Topics:

  • Unified Modeling Language

To Do BEFORE Feb 21:

In Class (February 21):

To Do BEFORE Feb 23:

In Class (February 23):

To Do after February 23 class:

  • Read and start Group Project Deliverable GDP2 (due on Friday, March 3, intermediate draft due Wednesday March 1), estimate 3 hours this week
  • Read individual Assignment 5 (due on Saturday, March 4, at 11:59 pm)
  • Quiz 10 UML on Blackboard by Friday, February 24 at 11:59 pm
  • Submit Data Diary entries by Saturday, February 25 at 11:59 pm (required for 5265, optional for 3265)

WEEK 8

Week’s Topics:

  • Review
  • Project UML

To Do BEFORE February 28 class:

  • Study for Exam 2 (estimate 3 hours)
  • Continue Group Project Deliverable GPD2 (draft due on March 1; final due on Friday, March 3), estimate 2 hours this week, five hours total
  • Continue individual Assignment 5 (due Saturday, March 4)

In Class (February 28):

  • Exam 2 (Tuesday, 8:10 am only)

To Do BEFORE March 2:

  • Submit draft UML designs (part of GPD2) on Blackboard by Wednesday, March 1 at 9:00 pm

In Class (March 2):

  • Peer and instructor UML reviews (NO WEDNESDAY AFTERNOON MEETING)
  • Pass back Exam 2 at end of class (see Key and rubric)

To Do after March 2 class:


WEEK 9 Spring break (March 4 – March 12 )


WEEK 10

Week’s Topics:

  • Views
    • Modification with Triggers
    • Automatic View Modification
    • Materialized Views
  • Project table definitions (and UML)

To Do BEFORE March 14:

In Class (Tuesday, March 14):

To Do BEFORE March 16:

In Class (March 16):

To Do after March 16 class:

  • Quiz 12 on Views and Design on Blackboard by Friday, March 17 at 11:59 pm
  • Submit Data Diary entries by Saturday, March 18 at 11:59 pm (required for 5265, optional for 3265)

WEEK 11

Week’s Topics:

  • Relational Design
    • Functional Dependencies
    • Boyce Codd Normal Form
    • Relational decomposition
  • Project Queries

To Do BEFORE March 21:

In Class (March 21):

To Do BEFORE March 23:

In Class (March 23):

To Do after March 23 class:

  • Quiz 14 RD on Blackboard by Friday, March 24 Saturday, March 25 at 11:59 pm
  • Submit Group Project Deliverable GPD3 on Blackboard by Friday, March 24 at 11:59 pm
  • Submit individual Assignment 6 on Blackboard by Saturday, March 25 at 11:59 pm
  • Submit Data Diary entries by Saturday, March 25 at 11:59 pm (required for 5265, optional for 3265)

WEEK 12

Week’s Topics:

  • Introduction to Indexes
  • Exam

To Do BEFORE March 28:

In Class (March 28):

To Do BEFORE March 30:

In Class (March 30):

  • Exam 3

To Do after March 30 class:

  • Submit Data Diary entries by Saturday, April 1 at 11:59 pm (required for 5265, optional for 3265)
  • No end-of-week quiz
  • Exam 3 Key and rubric

WEEK 13

Week’s Topics:

  • Group projects
  • Introduction to Transactions
  • Isolation Levels

To Do BEFORE April 4 class:

  • Work in groups on final project deliverables

In Class (April 4):

  • No Class — work in groups

To Do BEFORE April 6 class:

  • Transaction Tasks
  • Quiz 16 Transactions on Blackboard (I didn’t put up — everyone gets 3 points)

In Class (April 6)

To Do after April 6 class:

  • No end-of-week quiz
  • Submit Data Diary entries by Saturday, April 8 at 11:59 pm (required for 5265, optional for 3265)
  • Submit GDP4 final design and implementation documents by Saturday, April 8 at 11:59 pm on Blackboard

WEEK 14

Week’s Topics:

  • Projects and Presentations

To Do BEFORE April 11:

In Class (April 11):

  • Project Presentations

To Do BEFORE April 13:

IN Class (April 13):

  • Project Presentations

To Do After April 13 Class:


WEEK 15

All week: meetings by appointment

Week’s Topics:

  • Final Exam
  • Course Evaluations

To Do BEFORE April 18 class:

In Class (April 18):

  • Final Exam part 1

To Do BEFORE April 20 class:

In Class (April 20):

  • Final Exam part 2 (first 60 minutes of class)
  • Course evaluations (last 15 minutes of class)

Posted April 22: Final Exam Part 2 and Extra Credit Key and rubric

Classes End (Monday, April 24)

Reading Day (Tuesday, April 25, 2016)

Thursday, May 4, 2017; 9:00 AM – 12:00 Noon: FINAL EXAM http://registrar.vanderbilt.edu/cms/wp-content/files/Spring-2017-exam-schedule.pdf (all work, including final exam, has been completed)

OPTIONAL MATERIAL (will not count towards CS 265 grade): If you do these now or later, and if you would like to see a followup course, please email me (anytime).

DB2 XML

  • Watch videos (45 min) and answer questions from DB2 XML Data (https://class.stanford.edu/courses/DB/XML/SelfPaced/courseware/ch-xml_data/)
    • Well-formed XML (9:35 + 3:44)
    • DTDs, IDs, and IDREFs (18:01)
    • XML Schema (13:09);
  • Do XML Quiz
  • Do DTD Exercises from DB2
  • Complete DB2 XML Data mini course (OPTIONAL! Will not count towards CS 265 grade)

 

DB3 JSON

  • Watch videos (40 min) and answer questions from DB3 JSON Data (https://class.stanford.edu/courses/DB/JSON/SelfPaced/courseware/ch-json_data/)
    • Introduction to JSON Data (7:30 + 6:43)
    • JSON Demo (22:17)
  • Do JSON Quiz
  • Complete DB3 JSON Data mini course (OPTIONAL! Will not count towards CS 265 grade)

DB6 XPATH and XQUERY

  • Watch videos (60 min) from DB6 XPath and XQuery
    • XPath Introduction (9:50)
    • XPath Demo (22:16)
    • XQuery Introduction (5:13)
    • XQuery Demo (16:20)
  • Do XML Course-Catalog XPath and XQuery Exercises
  • Do XML World-Countries XPath and XQuery Exercises
  • Complete DB6 XPath and XQuery mini course (OPTIONAL! Will not count towards CS 265 grade)

DB7 XSLT

  • Watch videos ( min) from DB7 XSLT (OPTIONAL!)
    • XSLT (22:14)
  • Do XML Course-Catalog XSLT exercises
  • Do XML World Countries XSLT exercises
  • Complete DB7 XSLT mini course (OPTIONAL! Will not count towards CS 265 grade)

Complete DB8 Relational Design Theory

  • Watch remaining videos (36 min) and answer questions from DB8 Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
    • Multivalued Dependencies (6:24 + 4:26 + 11:30 + 1:23)
  • Do the Multivalued Dependencies Quiz from DB8Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
  • Complete the Normalization Quiz from DB8 Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)

Complete DB12 Views and Authorization

 

DB13 Online-Analytical Processing

  • Watch videos (45 min ) and answer questions from DB13 Online- Analytical Processing (https://class.stanford.edu/courses/DB/OLAP/SelfPaced/courseware/ch-on-line_analytical_processing/)
    • Introduction to OLAP (14:22 + 3:46)
    • OLAP Demo (26:46)
  • Do OLAP Quiz
  • Complete DB13 Online Analytical Processing mini course (OPTIONAL! Will not count towards CS 265 grade)

DB14 Recursion in SQL

  • Watch videos (63 min ) from DB14 Recursion in SQL (OPTIONAL!)
    • Basic Recursive WITH Statement – Introduction (11:54)
    • Basic Recursive WITH Statement Demo (30:06)
    • Non-linear and Mutual Recursion (8:05 + 13:00)
  • Do Recursion Quiz (OPTIONAL!)
  • Complete DB14 Recursion in SQL mini course (OPTIONAL! Will not count towards CS 265 grade)