## Lecture Notes

Important: The dates and the assigned readings are tentative until a few days before the actual class so you should make sure you check this site regularly.

td>---
Date Topics Assigned Readings and Participation Activities Lecture Slides Homework
1/21 Course Overview and Introduction to Databases Chapter 15.1-15.5
1. Logistics Slides
2. Database Terminology
3. Lecture (start from 8:40)
---
1/26 The Relational Model Chapter 16.1-16.5
---
1/28, 2/2 SQL: Data Manipulation
1. 1/28: Chapter 15.5, Chapter 18.1-18.4, 18.8-18.9
2. 2/2: Chapter 16.6, 18.6, 18.11
3. w3schools SQL Tutorial. Read all the SQL Basic, play with the SQL demo, and read the following topics in the advanced section:
• SQL Order By
• SQL and & or
• SQL In
• SQL Between
• SQL Join
• SQL Create
4. My SQL Notes
5. Getting Started with Your MySql Database
2/4 SQL: Data Definition Chapter 16.7, 18.5-18.7, 18.10 1) DDL Slides
2) Subquery Slides
3) Lecture 2/4 (starting at 1:45)
4) Lecture 2/9 (start at 1:30)
---
2/9 Relational Algebra and Calculus Handout on Canvas (Only read about the relational algebra and tuple relational calculus. Ignore the domain relational calculus and other languages) 1) Slides
2) Lecture 2/9 (lecture starts at 1:30 and relational algebra start at 29:30)
3) Lecture 2/11 (lecture starts at 13:00)
• hw2 (Due Sat. 2/13 at 6am)
• hw2 supplementary materials-The DreamHome.sql file will create the relations for the Dream Home property man agement firm and can be used with question 8.
2/16, 2/18 Entity-Relationship Modeling
1. Chapter 17.1-17.8
2. Investment Firm Design Case
1) Slides
2) Lecture 2/16 (start at 3:15)
3) Lecture 2/18 (start at 2:30) 4) Investment Firm Solution
hw3 (Due Wed. 2/24 at 6am)
2/23, 2/25 Normalization
1. Chapter 17.9-17.10 and canvas handout
2. Hotel Case Study
1) Slides
2) Lecture 2/23 (start at 2:00) 3) Lecture 2/25 (start at 0:25)
hw4 (Due Wed. 3/3 at 6am)
3/2, 3/4 Physical Database Design
1. 3/2: Ch. 19.1-19.5. 19.7, physical design, and B+-tree handout on Canvas. For B+-tree handout go to Modules and then Course Materials.
2. 3/4: Extendible Hashing handouts on Canvas. Go to Modules and then Course Materials.
3. B+-Tree Visualization
Lecture 3/2 (start at 2:30)
Lecture 3/4 (start at 0:25)
Lecture 3/9 (start at 36:30)
1) hw5 (Due Wed 3/10 at 6am)
2) Database Project for CS565 Students (Due Wed. 3/31 at 6am)
3/9, 3/11 NoSQL and MongoDB
1. 3/9: Ch 7.8, 24.1-24.5
2. 3/11: 24.7
3. General NoSQL notes
4. My Mongo DB notes
5. Kathleen Durant's Mongo DB slides (look at slides 16-42)
1. Lecture 3/9 (start at 1:30)
2. Lecture 3/11 start at 41:00)
hw6 (Due Wed. 3/17 at 6am--No late submissins accepted)
3/16 Introduction to Web Programming and Scripting Languages
• Chapters 1 and 2.1-2.5
• Lecture (start at 56:45)
• Pre-class: All participation activities in Chapter 1 and 2.1-2.5
• In-class: All challenge activities in 2.4-2.5
1) Web project description
2) Video showing web interface interactions
3) Video describing ABET data collection and database relations 4) Web Project 1--Database design (Due Fri. 3/26 at 6am)
3/18 Midterm Exam
3/23 HTML and Forms Chapter 2.6-2.8 and Chapter 3
Lecture 3/23
• Pre-class: All participation activities in Chapter 2.6-2.8 and Chapter 3
• In-class: All challenge activities in 2.6-2.7 and Chapter 3
---
3/25 Basic CSS Ch. 4
Lecture 3/25
• Pre-class: All participation activities in Chapter 4
• In-class: All challenge activities in Chapter 4
---
3/30 Advanced CSS and PhP Introduction Ch 5 and 12.1-12.2
Lecture 3/30
Web Project 2 -- user interface (Due Wed. Apr. 7 at 6am)
4/1 PHP Basics
1. Ch. 12.3-12.10
2. Supplementary Reading: PHP Tutorial-Read the PHP Basics section through PHP functions
3. Supplementary Reading: Introduction to PHP
4. Supplementary Reading: Getting Started in PHP
5. Brad's Cliff Notes Version of PHP
6. Supplementary Reading: Geoff Mazeroff's Cliff Notes Version of PHP
• Pre-class: All participation activities in Chapter 12.3-12.10
• In/After class: Canvas quiz--4-1: PHP Basics
• Lecture 4/1
wordcount
prose.txt
4/6 Handling Forms and Session Management in PHP
1. Ch 12.11, 13.4
• Read the PHP Basics section from PHP Forms to the end
• PHP Sessions
• Pre-class: All participation activities in Chapter 12.11, 13.4
• In/After class: Canvas quiz--4-6: PHP Form Handling
• Lecture 4/6
---
4/8 PHP interface to mySQL and Regular Expressions
1. Ch. 13.1, 13.3, 13.6-13.8
3. Supplementary Reading: my PHP SQL notes
• Pre-class: All participation activities in Chapter 13.1, 13.3, 13.6-13.8
• In/After class: Canvas quiz-3-31: PHP SQL and Regular Expressions
• Lecture 4/8
Web Project 3 -- server side (Due Fri. Apr. 16 at 6am)
Web Project 1 & 2 Explanation
4/13 Introduction to JavaScript Ch. 6--Basic Javascript
• Pre-class: All participation activities in Ch. 6
• After-class: All challenge activities in Ch. 6
• Lecture 4/13
---
4/15 Javascript classes, regular expressions and Javascript in the Browser--HTML DOM, Javascript DOM
1. Javascript regular expressions and classes: Ch. 8.1-8.3
2. The Document Object Model: Ch. 7.1-7.3, 7.6
• Pre-class: All participation activities in Ch. 8.1-8.3, 7.1-7.3, 7.6
• After-class: All challenge activities in Ch. 8.1-8.3, 7.1-7.3, 7.6
• Lecture
Web Project 4--Tying Together the Client and Server Sides (Due Thurs. 4/29 at 6am) and its grading guide.
4/20 Javascript: Interaction with the Browser and the Server--Forms, Events, and AJAX
• Pre-class: All participation activities in Ch. 7.4-7.5, 7.7, 7.9, 8.7
• After-class: All challenge activities in Ch. 7.4-7.5, 7.7, 7.9, 8.7
---
4/22 JQuery
• Pre-class: All participation activities in 9.1-9.
• After-class: All challenge activities in 9.1-9.6
4/27 Node.js and Express
1. Ch 11.1-11.9
2. Supplementary Reading (highly recommended because the book is a bit terse): w3schools.com--go to node.js
---