{"id":18,"date":"2012-11-02T19:50:45","date_gmt":"2012-11-03T00:50:45","guid":{"rendered":"https:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=18"},"modified":"2020-09-17T15:52:14","modified_gmt":"2020-09-17T20:52:14","slug":"database-schedule","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/database-schedule\/","title":{"rendered":"Schedule"},"content":{"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.<\/p>\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<\/span><span style=\"color: #ff0000\"><br \/>\n<\/span><\/li>\n<li><span style=\"color: #ff0000\">\u00a0Relational DBs and Relational Algebra<\/span><\/li>\n<li>\u00a0<span style=\"color: #ff0000\">An Example DB<\/span>: Sometime this week, start <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-2-s18\/\">Assignment A-w2<\/a> (do task 1 by reading the paper) (2 hours)<\/li>\n<\/ul>\n<h2>To Do before January 9 class:<\/h2>\n<ul>\n<li>NA<\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (Tuesday, January 9 ):<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 <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/course-organization\/\">Organization<\/a>.<br \/>\n<\/span><\/li>\n<li>Start <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/hans-rosling-in-class-exercises\/\">Hans Rosling Exercise<\/a><\/li>\n<li><a href=\"https:\/\/youtu.be\/H5C2ruKtrk4\">Recorded lecture<\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do before January 11 class: <\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introduction-to-relational-models-s18\/\"><span style=\"color: #000000\">Introduction to relational models<\/span><\/a>\u00a0<span style=\"color: #000000\">(2.5 hours)<\/span><\/li>\n<\/ul>\n<h2>Class meeting (Thursday, January 11 )<span style=\"color: #000000\">:<br \/>\n<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-algebra-in-class\/\">Relational Algebra In Class<\/a><\/li>\n<li><a href=\"https:\/\/youtu.be\/cWHXuLozvF0\">Recorded lecture<\/a> (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/RAlecture.pdf\">lecture slides<\/a>)<\/li>\n<\/ul>\n<h2>To Do after January 11 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a1-s18\/\">Assignment A-w1<\/a>\u00a0by Saturday, January 13 at 11:59 pm <\/span><\/strong>(2 hours)<\/li>\n<li>Reminder:\u00a0start\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-2-s18\/\">Assignment A-w2<\/a>\u00a0(by reading the paper)<\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, January 13 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\">\u00a0SQL Basics<\/span><\/li>\n<li><span style=\"color: #ff0000\">\u00a0An example DB in context<\/span><\/li>\n<\/ul>\n<h2>To Do before January 16 class:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introduction-to-sql\/\">Introduction to SQL Tasks<\/a>\u00a0(3 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz Q-w2 on Brightspace<br \/>\n<\/span><\/strong><\/li>\n<\/ul>\n<h2>Class meeting (Jan 16):<\/h2>\n<ul>\n<li>Discuss Assignment A-w1 (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/Assignment-A-w1-RA-KEY.pdf\">A-w1 Key<\/a>; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a-w1-ra-self-marked\/\">A-w1 self mark form<\/a>)<\/li>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/sql-a-w1-exercises\/\">A-w1 in SQL exercises<\/a>\u00a0(<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/SQL-A-w1-exercises-KEY.pdf\">Key<\/a>)<\/li>\n<li>A <a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/01\/BooksTablesAbbreviatedWithoutConstraints.pdf\">simple online retailer DB<\/a><\/li>\n<li><a href=\"https:\/\/youtu.be\/-cVBVO0OwLQ\">Recorded lecture<\/a><\/li>\n<\/ul>\n<h2>To Do before Jan 18 class:<\/h2>\n<h2 style=\"color: #0000ff\"><span style=\"color: #000000\">Class meeting (Jan 18):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introductory-sql-exercises-2\/\">Introduction to SQL Exercises 2<\/a>\u00a0(no recorded lecture, but see selected solutions to exercises in class at the bottom)<\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/Q-w2-SQL-Key.pdf\">Quiz Q-w2 key<\/a>\u00a0(also covered in class)<\/li>\n<\/ul>\n<h2>To Do after Jan 18 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a style=\"color: #0000ff\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-2-s18\/\">Assignment A-w2<\/a> on Brightspace by Saturday, January 20 at 11:59 pm <\/span><\/strong>(2 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, January 20 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\">Intermediate SQL<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE January 23 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 Q-w3 (on Brightspace)<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (January 23): <\/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 Assignment A-w2 (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/Grading-rubric-for-Assignment-A-w2.pdf\">rubric<\/a>)<\/li>\n<li>Discuss Quiz Q-w3<\/li>\n<\/ul>\n<h2 style=\"color: #000000\">To Do BEFORE January 25 class:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-tasks-2\/\">Intermediate SQL Tasks 2<\/a>\u00a0(2 hours)<\/li>\n<\/ul>\n<h2>Class meeting (January 25):<\/h2>\n<ul>\n<li>Discuss Assignment A-w2 (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/Grading-rubric-for-Assignment-A-w2.pdf\">rubric<\/a>)<\/li>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-exercises-2\/\">Intermediate SQL exercises 2<\/a><\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/GroupHavingIllustration.pdf\">GROUP BY and HAVING illustration<\/a><\/li>\n<li>Sample DBs on\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/01\/DormEnergyTablesWithoutConstraintsandQueries.pdf\">Dorm Energy Monitoring<\/a>\u00a0and\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2017\/01\/BooksTablesAbbreviatedWithoutConstraints.pdf\">Online Retailer<\/a><\/li>\n<li><a href=\"https:\/\/youtu.be\/Leyxs4JjgGQ\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2>To Do after Jan 25 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/human-centered-design-s18\/\">Assignment A-w3<\/a>\u00a0on Brightspace by Saturday, January 27 at 11:59 pm <\/span><\/strong><span style=\"color: #000000\">(2 hours)<\/span><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, January 27 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\">Constraints<\/span><\/li>\n<li><span style=\"color: #ff0000\">Referential Integrity<\/span><\/li>\n<li><span style=\"color: #ff0000\">Triggers<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE January 30 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 Q-w4 on Brightspace<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">Class meeting (January 30): <\/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 Quiz Q-w4 (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/Quiz-Q-w4-key.pdf\">key<\/a>)<\/li>\n<li>Discuss <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/human-centered-design-s18\/\">Assignment A-w3<\/a> (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/01\/Assignment-Aw3-2018-rubric.pdf\">rubric<\/a>)<\/li>\n<li><a href=\"https:\/\/youtu.be\/wmLOv5xvMA8\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE February 1 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\"> Class meeting (February 1):<\/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 1 class:<\/h2>\n<ul>\n<li>Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignmenta-w4-2\/\">Assignment A-w4\u00a0<\/a>on Brightspace by Saturday, February 3 at 11:59 pm (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/02\/AssignmentA-w4Key.pdf\">Key and query questions<\/a>;\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/02\/AssignmentA-w4QueriesKey.pdf\">possible answers to query questions<\/a>, also In Class February 20)<\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, February 3 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\">Database Conceptual Design<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #ff0000\"><span style=\"color: #000000\">To Do BEFORE February 6 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 6):<\/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 8 class:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/dream-db-description\/\">Dream DB description<\/a> (due Tuesday, Feb 6 at 11:59 PM)<\/li>\n<\/ul>\n<h2>In Class (February 8):<\/h2>\n<ul>\n<li><span style=\"color: #008000\">Group intros and schedule meetings (submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-initial-meetings\/\">individual descriptions of meeting<\/a> before 9:30 am)<\/span><\/li>\n<li>Hand back Exam 1<\/li>\n<\/ul>\n<h2>To Do after February 8 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday,\u00a0February 10 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<li><del>Submit Assignment A-w5\u00a0on Brightspace by Saturday, February 3 at 11:59 pm<\/del><\/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\">Unified Modeling Language<\/span><span style=\"color: #ff0000\"><br \/>\n<\/span><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE February 13 class: <\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-tasks-1\/\">UML Tasks 1<\/a><\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz Q-w6 on Brightspace<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">In Class (February 13):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-exercises-1\/\">UML Exercises 1<\/a><\/li>\n<li>Discuss Quiz Q-w6<\/li>\n<li><a href=\"https:\/\/youtu.be\/VY1cYS9xYT0\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE February 15 class:<\/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 15):<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/uml-exercises-2\/\">UML Exercises 2<\/a><\/li>\n<li><a href=\"https:\/\/youtu.be\/UZ322DfHAng\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2>To Do after February 15 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #008000\">Submit\u00a0<a style=\"color: #008000\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-assignment-1-project-functional-specifications\/\">Group\u00a0Project Deliverable GPD1<\/a>\u00a0on Brightspace by Friday, February 16 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a-w6-on-uml\/\">Assignment A-w6<\/a>\u00a0on Brightspace by Saturday, February 17 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday,\u00a0February 17 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<li><span style=\"color: #008000\">Optional Project Group Meetings on Sunday February 18<\/span><\/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\">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<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE Feb 20:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/views-tasks-1\/\">Views Task 1<\/a>\u00a0(1.5 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\">Quiz Q-w7 on Brightspace<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">In Class (February 20):<\/span><\/h2>\n<ul>\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\/2018\/02\/Books-views-exerciseS18.pdf\">accompanying handout<\/a>)<\/span><\/li>\n<li>Discuss <a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/02\/Assignment-A-w6-key.pdf\">Assignment A-w6<\/a><\/li>\n<li>Discuss <a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/02\/AssignmentA-w4QueriesKey.pdf\">Queries from DormEnergy database<\/a>\u00a0(answers to query exercises given at end of <a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/02\/AssignmentA-w4Key.pdf\">assignment A-w4 key<\/a>\u00a0at end of Week 4)<\/li>\n<li>Pointer to <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-final-design\/\">Final Group Project specification<\/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<li><a href=\"https:\/\/www.youtube.com\/watch?v=VE5vg8MXDbg\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE Feb 22:<\/span><\/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><span style=\"color: #000000\"><del>In Class<\/del> (February 22): <\/span><\/h2>\n<ul>\n<li>No class, but <a href=\"https:\/\/youtu.be\/VvAXEEl9HDw\">recorded lecture<\/a> available on\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>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<li>Discuss\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-final-design\/\">Final Group Project specification<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Review\u00a0implementation resources &#8212; see TAs during office hours if you have difficulty downloading\u00a0\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<\/ul>\n<h2>To Do after February 22 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #008000\">Submit <a style=\"color: #008000\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-uml-deliverable\/\">Group Project UMLs<\/a> on Brightspace by Friday, February 23 at 11:59 pm<\/span><\/strong><\/li>\n<li><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/individual-assessment-of-group\/\">Assignment A-w7 <\/a>on Brightspace by Saturday, February 24 at 11:59 pm (This is simply an individual update on how you think your group is interacting)<\/span><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday,\u00a0February 24 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\">Project<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE February 27 class:<\/h2>\n<ul>\n<li><span style=\"color: #008000\">Work on Group Project<\/span><\/li>\n<\/ul>\n<h2>In Class (February 27):<\/h2>\n<ul>\n<li><span style=\"color: #008000\">No lecture, but Doug available for Project Group consultations<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE March 1:<\/h2>\n<ul>\n<li><span style=\"color: #008000\">Work on Group Project<\/span><\/li>\n<\/ul>\n<h2>In Class (March 1):<\/h2>\n<ul>\n<li><span style=\"color: #008000\">No lecture, but Doug available for\u00a0Project Group consultations<\/span><\/li>\n<\/ul>\n<h2>To Do after March 1 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #008000\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/group-project-final-design\/\">Final Group Project<\/a> on Brightspace by Friday, March 2 at 6:00 pm<\/span><\/strong><\/li>\n<li><del>Submit Data Diary<\/del> (no)<\/li>\n<li><span style=\"color: #008000\">Enjoy break<\/span><\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #000000\"><span style=\"color: #ff0000\">WEEK 9<\/span> Spring break (March 3 &#8211; March 11 )<\/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>Relational Design\n<ul>\n<li>Functional Dependencies<\/li>\n<li>Boyce Codd Normal Form<\/li>\n<li>Relational decomposition<\/li>\n<\/ul>\n<\/li>\n<li>Project Queries<\/li>\n<\/ul>\n<h2>To Do BEFORE March 13:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-tasks-1\/\">Relational Design Tasks 1<\/a>\u00a0(2 hours)<\/li>\n<li><strong><span style=\"color: #0000ff\"><del>Quiz Q-w10 on Brightspace<\/del> (Due Thursday before class)<\/span><\/strong><\/li>\n<\/ul>\n<h2><del>In Class<\/del> (Tuesday, March 13):<\/h2>\n<ul>\n<li><span style=\"color: #000000\">No class (Doug at NSF), but watch Doug&#8217;s\u00a0<a href=\"https:\/\/youtu.be\/FtaEwHmJs1Y\">prerecorded lecture<\/a> (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/03\/Functional-Dependency-initialS18.pdf\">slides only<\/a>)<\/span><\/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 15 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Quiz Q-w10 on Brightspace<\/span><\/strong><\/li>\n<\/ul>\n<h2>In Class (March 15):<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/relational-design-exercises-2\/\">Relational Design Exercises 2<\/a><\/li>\n<li>Discuss Quiz Q-w10<\/li>\n<li><a href=\"https:\/\/youtu.be\/pIrRfBLbPpM\">Recorded Lecture<\/a>\u00a0(<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/03\/Functional-Dependency-secondS18.pdf\">slides only<\/a>)<\/li>\n<\/ul>\n<h2>To Do after March 15 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a-w10\/\">Assignment A-w10<\/a> on Brightspace <del>by Saturday, March 17 at 11:59 pm<\/del> Tuesday, March 20 in class or on Brightspace by 8:10 am<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, March 17 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\">Introduction to Indexes<\/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 style=\"color: #ff0000\"><span style=\"color: #000000\">To Do BEFORE March 20:<\/span><\/h2>\n<ul>\n<li><del><strong><span style=\"color: #0000ff\">Quiz Q-w11 Indexes on Brightspace<\/span><\/strong><\/del><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit\u00a0<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a-w10\/\">Assignment A-w10<\/a>\u00a0on Brightspace\u00a0<del>by Saturday, March 17 at 11:59 pm<\/del>\u00a0Tuesday, March 20 in class or on Brightspace by 8:10 am<\/span><\/strong><\/li>\n<\/ul>\n<h2>In Class (March 20):<\/h2>\n<ul>\n<li>Discuss <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a-w10\/\">Assignment A-w10<\/a>\u00a0(<a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/assignment-a-w10key-2\/\">self-assessment form<\/a>)<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=qJhcUV1CkUQ\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2>To Do BEFORE March 22:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/indexing-tasks\/\">Indexing Tasks<\/a><\/li>\n<\/ul>\n<h2>In Class (March 22):<\/h2>\n<ul>\n<li>Query evaluation and selecting indexes (<a href=\"https:\/\/youtu.be\/CGThtQJ6iV8\">recorded lecture<\/a>) (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/03\/QueryEvaluation.pdf\">slides only<\/a>)<\/li>\n<\/ul>\n<h2>To Do after March 22 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2015\/03\/InClassIndexing.pdf\">Assignment A-w11<\/a>\u00a0as one neatly-formatted PDF on Brightspace by Saturday, March 24 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, March 24 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: #ff00ff\"><strong>Exam<\/strong><\/span><\/li>\n<li>Transactions<\/li>\n<\/ul>\n<h2>To Do BEFORE March 27:<\/h2>\n<p>Study, including\u00a0<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2015\/03\/InClassIndexingKey.pdf\">Key and rubric for A-w11<\/a><\/p>\n<h2>In Class (March 27)<span style=\"color: #000000\">:<\/span><\/h2>\n<ul>\n<li><strong><span style=\"color: #ff00ff\">Exam 2<\/span><\/strong><\/li>\n<\/ul>\n<h2><span style=\"color: #000000\">To Do BEFORE March 29:<\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/transactions-tasks\/\">Transactions Tasks<\/a><\/li>\n<\/ul>\n<h2>In Class (March 29)<span style=\"color: #000000\">:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #000000\">Transactions (<a href=\"https:\/\/youtu.be\/3rFdBm2QmyI\">recorded lecture<\/a>) (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/03\/TransactionsLecture.pdf\">slides only<\/a>)<\/span><\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/03\/TransactionsAppLayerThoughtExercise.pdf\">Transaction example<\/a><\/li>\n<\/ul>\n<h2>To Do after March 29 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/a-w12\/\">Assignment A-w12<\/a> to Brightspace by 11:59 pm on Saturday, March 31 at 11:59 pm<\/span><\/strong><\/li>\n<li><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, March 31 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/li>\n<li><\/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\">Data Mining<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE April 3 class:<\/h2>\n<ul>\n<li><del>Data Mining Tasks<\/del><\/li>\n<li><del>Quiz<\/del><\/li>\n<\/ul>\n<h2>In Class (April 3):<\/h2>\n<ul>\n<li>Data Mining,\u00a0learning functional dependencies (<a href=\"https:\/\/youtu.be\/ZGA_7K6Yums\">recorded lecture<\/a>) (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/04\/LearningFDs.pdf\">slides only<\/a>)<\/li>\n<\/ul>\n<h2>To Do BEFORE April 5 class:<\/h2>\n<ul>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/data-mining-tasks-1\/\">Data Mining Tasks<\/a><\/li>\n<\/ul>\n<h2>In Class (April 5)<\/h2>\n<ul>\n<li>Discuss <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/data-mining-programming-assignment\/\">Individual Project Specification<\/a><\/li>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/04\/IndividualProjectThoughts.pdf\">Individual Project Thoughts<\/a><\/li>\n<li>Discuss A-w12 (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/04\/A-w12Key.pdf\">Key and rubric<\/a>)<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=oKcCKtwtFrs\">Recorded Lecture<\/a><\/li>\n<\/ul>\n<h2>To Do after April 5 class:<\/h2>\n<ul>\n<li><del><strong><span style=\"color: #0000ff\">Submit Assignment A-w13 to Brightspace by Saturday, April 7 by 11:59 pm<\/span><\/strong><\/del><\/li>\n<li><del><strong><span style=\"color: #0000ff\">Submit Data Diary entries by Saturday, April 7 at 11:59 pm (required for 5265, optional for 3265)<\/span><\/strong><\/del><\/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<h2>To Do BEFORE April 10:<\/h2>\n<ul>\n<li>Work on Individual Project<\/li>\n<\/ul>\n<h2>In Class (April 10):<\/h2>\n<ul>\n<li>Data mining (decision trees) (<a href=\"https:\/\/youtu.be\/xawn4pipWsY\">recorded lecture<\/a>) (<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/04\/DecisionTrees.pdf\">slides only<\/a>)<\/li>\n<\/ul>\n<h2>To Do BEFORE April 12:<\/h2>\n<ul>\n<li>Work on Individual Project<\/li>\n<\/ul>\n<h2>IN Class (April 12):<\/h2>\n<ul>\n<li>Building test sets for project (<a href=\"https:\/\/youtu.be\/W53QV_CxKaA\">recorded lecture<\/a>)(<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/04\/BuildingTestSetsFrorProject.pdf\">slides only<\/a>)<\/li>\n<li><a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/sample-data-for-project\/\">Datasets<\/a><\/li>\n<\/ul>\n<h2>To Do After April 12 Class:<\/h2>\n<ul>\n<li>Work on Individual Project<\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #ff0000\">WEEK 15<\/span><\/h1>\n<h2><span style=\"color: #ff0000\">Week&#8217;s Topics:<\/span><\/h2>\n<ul>\n<li><span style=\"color: #ff0000\">Individual Projects<\/span><\/li>\n<li><span style=\"color: #ff0000\">Data Mining<\/span><\/li>\n<\/ul>\n<h2>To Do BEFORE April 17 class:<\/h2>\n<ul>\n<li><span style=\"color: #0000ff\">Work on Individual Project<\/span><\/li>\n<\/ul>\n<h2>In Class (April 17):<\/h2>\n<ul>\n<li>No class, but consulting on Individual Project in FGH atrium during class time<\/li>\n<\/ul>\n<h2>To Do BEFORE April 19 class:<\/h2>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Submit <a style=\"color: #0000ff\" href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/data-mining-programming-assignment\/\">Individual Project<\/a> to Brightspace\u00a0by Tuesday, April 17 at 11:59 pm<\/span><\/strong><\/li>\n<\/ul>\n<h2>In Class (April 19):<\/h2>\n<ul>\n<li><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2018\/04\/Final-Exam-Study-Guide.pdf\">Final Exam Study Guide<\/a><\/li>\n<li>Course evaluations<\/li>\n<\/ul>\n<h1><span style=\"color: #000000\">Classes End (Monday, April 23)<\/span><\/h1>\n<h1><span style=\"color: #000000\">Reading Day (Tuesday, April 24, 2018)<\/span><\/h1>\n<p><strong><span style=\"color: #ff00ff\">Take home Final Exam due Sunday, April 29<\/span><\/strong><\/p>\n<p><strong>OPTIONAL MATERIAL<\/strong> (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>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>&nbsp;<\/p>\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","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 \u00a0Relational DBs and Relational Algebra \u00a0An &hellip; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/database-schedule\/\">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-18","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/18","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=18"}],"version-history":[{"count":882,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/18\/revisions"}],"predecessor-version":[{"id":2381,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/18\/revisions\/2381"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}