Database Management Systems
CSCI 402, Fall semester, 2005
Take-home Final Exam Due: Dec. 21, 2005.
Submit Your Final Project Report : Due: Dec.
James and Joe
Mike and Jason
Amanda and Francheska
Mamoru and Mark
Lange and McCorkle
Ravi and Ryan
To the Bottom of the Page
Instructor: †††† Dr. Shieu-Hong Lin
Wednesday 3:00~ 4:15pm
Hours: Mon. & Wed. 4:30-5:30 pm,
Math & CS department
Database Projects: requirements,
Ricardo, Databases Illuminated, Jones
and Bartlett, 2005.
About cumulative weekly reading & progress report :
template report here as a word document or a web pageSave the
contents in a file and keep that file with you throughout the semester. . By 2.
each week, you should spend around10 minutes to
add an additional record into the file (
on top of the previous records)
regarding the latest progress made in this class, and email this entire file of progress report as an
attachment to me.
††† Overview of Database Management
Reading #1: ††† Due Date: Wednesday, August. 31
ections 1.7~1.8 of the textbook and study the sample project (pp.31
Study the students
projects in the end of chapter 1 (pp. 31~65) and try to pick one of them
as your target semester project. Form your project group and inform me of
your group members.
Lab #1: Access database lab Part 1, Part 2 Due Date: Wednesday, Sept. 7
††† Overview of SQL: Part 1
Reading #2: ††† Due Date: Wednesday, Sept. 7
Read s ections 2.1~2.4, 2.7 of the textbook and the
sample activity on the sample project (pp.106 ~113) (ii) Read the first 3
pages of Intro to SQL handout
given in the class
Homework #1: Data
dictionary : † Due Date: Wednesday, Sept. 7
As described in
pp.106 ~113 of the book, create a data dictionary for the student project
you pick as your target semester project and go as far as you can to create
a cross reference table.
††† Overview of SQL: Part 2
Reading #3: ††† Due Date: Wednesday, Sept. 14
Read s ections 4.1~4.4 of the textbook (ii) Study the
art gallery sample project. Read the description of SQL aggregate
functions page 4 of Intro to SQL
handout given in the class last week
Homework #2: Creating tables and data. Due Date: Wednesday, Sept. 14
Lab #2: First exposure to MySQL server. Monday, Sept. 12
††† Relational Algebra
Reading #4: ††† Due Date: Wednesday, Sept. 21
Read the Relational Algebra handout given in
the class this week.
Homework #3 as a tutorial guide to relational algebra (if you donít have MS
Power Point you can download their free PowerPoint
Viewer to see this homework) Due Date:
Wednesday, Sept. 21
Lab #3: More exposure to MySQL. Monday, Sept. 19
††† SQL Subqueries
Reading #5: ††† Due Date: Wednesday, Sept. 28
Read the handout
on SQL subqueries given in the
class this week. Read s
ections 3.1~3.4 of the textbook on the basics of ER diagrams
Optional: Read the section on
subqueries from the online MySQL reference manual †
Lab #4: Using subqueries. Monday,
††† ER Diagrams
Reading #6: ††† Due Date: Wednesday, Oct. 5
ections 3.5~3.8 of the textbook on the basics of ER diagrams.
Read pp.149~167 of
the textbook to see how to put together an ER diagram for the analysis of
the sample art gallery project used through out the book.
Lab #5: Using FileZilla, PuTTY,
to work with the
MySQL server on the CS X server. phpMyAdmin Monday, Oct. 3
Homework #4: ER
diagrams †††††† Due Date: Wednesday, Oct. 12
Follow the steps
3.1~3.4 on page 167 of the book to put together an ER diagram for the
analysis of the application domain of your project and update your data
dictionary as needed. You may read
Use 5~10 minutes
to present your ER diagram to the class on Oct 12 using a transparency (if
the ER diagram was done manually on paper) or through the computer and the
Weeks 7~8 ††††† Basics of HTML and PHP
Lab #6: Basics of HTML and PHP. Monday, Oct. 10
Presentation & refinement of your ER diagrams.
Monday, Oct. 17
Reading #7: ††† Due Date: Wednesday, Oct. 26
ections 4.8 of the textbook on the mapping from ER diagrams to
Read the W3Schools
tutorials and examples on HTML (especially
about basic tags, formatting, frames, tables, and forms)
9 ††† Review & Midterm Exam
SQL review on
Wednesday , Oct. 27
Midterm on SQL queries & ER diagrams : Here
Using PHP scripts to access MySQL databases Weeks
Lab #7: Using web pages and PHP scripts to interact
with MySQL. Monday, Oct. 31 & Nov. 7.
Reading #8: Due Date: Wednesday, Nov. 9
all things linked and mentioned in ∑ Using PHP scripts
to access MySQL databases
Creating the tables needed in your project
Due Date: Wednesday, Nov. 16
on the ER diagrams you have for homework#4, design the tables needed in
your database application project and determine the formats (columns and
their types) of these tables. (You may want to review section 4.8 and this
regarding the mapping from ER diagrams to tables.) ER
plan to spend time actually building up these tables plus sample records
under your CS OS X MySQL account during the lab on Nov. 14.
Be prepared to use
around 15 minutes to present your tables and your refine ER diagram to the
class starting from Nov. 16 using transparencies or through the computer
and the LCD projector.
12 Thanksgiving recess.
Building up your database project Weeks
Homework #6: Due Date: Wednesday, Dec. 7
Creating at least 12 interesting queries to
retrieve information from the tables of your application domains
Reading #9: Due Date:
Wednesday, Wednesday, Dec. 14
Sections 5.1~5.5 on the basics
of database normalization
The class handout
here on normalization
Take-home Final Exam: Due: Dec. 21, 2005.
Submit Your Final Project Report : Due: Dec.
To the Top of the Page