Data Base: Class Resources
Presentations:
List of Presentations
[Use 'List of Presentations' to see presentations.]
LABS:
List of Labs
[Use 'List of Labs' to see labs.]
Activities:
List of Activities
[Use 'List of Activities' to see activities.]
Examples:
List of Examples
[Use 'List of Examples' to see examples.]
Some of the examples are referred to in the presentations.

Preliminary Schedule:
WEEK 1
Syllabus, Policies, and Introduction
Minor Topic: Class Policies
DISCUSSION: What is a Database, and who needs one? Major Topic: Entities, Attributes, Relationships
Presentation: ER Diagrams
EXAMPLES: Entity relationship Diagrams
ACTIVITY:Video rental ER
LAB:Library Lab ER(then individual library)

WEEK 2
Major Topic: using ACCESS
Presentation: Access EXAMPLES: Register1 ACCESS
access-intro.pdf
ACTIVITY:Video rental ACCESS
LAB:Library Lab ACCESS(then individual library)

WEEK 3
Major Topic: SQL (PostgreSQL) I
Presentation: SQL Registration EXAMPLES: CountS24
RegisterSQL
ACTIVITY:Video rental SQL
LAB:Library Lab SQL(then individual library)

WEEK 4
Major Topic:Normalization
Presentation:
EXAMPLES:warehouse shipping
ACTIVITY: bookstore
LAB: normalization

WEEK 5
Major Topic: Basic Access and QBE
Presentation:
EXAMPLES:Star Trek
ACTIVITY:SF club
LAB:Car Sales

WEEK 6
Topic: ACCESS Intermediate
Presentation:
EXAMPLES: ACCESS Math and Summary Reports
Activity: Family tree
LAB:Bedrock ACCESS

WEEK 7
Presentation:
Major Topic: ACCESS advanced (inner outer, etc.)
ACCESS EXAMPLES: BookMatching2, GroupGrading2, kitchen21
ACTIVITY: Scheduler (Access)
LAB:Stooges ACCESS

WEEK 8
Presentation:
Major Topic: SQL(PostgreSQL) Advanced
EXAMPLES: Registration24 (SQL)
HealthCast
ACTIVITY:Scheduler (SQL)
MIDTERM to be held in lab period

WEEK 9
Presentation:
Major Topic: PHP
EXAMPLES: Old McDonald
CountS24
HealthCast
LAB:PHPlab part I
ACTIVITY:playPHP
MORE EXAMPLES:
Registration24 (SQL)
HealthCast

WEEK 10
Presentation:
Major Topic: Forms
Examples:
Registration24 (SQL)
HealthCast
LAB:PHPlab part II
ACTIVITY:

WEEK 11
Presentation:
Major Topics:
Reliability(see CodedBias)
Concurrency (see airlines)
Security
Encryption
LAB: Airline Reservations
ACTIVITY:Encryption
EXAMPLES:

WEEK 12
Presentation:
Major Topics:
Data mining
KDB
LAB: KDB
ACTIVITY:Password Guessing

WEEK 13
Major Topic:Project Work Week
LAB: Catch up on LABS
ACTIVITY: Catch up on ACTIVITIES

WEEK 14
Presentation:
Major Topic: Relational Algebra
Major Topic: Predicate Calculus
LAB:StoogesRA
ACTIVITY:StoogesPC
[Getting your project ready to present takes priority over RA and PC.]

WEEK 15
Project Reports
LAB: Data Mining Bias (CodedBias)

FINAL during Finals Week