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