ScheduleS17

  • 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)