CS 445 Schedule
|
Date
|
Topic
|
Notes
|
Assignments
|
| Aug 27 | Introduction
to Databases | Definition of Terms | Overview (Chapter 1) Database Trends Intro to ER Diagrams |
PDF CS 445 VM Example (CarDealershipDB) |
|
| Aug 29 | ER Diagrams ER Diagrams Exercise 2.3, page 52 in class |
PDF UMLet ER Palette Install in Umlet/palettes |
|
| Sep 03 | Peer Review Exercise 2.5 (bring one
print out!) In Class Lab: Exercise 2.5, page 53 in class, Build ER Diagram |
Groups Homework (CarDealershipDB_ERDescription) |
|
| Sep 05 | The Relational Model - SQL Create [Chapter 3 through 3.3.1] | PDF |
|
| Sep 10 | Homework peer review (rubric) ER to SQL translations |
Assignment
One (Individual project) |
|
| Sep 12 | ER to SQL translations get db accounts / connect to the db |
|
|
| Sep 17 | SQL Basics (LAB) | PDF dbeaver |
|
| Sep 19 | Indexes, Joins, SQL | Assignment One ER Diagram DUE Assignment One DATA |
|
| Sep 24 | Indexes, Joins, SQL Exam Review Exam Review with ER diagram |
Basic
SVN Help GitLab Workflow GitLab Permissions Exam Review Exam Review with ER diagram |
|
| Sep 26 | Exam |
||
| Oct 01 | SQL: Subqueries, Indexes |
More
SQL |
|
| Oct 03 | Normalization (Chapter 19) | PDF |
No hard copies necessary! Phone Numbers? Assignment One DUE |
| Oct 08 | |||
| Oct 10 | Finish Normalization |
Practice |
Homework
2 HTML Primer: Read the noted sections of the w3schools web page before class on Oct 17 |
| Oct 15 | Group activity |
Group
Database Project |
|
| Oct 17 | Web enabled database architecture | MySQL | Apache | PHP | Web Arch CodeLite PHP |
|
| Oct 22 | PHP | DB Project Discussion | DB Topic Due: Oct 25, 2:45pm | |
| Oct 24 | PHP MySQL/MariaDB |
PDF - Index Examples | Design Presentations |
| Oct 29 | Exam
Review |
DUE:
1159pm DB ER diagram Web Page MockUp |
|
| Oct 31 | Exam |
||
| Nov 05 | Design
Presentations |
Design
Presentations |
|
| Nov 07 | Advanced SQL | CodeLite/PHP/Git
Work Flow
CodeLite/PHP/Git Work Flow - UPDATED Lecture: PDF
GitLab & SSH Keys Git Setup |
|
| Nov 12 | Relational Algebra Indexes and Storage Engines |
PDF
(07) PDF (06) |
Create Statements |
| Nov 14 | Indexes | Indexes Example |
|
| Nov 19 | Query Evaluation | PDF (08) | Inserts/Queries DUE |
| Nov 21 | Work Day | ||
| Nov 26 | Final Presentations | PDF |
Group Grading! Web Interface Due |
| Nov 28 | |||
| Dec 03 | Review |
EXAM REVIEW
EDITABLE EXAM REVIEW PDF WITH IMAGES |
|
| Dec 10 | TUESDAY : noon - 2:30 pm
FINAL EXAM |