|
|
|
Presentation
|
Readings
|
Assignment
(ALL)
|
|
Jan
|
11
|
Introductions
|
|
Complete introductory
free form data
|
|
|
13
|
He Makes How Much? The Infamous Flat File
|
Fundamentals of Database Systems Ch. 1
|
Play with
UNC Salaries in Excel
|
|
|
18
|
Martin Luther King Day
|
|
|
|
|
20
|
What’s in a Name? Atomizing and Reconstructing
|
List of database terms we hope to master
|
Create and
Query Class Member Table in Excel
|
|
|
25
|
Shifting to MySQL
|
Fundamentals of Database Systems Ch. 3
|
Install and Goof Around with MySQL
|
|
|
27
|
SQL at Your Command
CLIPS |
http://www.w3schools.com/sql/default.asp
|
Basic SQL Command Line |
|
Feb
|
1
|
Living within Constraints
CLIPS
|
Fundamentals of Database Systems Ch. 4
|
Create Class Member Table in WorkBench
|
|
|
3
|
The Key to Good Relationships... Have Lots of Children
|
|
Identify and create child tables
|
|
|
8
|
My
Scheming Relations
|
|
More and Better Children
|
|
|
10
|
Innies and outies. Reconstructive
surgery.
|
Fundamentals of Database Systems Ch. 15
|
Experiment with inner and outer joins...
concatenation
|
|
|
15
|
|
|
Create views to reconstitute Class Members
|
|
|
17
|
The view from here...
Things are looking
up!
|
|
Oh, look it up! |
|
|
22
|
Re-view views.
Living with Integrity.
|
Fundamentals of Database Systems Ch. 7
|
EER Diagram Introduction
Set up Pearl MySQL Account
|
|
|
24
|
Why be Normal?
|
|
ER Music Model
|
|
|
29
|
Not my default!
|
|
Dates, defaults and triggers.
|
|
Mar
|
2
|
Nothin' from nothing' leaves nothin'. Getting a date.
|
|
Normalize Organizations.
Simplify relationships in music database.
|
|
|
7
|
Trigger happy.
Review... stump the chump
|
|
Work on Wiki |
|
|
9 |
MIDTERM EXAM |
|
|
|
|
14
|
Spring Break
|
|
|
|
|
16
|
Still Spring Break
|
|
|
|
|
21
|
Mid-term post review, catch-up.
|
|
|
|
|
23
|
Our Class Project
|
Fundamentals of Database Systems Ch.25
|
Whose Idea Was This Anyway?
|
|
|
28
|
Visit with William Kamkwamba on project
|
Fundamentals of Database Systems Ch.21 & 23
|
Model class project schema in Pearl DB
|
|
|
30
|
Getting Chunky with the Project
|
Fundamentals of Database Systems Ch.14
|
Rethinking the project DB design
|
|
Apr
|
4
|
Review Project. Group Models I
|
|
Persons on Pearls
|
|
|
6
|
Review Group Models II
Promiscuity and Scattering Stuff All
Over
(Lightbeam)
|
|
The Group Chunk Rethunk
|
|
|
11
|
Review Group Models III
Transactions and
Protection
|
Class project database table editor interface
|
Normalize Organizations on PEARL
|
|
|
13
|
Complex Queries
(Shenmeng)
Different points of views.
|
Fundamentals of Database Systems Ch.18
|
Views to Reconstruct Chunk
|
|
|
18
|
Merge-o-matic
|
Fundamentals of Database Systems Ch.24
|
Make some Big Project Views
|
|
|
20
|
Indexes and Optimization
|
|
One more Big Project View
|
|
|
25
|
Database Security
Present and discuss class project
|
|
Exercising Your Reconstitutional Rights
|
|
|
27
|
XML and other formats
Final Exam review
|
|
Work on that Wiki
|
|
|
|
Study, study, study...
|
|
|
|
|
29
|
Final Exam 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.
|