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