Database Management Systems
CSCI 402, Fall semester, 2005
Take-home Final Exam Due: Dec. 21, 2005.
Submit Your Final Project Report : Due: Dec.
31, 2005.
Database
projects:
Ken
|
James and Joe
|
Mike and Jason
|
Jon Heckinger
|
Jon Glyer
|
Aaron Gundel
|
Amanda and Francheska
|
Mamoru and Mark
|
Lange and McCorkle
|
Ravi and Ryan
|
Joel
|
Andre
|
To the Bottom of the Page
Instructor: Dr. Shieu-Hong Lin
Email:
shieu-hong.lin@bubbs.biola.edu
Class: Monday,
Wednesday 3:00~4:15pm
Office
Hours: Mon. & Wed. 4:30-5:30 pm,
Math & CS department
Syllabus
Database Projects: requirements,
groups, resources
Textbook
·
Catherine
Ricardo, Databases Illuminated, Jones
and Bartlett, 2005.
About cumulative weekly reading & progress report:
1.
See the
template report here as a word document or a web page. Save the
contents in a file and keep that file with you throughout the semester.
2.
By Wednesday
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.
Week 1 Overview of Database Management
Reading #1: Due Date: Wednesday, August. 31
- Read sections 1.7~1.8 of the textbook and study the sample project (pp.31
~50)
- 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
Week 2 Overview of SQL: Part 1
Reading #2: Due Date: Wednesday, Sept. 7
- (i)
Read sections 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.
Week 3 Overview of SQL: Part 2
Reading #3: Due Date: Wednesday, Sept. 14
- (i)
Read sections 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
Week 4 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
Week 5 SQL Subqueries
Reading #5: Due Date: Wednesday, Sept. 28
- Read the handout
on SQL subqueries given in the
class this week.
- Read sections 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,
Sept. 26
Week 6 ER Diagrams
Reading #6: Due Date: Wednesday, Oct. 5
- Read sections 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,
phpMyAdmin to work with the
MySQL server on the CS X server. 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
LCD projector.
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
- Read sections 4.8 of the textbook on the mapping from ER diagrams to
relational models.
- Read the W3Schools
tutorials and examples on HTML (especially
about basic tags, formatting, frames, tables, and forms)
Week
9 Review & Midterm Exam
- SQL review on
Wednesday, Oct. 27
Midterm on SQL queries & ER diagrams: Here
Weeks
10~11 Using PHP scripts to access MySQL databases
Lab #7: Using web pages and PHP scripts to interact
with MySQL. Monday, Oct. 31 & Nov. 7.
Reading #8: Due Date: Wednesday, Nov. 9
· Read
all things linked and mentioned in Using PHP scripts
to access MySQL databases
Homework #5:
Creating the tables needed in your project
Due Date: Wednesday, Nov. 16
- Based
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
ER
mapping handout regarding the mapping from ER diagrams to tables.)
- We
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.
Weeks
12 Thanksgiving recess.
Weeks
13~14 Building up your database project
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.
31, 2005.
To the Top of the Page