|
|
|
Presentation
|
Readings
|
Assignment (ALL)
|
|
Jan
|
11
|
Introductions
|
|
Complete introductory
free form data
|
|
|
16
|
He Makes How Much? The Infamous Flat File
|
Fundamentals of Database Systems Ch. 1
|
Play with UNC Salaries in Excel |
|
|
18
|
What's in a Name? Atomizing and Reconstructing (Video)
|
List of database terms we hope to master
|
Create and Query Class Member
Table in Excel |
|
|
23
|
Shifting to MySQL
|
Fundamentals of Database Systems Ch. 3
|
Install and Goof Around with MySQL |
|
|
25
|
SQL at Your Command
CLIPS |
http://www.w3schools.com/sql/default.asp
|
Basic SQL Commands |
|
|
30
|
Living within Constraints
CLIPS
|
Fundamentals of Database Systems Ch. 4
|
Create Classmembers table in HeidiSQL |
|
Feb
|
1
|
|
Cliff at conference in Arizona |
|
|
|
6 |
The Key to Good Relationships... Have Lots of Children
|
|
Identify and Create Child Tables |
|
|
8
|
My
Scheming Relations
|
|
More and Better Children |
|
|
13
|
Innies and outies. Reconstructive
surgery.
|
Fundamentals of Database Systems Ch. 15
|
Experiment with Inner/Outer Joins & Concatenation |
|
|
15
|
The view from here...
Things are looking
up!
|
|
Create views to reconstitute Class Members |
|
|
20
|
Re-view Views.
Living with Integrity.
|
Fundamentals of Database Systems Ch. 7
|
Oh, Look It Up! Set up Pearl. |
|
|
22
|
Why be Normal?
|
|
Music Model |
|
|
27
|
Not my Default!
Nothin' from nothing' leaves nothin'. Getting a date.
|
|
Gettin' a Date. More Musical. |
|
|
1
|
Trigger Happy.
NoteApp
|
|
Whose default is it? Triggers are wonderful things! |
|
Mar |
6 |
Review... Stump the chump |
|
|
|
|
8
|
MIDTERM EXAM
|
|
|
|
|
13
|
Spring Break
|
|
|
|
|
15
|
Still Spring Break
|
|
|
|
|
20 |
Mid-term Post Review, Catch-up. |
|
Persons on Pearl |
|
|
22 |
Our Class Project
(Navicat,
download) |
Fundamentals of Database Systems Ch.25 |
Whose Idea was this Anyway? |
|
|
27
|
Discuss project requirements
|
Fundamentals of Database Systems Ch.21 & 23
|
Organizing Persons on Pearl |
|
|
29
|
Getting Chunky with the Project
|
Fundamentals of Database Systems Ch.14
|
ER Diagrams |
|
|
3
|
Review Project. Group Models I
|
|
|
|
Apr
|
5
|
Review Group Models II
Work on models in class,
split up tables |
|
The First Chunk |
|
|
10 |
Promiscuity and Scattering Stuff All
Over
(Lightbeam)
|
Fundamentals of Database Systems Ch.18
|
Model class project. Tables in Pearl DB. |
|
|
12
|
Review Group Models III
Transactions and
Protection
|
Fundamentals of Database Systems Ch.24
|
Ya ain't got nuthin' on me, Facebook! |
|
|
17
|
Database Security
|
|
Make Some Chunk Views |
|
|
19
|
Indexes and Optimization
Different points of views.
|
|
Make Some Project Views |
|
|
23
|
Complex Queries
Present and discuss class project
|
|
Exercising Your Reconstitutional Rights |
|
|
26 |
XML and Other Formats
Final Exam review
|
|
|
|
|
|
Study, study, study...
|
|
|
|
Apr
|
30
|
Final Exam
Monday @ Noon
|
(Please see me if you need alternative accommodations.)
|
|
Note: If you're unable to access links or have any technical issues with
the course Web site, please
email
me with specific
information about the problem.
|