CS 445 Schedule
Date
|
Topic
|
Notes
|
Assignments
|
Aug 29 | Introduction
to Databases | Definition of Terms | Overview (Chapter 1) Database Trends Intro to ER Diagrams |
PDF Example |
|
Aug 31 | ER Diagrams ER Diagrams Exercise 2.3, page 52 in class |
PDF UMLet ER Palette Install in Umlet/palettes |
|
Sep 05 | Present ER Diagrams, pg 52. In Class ER diagram Example (ERInClassLab) |
Groups Homework |
|
Sep 07 | Present
pg 52 Results The Relational Model - SQL Create [Chapter 3 through 3.3.1] |
PDF |
|
Sep 12 | ER to SQL translations |
Assignment
One |
|
Sep 14 | ER to SQL translations | |
|
Sep 19 | SQL Basics (LAB) | PDF dbeaver dbeaver setup |
|
Sep 21 | Indexes, Joins, SQL | Assignment One ER Diagram DUE Assignment One DATA |
|
Sep 26 | Indexes, Joins, SQL Exam Review |
Dbeaver
with Putty on Windows
Basic SVN Help GitLab Workflow GitLab Permissions REVIEW |
|
Sep 28 | Exam |
||
Oct 03 | Today |
||
Oct 05 | Normalization | PDF |
No hard copies necessary! Phone Numbers? Assignment One DUE Homework 2 - Groups |
Oct 10 | What networking questions do you
have that you would like discussed in class?
HTML Primer: Read the noted sections of the w3schools web page before class on Oct 12 |
||
Oct 12 | Finish Normalization |
||
Oct 17 | Networking Group activity |
Networking |
Group
Database Project Groups |
Oct 19 | Web enabled database architecture | MySQL | Apache | PHP | CodeLite PHP |
|
Oct 24 | PHP | DB Project Discussion | DB Topic Due: Oct 25, 11:59pm | |
Oct 26 | Relational Algebra MySQL/MariaDB |
PDF
- Relational Algebra PDF - Index Examples |
|
Oct 31 | Exam
Review |
DUE:
1159pm DB ER diagram Web Page MockUp |
|
Nov 02 | Exam |
||
Nov 07 | Design
Presentations |
Design
Presentations |
|
Nov 09 | Indexes | Indexes Example CollegeDB |
|
Nov 14 | Query Evaluation | PDF |
Create Statements |
Nov 16 | SQLite / Lab | PDF |
Lab |
Nov 21 | Advanced SQL |
CodeLite/PHP/Git Work Flow
CodeLite/PHP/Git Work Flow - UPDATED |
Inserts/Queries DUE |
Nov 23 | NO CLASS |
||
Nov 28 | Lab Work Day! |
||
Nov 30 | Review - DEC 6, 2-4pm, Scott 204 |
||
Dec 05 | Final Presentations SCHEDULE CHANGE | Group
Grading! Web Interface Due |
|
Dec 12 | TUESDAY : noon - 2:30 pm
FINAL EXAM |