{"id":1911,"date":"2017-12-22T22:54:44","date_gmt":"2017-12-23T03:54:44","guid":{"rendered":"http:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=1911"},"modified":"2017-12-22T22:57:02","modified_gmt":"2017-12-23T03:57:02","slug":"schedules17","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/schedules17\/","title":{"rendered":"ScheduleS17"},"content":{"rendered":"<ul>\n<li>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.<br \/>\n<h1><span style=\"color: #ff0000\">WEEK 1<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">\u00a0Course Overview<br \/>\n<\/span><\/li>\n<li><span style=\"color: #ff0000\">\u00a0Sample DB problem and IEEE Code of Conduct<br \/>\n<\/span><\/li>\n<\/ul>\n<h2>To Do before January 10 class:<\/h2>\n<ul>\n<li>Read and start\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/dorm-energy-project-deliverable-1\/\">Assignment A1<\/a>\u00a0(due on Friday, Jan 13), requires about 3 hours<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (Tuesday, January 10 ):<br \/>\n<\/span><\/h2>\n<ul>\n<li><span style=\"color: #000000\">Course Overview &#8212; discussions, readings, quizzes, exams, projects; WSPDBC\u00a0mini courses (<a href=\"http:\/\/online.stanford.edu\/course\/databases-self-paced\">http:\/\/online.stanford.edu\/course\/databases-self-paced<\/a>); optional textbook (U\/W) &#8212; see\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/course-organization\/\">Organization<\/a>.<br \/>\n<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do before Jan 12 class:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introduction-to-relational-model-tasks\/\"><span style=\"color: #000000\">Introduction to relational model tasks<\/span><\/a>\u00a0<span style=\"color: #000000\">(1 hour)<\/span><\/li>\n<\/ul>\n<h2>Class meeting (Thursday, January 12 )<span style=\"color: #000000\">:<br \/>\n<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introductory-database-exercises\/\">Introductory Relational Database Exercises<\/a>.<\/li>\n<\/ul>\n<h2>To Do after Jan 12 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit\u00a0<a style=\"color: #0000ff\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/dorm-energy-project-deliverable-1\/\">Assignment A1<\/a>\u00a0by Friday, January 13 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, January 14 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 2<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">\u00a0Relational Algebra<\/span><\/li>\n<li><span style=\"color: #ff0000\">\u00a0Human Centered Design<\/span><\/li>\n<\/ul>\n<h2>To Do before January 17 class:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-algebra-tasks-1\/\">Relational algebra tasks 1<\/a>\u00a0(2 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 1 RA on Blackboard<br \/>\n<\/span><\/strong><\/li>\n<\/ul>\n<h2>Class meeting (Jan 17):<\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-algebra-exercises-1\/\">Relational Algebra exercises 1<\/a><br \/>\n<\/span><\/li>\n<li>Discuss Hans Rosling\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/01\/Hans-Rosling-Candidate-Designs.pdf\">Candidate Designs<\/a>\u00a0and\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/hans-rosling-in-class-exercises\/\">Exercises<\/a><\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/dorm-energy-project-deliverable-1\/\">Assignment A1<\/a>\u00a0(<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/01\/Grading-rubric-for-Assignment-1.pdf\">Rubric<\/a>)<\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-human-centered-design\/\">Assignment 2<\/a><\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Quiz-1-RA-Key.pdf\">Quiz 1 RA Key<\/a><\/li>\n<\/ul>\n<h2>To Do before Jan 19 class:<\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-algebra-tasks-2\/\">Relational algebra tasks 2<\/a>\u00a0(2 hours)<\/span><\/li>\n<\/ul>\n<h2 style=\"color: #0000ff\"><span style=\"color: #000000\">Class meeting (Jan 19):<\/span><\/h2>\n<ul>\n<li><span style=\"color: #0000ff\"><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-algebra-exercises-2\/\">Relational Algebra Exercises 2<\/a><\/span><\/span><\/li>\n<\/ul>\n<h2>To Do after Jan 19 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Quiz 2 RA on Blackboard by Friday, January 20 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-human-centered-design\/\">Assignment A2<\/a>\u00a0on Blackboard by Saturday, January 21 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, January 21 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 3<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">SQL basics<\/span><\/li>\n<li><span style=\"color: #ff0000\">Sustainable Design<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE January 24 class:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introduction-to-sql\/\">Introduction to SQL\u00a0Tasks<\/a>\u00a0(3 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 3 SQL (on Blackboard)<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (January 24):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introductory-sql-exercises-1\/\">Introductory SQL exercises 1<\/a><\/li>\n<li>Review\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-human-centered-design\/\">Assignment 2<\/a>\u00a0from last week (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/01\/Assignment-2-rubric.pdf\">rubric<\/a>)<\/li>\n<li>Review\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-3-sustainable-interaction-design\/\">Assignment 3<\/a>\u00a0for this week (requires about 3 hours)<\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Quiz-2-RA-Key.pdf\">Quiz 2 RA key<\/a>\u00a0and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Quiz-3-SQL-Key.pdf\">Quiz 3 SQL key<\/a><\/li>\n<\/ul>\n<h2 style=\"color: #000000\">To Do BEFORE January 26 class:<\/h2>\n<h2>Class meeting (January 26):<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introductory-sql-exercises-2\/\">Introductory SQL exercises 2<\/a><\/li>\n<\/ul>\n<h2>To Do after Jan 26 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Quiz 4 SQL on Blackboard by Friday, January 27 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-3-sustainable-interaction-design\/\">Assignment A3<\/a>\u00a0on Blackboard by Saturday, January 28 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, January 28 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 4<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Intermediate SQL<\/span><\/li>\n<li><span style=\"color: #ff0000\">Project topics and preferences<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE January 31 class:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-tasks-1\/\">Intermediate SQL Tasks 1<\/a>\u00a0(3 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 5 SQL on Blackboard<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (January 31):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-exercises-1\/\">Intermediate SQL Exercises 1<\/a><\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-3-sustainable-interaction-design\/\">Assignment 3<\/a>\u00a0from last week<\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-4-individual-topic-interests\/\">Assignment 4<\/a>\u00a0(requires about 1 hour) for this week<\/li>\n<li>Discuss\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Quiz-4-SQL-Key-and-rubric.pdf\">Quiz 4 key<\/a>\u00a0and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Quiz-5-SQL-Key-and-rubric.pdf\">Quiz 5 key<\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE February 2 class:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-tasks-2\/\"><span style=\"color: #000000\">Intermediate SQL Tasks 2<\/span><\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (February 2):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-exercises-2\/\"><span style=\"color: #000000\">Intermediate SQL Exercises 2<\/span><\/a><\/li>\n<\/ul>\n<h2>To Do after February 2 class:<\/h2>\n<ul>\n<li><del><strong><span style=\"color: #0000ff\">Quiz 6 SQL on Blackboard by Friday, February 3 at 11:59 pm<\/span><\/strong><\/del><strong><span style=\"color: #0000ff\">\u00a0(no quiz)<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-4-individual-topic-interests\/\">Assignment A4<\/a>\u00a0on Blackboard by Saturday, February 4 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, February 4 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<li>Study for Exam 1 (2 hours estimate)<\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 5<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Exam<\/span><\/li>\n<li><span style=\"color: #ff0000\">Project teams announced<\/span><\/li>\n<li><span style=\"color: #ff0000\">Database Conceptual Design<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #ff0000\"><span style=\"color: #000000\">To Do BEFORE February 7 class:<\/span><\/span><\/h2>\n<ul>\n<li>Study for Exam 1 (2 hour estimate)<span style=\"font-size: 16px;color: #000000\">.<\/span><\/li>\n<\/ul>\n<h2>In Class (February 7):<\/h2>\n<ul>\n<li><strong><span style=\"color: #ff00ff\">Exam 1<\/span><\/strong><\/li>\n<\/ul>\n<h2 style=\"color: #000000\">To Do BEFORE February 9 class:<\/h2>\n<h2>In Class (February 9):<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/spring-2017-project-kickoff-details\/\">Meet team members and\u00a0start project topic discussions<\/a><\/li>\n<\/ul>\n<h2>To Do after February 9 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday,\u00a0February 11 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 6<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Constraints<\/span><\/li>\n<li><span style=\"color: #ff0000\">Referential Integrity<\/span><\/li>\n<li><span style=\"color: #ff0000\">Triggers<\/span><\/li>\n<li><span style=\"color: #ff0000\">Project topic specification<br \/>\n<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE February 14 class:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/constraints-and-triggers-tasks-1\/\">Constraints and Triggers Tasks 1<\/a>\u00a0(2 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 7 SQL on Blackboard<\/span><\/strong><\/li>\n<li>Read and start<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-1-project-functional-specifications\/\"><span style=\"color: #000000\">\u00a0Group Project Deliverable GPD1<\/span>\u00a0<\/a>(due on Friday, Feb 17), requires about 2 hours<\/li>\n<li>Read through\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Exam-1-2017-KEY-and-Rubric.pdf\">Exam 1 Key and Rubric<\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">In Class (February 14):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/constraints-and-triggers-exercises-1\/\">Constraints and Triggers Exercises 1<\/a><\/li>\n<li>Discuss GPD1<\/li>\n<li>Get exam 1 back at end of class<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE February 16 class:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/constraints-and-triggers-tasks-2\/\">Constraints and Triggers Tasks 2<\/a>\u00a0(2 hours)<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">In Class (February 16):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/constraints-and-triggers-exercises-2\/\">Constraints and Triggers Exercises 2<\/a><\/li>\n<\/ul>\n<h2>To Do after February 16 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Quiz 8 SQL on Blackboard by Friday, February 17 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #008000\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-1-project-functional-specifications\/\">Group\u00a0Project Deliverable GPD1<\/a>\u00a0on Blackboard by Friday, February 17 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday,\u00a0February 18 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 7<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Unified Modeling Language<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE Feb 21:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a style=\"color: #000000\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-tasks-1\/\">UML Tasks 1<\/a>\u00a0(3 hours)<\/span><\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 9 UML on Blackboard<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">In Class (February 21):<\/span><\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-exercises-1\/\">UML Exercises 1<\/a><br \/>\n<\/span><\/li>\n<li><strong>Do NOT use abbreviations or assume defaults on multiplicity (aka cardinality) constraints on your UML diagrams\u00a0<\/strong>(for this course)<\/li>\n<li>Finding feedback on Blackboard quizzes (discuss\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Q8-SQL-KEY.pdf\">Quiz 8 SQL key<\/a>\u00a0and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Q9-UML-Key.pdf\">Quiz 9 UML quiz key<\/a>).<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE Feb 23:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-tasks-2\/\">UML Tasks 2<\/a>\u00a0(1 hour)<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">In Class (February 23):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-exercises-2\/\"><span style=\"color: #000000\">\u00a0<\/span><\/a><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-exercises-2\/\">UML Exercises 2<\/a><\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/02\/Exam-2-Study-Guide.pdf\">Exam 2 Study Guide<\/a><\/li>\n<\/ul>\n<h2>To Do after February 23 class:<\/h2>\n<ul>\n<li>Read and start<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-uml-deliverable\/\"><span style=\"color: #000000\">\u00a0Group Project Deliverable GDP2<\/span><\/a>\u00a0(due on Friday, March 3, intermediate draft due Wednesday March 1), estimate 3 hours this week<\/li>\n<li>Read individual\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/individual-assessments-of-group-project-dynamics\/\">Assignment 5<\/a>\u00a0(due on Saturday, March 4, at 11:59 pm)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 10 UML on Blackboard by Friday, February 24 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday,\u00a0February 25 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 8<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Review<br \/>\n<\/span><\/li>\n<li><span style=\"color: #ff0000\">Project UML<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE February 28 class:<\/h2>\n<ul>\n<li>Study for Exam 2 (estimate 3 hours)<\/li>\n<li>Continue\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-uml-deliverable\/\"><span style=\"color: #000000\">Group Project Deliverable GPD2<\/span><\/a>\u00a0(draft due on March 1; final due on Friday, March 3), estimate 2 hours this week, five hours total<\/li>\n<li>Continue individual\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/individual-assessments-of-group-project-dynamics\/\">Assignment 5<\/a>\u00a0(due Saturday, March 4)<\/li>\n<\/ul>\n<h2>In Class (February 28):<\/h2>\n<ul>\n<li><strong><span style=\"color: #ff00ff\">Exam 2\u00a0<\/span><\/strong>(Tuesday, 8:10 am only)<strong><span style=\"color: #ff00ff\"><br \/>\n<\/span><\/strong><\/li>\n<\/ul>\n<h2>To Do BEFORE March 2:<\/h2>\n<ul>\n<li><strong><span style=\"color: #008000\">Submit draft UML designs (part of\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-uml-deliverable\/\">GPD2<\/a>) on Blackboard by Wednesday, March 1 at 9:00 pm<\/span><\/strong><\/li>\n<\/ul>\n<h2>In Class (March 2):<\/h2>\n<ul>\n<li>Peer and instructor UML reviews (NO WEDNESDAY AFTERNOON MEETING)<\/li>\n<li>Pass back Exam 2 at end of class (see\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/Exam-2-2017-KEY-and-Rubric.pdf\">Key and rubric<\/a>)<\/li>\n<\/ul>\n<h2>To Do after March 2 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #008000\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-uml-deliverable\/\">Group\u00a0Project Deliverable GPD2<\/a>\u00a0on Blackboard by Friday, March 3 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit individual\u00a0<a style=\"color: #0000ff\" href=\"http:\/\/Submit Group Project Deliverable GPD2 on Blackboard by Friday, March 3 at 11:59 pm\">Assignment 5<\/a>\u00a0on Blackboard by Saturday, March 4 at 11:59 pm<\/span><\/strong><\/li>\n<li>Read and start\u00a0<span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-table-definitions\/\">Group\u00a0Project Deliverable GPD<\/a>3<\/span>\u00a0(due on Friday, March 24), estimate 1 hour this week<\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #000000\"><span style=\"color: #ff0000\">WEEK 9<\/span>\u00a0Spring break (March 4 &#8211; March 12 )<\/span><\/h1>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 10<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Views<\/span>\n<ul>\n<li><span style=\"color: #ff0000\">Modification with Triggers<\/span><\/li>\n<li><span style=\"color: #ff0000\">Automatic View Modification<\/span><\/li>\n<li><span style=\"color: #ff0000\">Materialized Views<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #ff0000\">Project table definitions (and UML)<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE March 14:<\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/views-tasks-1\/\">Views Tasks 1<\/a>\u00a0(1 hour)<\/span><\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 11 Views on Blackboard<\/span><\/strong><\/li>\n<li>Continue\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-table-definitions\/\"><span style=\"color: #000000\">Group<\/span>\u00a0Project Deliverable GPD3<\/a>\u00a0(due on Friday, March 24), estimate 2 hours this week<\/li>\n<\/ul>\n<h2>In Class (Tuesday, March 14):<\/h2>\n<ul>\n<li>Review\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/post-break-emails\/\">recent emails<\/a><\/li>\n<li>Review\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-table-definitions\/\"><span style=\"color: #000000\">Group<\/span>\u00a0Project Deliverable GPD3<\/a>\u00a0(due on Friday, March 24), estimate 2 hours this week<\/li>\n<li><span style=\"color: #000000\">Views exercises (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/ViewsBooksExercise.pdf\">Exercises\u00a0<\/a>and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2015\/03\/Books.UML_.abbreviatedstandard.withConstraints.pdf\">accompanying handout<\/a>)<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE March 16:<\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/views-tasks-2\/\">Views Tasks 2<\/a>\u00a0(1 hour)<\/span><\/li>\n<\/ul>\n<h2>In Class (March 16):<\/h2>\n<ul>\n<li>Finish views exercises (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/ViewsBooksExercise.pdf\">Exercises\u00a0<\/a>and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2015\/03\/Books.UML_.abbreviatedstandard.withConstraints.pdf\">accompanying handout<\/a>)<\/li>\n<li>Design issues, including &#8220;circularity&#8221; (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/InClassDesignFlaw.pdf\">Worksheet and key<\/a>)<\/li>\n<li>Interrogating the\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/Purchasinghistoryexercise.pdf\">supported functionality of a design<\/a>.<\/li>\n<\/ul>\n<h2>To Do after March 16 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Quiz 12 on Views and Design on Blackboard by Friday, March 17 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, March 18 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 11<\/span><\/h1>\n<p><span style=\"color: #ff0000;font-size: 1.8em\">Week&#8217;s Topics:<\/span><\/p>\n<ul>\n<li><span style=\"color: #ff0000\">Relational Design<\/span>\n<ul>\n<li><span style=\"color: #ff0000\">Functional Dependencies<\/span><\/li>\n<li><span style=\"color: #ff0000\">Boyce Codd Normal Form<\/span><\/li>\n<li><span style=\"color: #ff0000\">Relational decomposition<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #ff0000\">Project Queries<\/span><\/li>\n<\/ul>\n<h2 style=\"color: #ff0000\"><span style=\"color: #000000\">To Do BEFORE March 21:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #000000\"><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-tasks-1\/\">Relational Design Tasks 1<\/a>\u00a0(2 hours)<\/span><\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 13 RD on Blackboard<\/span><\/strong><\/li>\n<li>Continue\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-table-definitions\/\"><span style=\"color: #000000\">Group<\/span>\u00a0Project Deliverable GPD3<\/a>\u00a0(due on Friday, March 24), estimate 2 hours this week<\/li>\n<\/ul>\n<h2>In Class (March 21):<\/h2>\n<ul>\n<li>Review\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-table-definitions\/\"><span style=\"color: #000000\">Group<\/span>\u00a0Project Deliverable GPD3<\/a>\u00a0(due on Friday, March 24), estimate 2 hours this week<\/li>\n<li><span style=\"color: #000000\">Review GDP4\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/FinalProjectDeliverables20171.pdf\">final design and implementation documents<\/a>\u00a0by Saturday, April 8 at 11:59 pm on Blackboard<\/span><\/li>\n<li>Review\u00a0implementation resources:\u00a0<a href=\"https:\/\/www.sqlite.org\">https:\/\/www.sqlite.org\u00a0<\/a>and\u00a0<a href=\"https:\/\/www.sqlite.org\/docs.html\">https:\/\/www.sqlite.org\/docs.html<\/a><\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/Quiz-13-S17-RA-key.pdf\">Quiz 13 Relational Design key<\/a><\/li>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-exercises-1\/\">Relational Design Exercises 1<\/a><\/li>\n<\/ul>\n<h2>To Do BEFORE March 23:<\/h2>\n<h2>In Class (March 23):<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-exercises-2\/\">Relational design Exercises 2<\/a><\/li>\n<\/ul>\n<h2>To Do after March 23 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Quiz 14 RD on Blackboard by\u00a0<del>Friday, March 24<\/del>\u00a0Saturday, March 25 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #008000\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-table-definitions\/\">Group Project Deliverable GPD3<\/a>\u00a0on Blackboard by Friday, March 24 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit individual\u00a0<a style=\"color: #0000ff\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/individual-assessments-of-group-project-dynamics\/\">Assignment 6<\/a>\u00a0on Blackboard by Saturday, March 25 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, March 25 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 12<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Introduction to Indexes<\/span><\/li>\n<li><span style=\"color: #ff0000\">Exam<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE March 28:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/indexing-tasks\/\">Indexing Tasks<\/a><\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz 15 Indexes on Blackboard<\/span><\/strong><\/li>\n<\/ul>\n<h2>In Class (March 28)<span style=\"color: #000000\">:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/Key-for-S17-Quiz-14-RD.pdf\">Quiz 14 RA key<\/a><\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2015\/03\/InClassIndexing.pdf\">Index Implementation Exercises<\/a>\u00a0(<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2015\/03\/InClassIndexingKey.pdf\">Key<\/a>)<\/li>\n<li>Query evaluation and optimization (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/QueryEval1.pdf\">1<\/a>\u00a0and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/QueryEval2.pdf\">2<\/a>)<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE March 30:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/study-guide-for-exam-3\/\">Study Guide for Exam 3<\/a><\/li>\n<\/ul>\n<h2>In Class (March 30)<span style=\"color: #000000\">:<\/span><\/h2>\n<ul>\n<li><strong><span style=\"color: #ff00ff\">Exam 3\u00a0<\/span><\/strong><span style=\"color: #ff00ff\"><span style=\"color: #000000\"><br \/>\n<\/span><\/span><\/li>\n<\/ul>\n<h2>To Do after March 30 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, April 1 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<li>No end-of-week quiz<\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/04\/Exam3.S17.key_.pdf\">Exam 3 Key and rubric<\/a><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #000000\">WEEK 13<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Group projects<\/span><\/li>\n<li><span style=\"color: #ff0000\">Introduction to Transactions<\/span><\/li>\n<li><span style=\"color: #ff0000\">Isolation Levels<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE April 4 class:<\/h2>\n<ul>\n<li>Work in groups on final project deliverables<\/li>\n<\/ul>\n<h2><del>In Class (April 4):<\/del><\/h2>\n<ul>\n<li>No Class &#8212; work in groups<\/li>\n<\/ul>\n<h2>To Do BEFORE April 6 class:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/transactions-tasks\/\">Transaction Tasks<\/a><\/li>\n<li><strong><del>Quiz 16 Transactions on Blackboard<\/del>\u00a0<\/strong>(I didn&#8217;t put up &#8212; everyone gets 3 points)<\/li>\n<\/ul>\n<h2>In Class (April 6)<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/transactions-exercises\/\">Transaction Exercises<\/a><\/li>\n<\/ul>\n<h2>To Do after April 6 class:<\/h2>\n<ul>\n<li>No end-of-week quiz<\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, April 8 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #339966\">Submit GDP4\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/FinalProjectDeliverables20171.pdf\">final design and implementation documents<\/a>\u00a0by Saturday, April 8 at 11:59 pm on Blackboard<\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 14<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Projects and Presentations<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE April 11:<\/h2>\n<h2>In Class (April 11):<\/h2>\n<ul>\n<li>Project Presentations<\/li>\n<\/ul>\n<h2>To Do BEFORE April 13:<\/h2>\n<h2>IN Class (April 13):<\/h2>\n<ul>\n<li>Project Presentations<\/li>\n<\/ul>\n<h2>To Do After April 13 Class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #008000\"><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/FinalProjectDeliverables20171.pdf\">Submit Video presentation<\/a>\u00a0summarizing the project by Friday, April 14 at 11:59 pm (public or private link).\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/03\/FinalProjectDeliverables20171.pdf\">Submit affirmation and release form as well.<\/a><\/span><\/strong><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 15<\/span><\/h1>\n<p><span style=\"color: #0000ff\">All week: meetings by appointment<\/span><\/p>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Final Exam<\/span><\/li>\n<li>Course Evaluations<\/li>\n<\/ul>\n<h2>To Do BEFORE April 18 class:<\/h2>\n<ul>\n<li>Study<\/li>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/final-exam-study-guide\/\">Final Exam Study Guide<\/a><\/li>\n<\/ul>\n<h2>In Class (April 18):<\/h2>\n<ul>\n<li><strong><span style=\"color: #ff00ff\">Final Exam part 1<\/span><\/strong><\/li>\n<\/ul>\n<h2>To Do BEFORE April 20 class:<\/h2>\n<ul>\n<li>Study (and look over\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/04\/FinalExam.Part1_.Key_.pdf\">Final Exam Part 1 key and rubric<\/a>) Email Doug with questions<\/li>\n<\/ul>\n<h2>In Class (April 20):<\/h2>\n<ul>\n<li><strong><span style=\"color: #ff00ff\">Final Exam part 2\u00a0<\/span><\/strong><span style=\"color: #000000\">(first 60 minutes of class)<\/span><\/li>\n<li>Course evaluations (last 15 minutes of class)<\/li>\n<\/ul>\n<p>Posted April 22:\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/04\/FinalExam.Part2_.Key_.pdf\">Final Exam Part 2 and Extra Credit Key and rubric<\/a><\/p>\n<h1><span style=\"color: #000000\">Classes End (Monday, April 24)<\/span><\/h1>\n<h1><span style=\"color: #000000\">Reading Day (Tuesday, April 25, 2016)<\/span><\/h1>\n<p><del><strong><span style=\"color: #0000ff\"><span style=\"color: #000000\">Thursday, May 4, 2017; 9:00 AM &#8211; 12:00 Noon:<\/span>\u00a0<span style=\"color: #ff00ff\">FINAL EXAM http:\/\/registrar.vanderbilt.edu\/cms\/wp-content\/Spring-2017-exam-schedule.pdf\u00a0<\/span><\/span><\/strong><\/del><span style=\"color: #000000\"><strong>(all work, including final exam, has been completed)<\/strong><\/span><del><strong><span style=\"color: #0000ff\"><span style=\"color: #ff00ff\"><br \/>\n<\/span><\/span><\/strong><\/del><\/p>\n<p><strong>OPTIONAL MATERIAL<\/strong>\u00a0(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).<\/p>\n<p>DB2 XML<\/p>\n<ul>\n<li>Watch videos (45 min) and answer questions from DB2 XML Data (https:\/\/class.stanford.edu\/courses\/DB\/XML\/SelfPaced\/courseware\/ch-xml_data\/)\n<ul>\n<li>Well-formed XML (9:35 + 3:44)<\/li>\n<li>DTDs, IDs, and IDREFs (18:01)<\/li>\n<li>XML Schema (13:09);<\/li>\n<\/ul>\n<\/li>\n<li>Do XML Quiz<\/li>\n<li>Do DTD Exercises from DB2<\/li>\n<li>Complete DB2 XML Data mini course (OPTIONAL! Will not count towards CS 265 grade)<\/li>\n<\/ul>\n<p>DB3 JSON<\/p>\n<ul>\n<li>Watch videos (40 min) and answer questions from DB3 JSON Data (https:\/\/class.stanford.edu\/courses\/DB\/JSON\/SelfPaced\/courseware\/ch-json_data\/)\n<ul>\n<li>Introduction to JSON Data (7:30 + 6:43)<\/li>\n<li>JSON Demo (22:17)<\/li>\n<\/ul>\n<\/li>\n<li>Do JSON Quiz<\/li>\n<li>Complete DB3 JSON Data mini course (OPTIONAL! Will not count towards CS 265 grade)<\/li>\n<\/ul>\n<p>DB6 XPATH and XQUERY<\/p>\n<ul>\n<li>Watch videos (60 min) from DB6 XPath and XQuery\n<ul>\n<li>XPath Introduction (9:50)<\/li>\n<li>XPath Demo (22:16)<\/li>\n<li>XQuery Introduction (5:13)<\/li>\n<li>XQuery Demo (16:20)<\/li>\n<\/ul>\n<\/li>\n<li>Do XML Course-Catalog XPath and XQuery Exercises<\/li>\n<li>Do XML World-Countries XPath and XQuery Exercises<\/li>\n<li>Complete DB6 XPath and XQuery mini course (OPTIONAL! Will not count towards CS 265 grade)<\/li>\n<\/ul>\n<p>DB7 XSLT<\/p>\n<ul>\n<li>Watch videos ( min) from DB7 XSLT (OPTIONAL!)\n<ul>\n<li>XSLT (22:14)<\/li>\n<\/ul>\n<\/li>\n<li>Do XML Course-Catalog XSLT exercises<\/li>\n<li>Do XML World Countries XSLT exercises<\/li>\n<li>Complete DB7 XSLT mini course\u00a0(OPTIONAL! Will not count towards CS 265 grade)<\/li>\n<\/ul>\n<p>Complete DB8 Relational Design Theory<\/p>\n<ul>\n<li>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\/)\n<ul>\n<li>Multivalued Dependencies (6:24 + 4:26 + 11:30 + 1:23)<\/li>\n<\/ul>\n<\/li>\n<li>Do the Multivalued Dependencies Quiz from DB8Relational Design Theory (https:\/\/class.stanford.edu\/courses\/DB\/RD\/SelfPaced\/courseware\/ch-relational_design_theory\/)<\/li>\n<li>Complete the Normalization Quiz from DB8 Relational Design Theory (https:\/\/class.stanford.edu\/courses\/DB\/RD\/SelfPaced\/courseware\/ch-relational_design_theory\/)<\/li>\n<\/ul>\n<p>Complete DB12 Views and Authorization<\/p>\n<ul>\n<li>Watch remaining videos (60 min) and answer questions from DB12 Views and Authorization (<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/Views\/SelfPaced\/courseware\/ch-views\/\">https:\/\/class.stanford.edu\/courses\/DB\/Views\/SelfPaced\/courseware\/ch-views\/<\/a>) and answer questions from DB12 Views and Authorization modules\n<ul>\n<li>Authorizations (3:24 + 1:50 + 4:10 + 1:35)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>DB13 Online-Analytical Processing<\/p>\n<ul>\n<li>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\/)\n<ul>\n<li>Introduction to OLAP (14:22 + 3:46)<\/li>\n<li>OLAP Demo (26:46)<\/li>\n<\/ul>\n<\/li>\n<li>Do OLAP Quiz<\/li>\n<li>Complete DB13 Online Analytical Processing mini course (OPTIONAL! Will not count towards CS 265 grade)<\/li>\n<\/ul>\n<p>DB14 Recursion in SQL<\/p>\n<ul>\n<li>Watch videos (63 min ) from DB14 Recursion in SQL\u00a0(OPTIONAL!)\n<ul>\n<li>Basic Recursive WITH Statement &#8211; Introduction (11:54)<\/li>\n<li>Basic Recursive WITH Statement Demo (30:06)<\/li>\n<li>Non-linear and Mutual Recursion (8:05 + 13:00)<\/li>\n<\/ul>\n<\/li>\n<li>Do Recursion Quiz\u00a0(OPTIONAL!)<\/li>\n<li>Complete DB14 Recursion in SQL mini course\u00a0(OPTIONAL! Will not count towards CS 265 grade)<\/li>\n<\/ul>\n<p><span style=\"color: #000000\"><br \/>\n<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;s Topics: \u00a0Course Overview \u00a0Sample DB problem and IEEE Code &hellip; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/schedules17\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":633,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1911","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/users\/633"}],"replies":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/comments?post=1911"}],"version-history":[{"count":2,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1911\/revisions"}],"predecessor-version":[{"id":1913,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1911\/revisions\/1913"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=1911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}