|
|
|
Presentation
|
Readings
|
Assignment (ALL)
|
|
Jan
|
18
|
Introductions
|
|
Complete introductory
free form data
|
|
|
23
|
He Makes How Much? The Infamous Flat File
|
Fundamentals of Database Systems Ch. 1
|
Play with UNC Salaries in Excel |
|
|
25
|
What's in a Name? Atomizing and Reconstructing
|
List of database terms we hope to master
|
Create and Query Class Member
Table in Excel |
|
|
30
|
Shifting to MySQL
|
Fundamentals of Database Systems Ch. 3
|
Install and Goof Around with MySQL |
|
Feb
|
1
|
SQL at Your Command
CLIPS |
http://www.w3schools.com/sql/default.asp
|
Basic SQL Commands |
|
|
6
|
Living within Constraints
CLIPS
|
Fundamentals of Database Systems Ch. 4
|
Create Classmembers table in HeidiSQL |
|
|
8
|
The Key to Good Relationships... Have Lots of Children
|
|
Identify and Create Child Tables |
|
|
13
|
My
Scheming Relations
|
|
More and Better Children |
|
|
15
|
Innies and outies. Reconstructive
surgery.
|
Fundamentals of Database Systems Ch. 15
|
Experiment with Inner/Outer Joins & Concatenation |
|
|
20
|
The view from here...
Things are looking
up!
|
|
Create views to reconstitute Class Members |
|
|
22
|
Re-view Views.
Living with Integrity.
|
Fundamentals of Database Systems Ch. 7
|
Oh, Look It Up! Set up Pearl. |
|
|
27
|
Why be Normal?
|
|
Music Model |
|
Mar
|
1
|
Not my Default!
Nothin' from nothing' leaves nothin'. Getting a date.
|
|
|
|
|
6
|
Trigger Happy. Review... stump the chump
|
|
|
|
|
8 |
Review. MIDTERM EXAM |
|
|
|
|
13
|
Spring Break
|
|
|
|
|
15
|
Still Spring Break
|
|
|
|
|
20
|
Mid-term Post Review, Catch-up.
|
|
|
|
|
22
|
Our Class Project
|
Fundamentals of Database Systems Ch.25
|
|
|
|
27
|
Discuss project requirements
|
Fundamentals of Database Systems Ch.21 & 23
|
|
|
|
29
|
Getting Chunky with the Project
(Navicat,
download)
|
Fundamentals of Database Systems Ch.14
|
|
|
Apr
|
3
|
Review Project. Group Models I
|
|
|
|
|
5
|
|
|
|
|
|
10
|
Review Group Models II
Promiscuity and Scattering Stuff All
Over
(Lightbeam)
|
|
|
|
|
12
|
Review Group Models III
Transactions and
Protection
|
Fundamentals of Database Systems Ch.18
|
Organizing Persons on Pearl |
|
|
17
|
Database Security
|
Fundamentals of Database Systems Ch.24
|
Make Some Chunk Views |
|
|
19
|
Indexes and Optimization
Different points of views.
|
|
Make Some Project Views |
|
|
24
|
Complex Queries
Present and discuss class project
|
|
Exercising Your Reconstitutional Rights |
|
|
26
|
XML and Other Formats
Final Exam review
|
|
|
|
|
|
Study, study, study...
|
|
|
|
May
|
1
|
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.
|