Tuesdays and Thursdays 9:15 - 10:30am Rm. MSB 115
Office Hours Tuesdays and Thursdays: 11:00am - 12:15pm
---------------------------------------------------------
CS 33001 Data Structures
CS31011 - Discrete Structures
Structured Programming (C++)
Software Engineering topics related to project documentation
Or Consent of the Instructor
This course is an introduction to the design, use, and internal workings of database management systems We consider here systems that are based on relational model - that is, users data is represented as a set of two dimensional tables. During the class we learn the ways to organize the data into relations so that the user applications may concurrently manipulate the data from database quickly and reliably. We briefly discuss the relational model and then concentrate on relational query language SQL. We continue with the study of relational database design. Finally, we study database internal storage organization and concurrency control issues. Attendance is required for this class
Silberschatz,
Korth, Sudarshan
Database System Concepts, 5th Edition, McGrow Hill
2005
Garcia-Molina,
Ullman, Widom
Database Systems The Complete Book, Prentice Hall,
2002
Projects and
Exams
There will be three exams during the semester. In addition, there will be a final exam. Final exam is all inclusive. Each student is expected to do a project. List of projects will be available on or before March 1st, 2009. Students must select the project from the list and send an email notification of their selection to jin@cs.kent.edu by March 7th, 2009. Once project is selected, no project change is allowed without the instructor's permission. The project deadline is May 7, 2008 and no late project will be accepted or given any credit.
Requirements
& Grading Policy
A student's grade will be determined as a weighted average of exam 1 (15%), exam 2 (20%), exam 3 (15%), final exam (25%), project (20%), and attendance (5%)
University policy 3342-3-18 requires that students with disabilities be provided reasonable accommodations to ensure their equal access to course content. If you have a documented disability and require accommodations, please contact the instructor at the beginning of the semester to make arrangements for necessary classroom adjustments. Please note, you must first verify your eligibility for these through Student Disability Services (contact 330-672-3391 or visit Student Disability Services for more information on registration procedures)
Lectures:
1.
Lecture
Slides: Introduction to
Database (week 1)
2. Lecture Slides: Relational Algebra (week 2-3)
3. Lecture Slides: Basic SQL (week 4-5)
4. Lecture Slides: Advanced SQL
5.
Lecture Slides: ER Diagram
6. Lecture Slides: Database Design Theory
7. Lecture Slides: Storage
8. Lecture Slides: Index
9. Lecture Slides: Query Optimization
10. Lecture Slides: Transaction
Lab Tutorial,
Project, and Exam
1.
MySQL Tutorial 1 (PPT, Handout)
2. MySQL Tutorial 2 (PPT)
4.
Project Choices (Citation Database, Book Store Database)
5.
Group Assignment
|
Citation DB |
Group 1: |
Tristan
Cuevas and Kevin Nastase |
|
|
Group 2: |
John Corall, Dan Sheaffer, and Mike Garrard |
|
BookStore DB: |
Group 3: |
Kevin Bliler, Matt Baumert, Matt Suhay and |
|
|
Group 4: |
Greg Beca, Bill Harris, Brett Adamik, and Doug Mason |
6. Example Bibtex File (for Citation DB)
7. PHP Tutorial
8. Third Exam on Thursday April 16th (Test Contents: ER Diagram and Database Design Theory)