Presentations


Chapters	Notes	Reading
Chapter 1: Introduction	ppt pdf	All Sections
Chapter 2: Relational Model	ppt pdf	All Sections
Chapter 3: SQL	ppt pdf	Sections 3.1 – 3.10
Chapter 4: Advanced SQL	ppt pdf	Sections 4.1 – 4.5
Chapter 6: Entity-Relationship Model	ppt pdf	Sections 6.1 – 6.10
Chapter 7: Relational Database Design	ppt pdf	Sections 7.1 – 7.5.3
Chapter 8: Application Design and Development (reading)	ppt pdf	All Sections
Chapter 11: Storage and File Structure	ppt pdf	All Sections
Chapter 12: Indexing and Hashing	ppt pdf	All Sections

Lab1      MySQL-interactive: tutorial and practical training

                Wednesday, November 3

                 5:30 – 8:00 pm (2.5 hours)

                Computer Lab 139

                (No class on Monday, November 1)

Lab2      PHP/MySQL: tutorial and practical training

                Wednesday, November 10

                 5:30 – 8:00 pm (2.5 hours)

                Computer Lab 139

                (No class on Monday, November 8)

Download mySQL: http://www.mysql.com/downloads/mysql/

FINAL GRADES

Textbook: Database System Concepts, Fifth Edition, McGraw-Hill, ISBN 0-07-295886-3

by
Avi Silberschatz

Henry F. Korth

S. Sudarshan

Book's web site (go to Fifth Edition)

Office hours: MW 1:00 – 3:00 PM or by appointment

TESTS

o Test #1: On Wednesday, September 29, 2010 (testing Chapter 2 material). Results.pdf

o Test #2: On Wednesday, October 13, 2010 (testing Chapter 3 material). Results.pdf

o Test #3: Take Home Test: distributed on November 22, 2010, due date December 1, 2010 (testing Chapters 6 and 7). Results.pdf

PROJECTS

Each student is expected to do a project. List of projects will be available on or before Oct 15th, 2010. Students must select the project from the list and send an email notification of their selection to dragan@cs.kent.edu by Oct 31st, 2010. Once project is selected, no project change is allowed without the instructor's permission. The project deadline is Dec 10, 2010 and no late project will be accepted or given any credit.

Sample Project 1 Sample Project 2

Submission is by email to dragan@cs.kent.edu and to mabuata@cs.kent.edu no later than Dec 10, 2010 (midnight). Include in zipped file: documentation file, user-manual, all source files of programs, and a file www_link.doc with project title, participants and link to project’s web site.

Results.pdf

EXAMS

Final: Monday, December 13, 2010, 5:45 pm - 8:00 pm Results.pdf

(There will be some questions similar to those from tests

and additional problems on B⁺-trees)

(I will be available for consultations from 1:30 to 3:30 pm on Friday)

F. F. Dragan
dragan at cs dot kent dot edu
Fall 2010

CS 4/53005: Introduction to Database Systems Design

Presentations

Chapters

Notes

Reading