; Tuesdays and Thursdays 2:15pm - 3:30pm Rm. MSB 228
Office Hours Tuesdays and Thursdays: 10:00am - 12:15pm
---------------------------------------------------------
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
Weekly Course Outline
| Weeks | Topics | Reading Material |
|---|---|---|
| 1 | Database Overview | Ch 1 |
| 2,3 | Relational Model | Ch 2 |
| 4 | SQL | Ch 3 |
| 5 | Advanced SQL | Ch 4 |
| 6 | ER Model | Ch 6 |
| 7,8 | Relational Database Design Theory | Ch 7 |
| 9 | Application Design and Development | Ch 8 |
| 10 | Storage and File Structures | Ch 11 |
| 11, 12 | Indexing and Hashing | Ch 12 |
| 13 | Query Processing | Ch 13 |
| 14, 15 | Transaction Management | Ch 15,16 |
Projects and Exams
There will be three exams during the semester. First exam on February 16th, 2010; second exam on March 18, 2010; third exam on April 27, 2010. In addition, there will be a final exam. Final exam is all inclusive. Final Exam is on May 12 at 12:45pm. Each student is expected to do a project. List of projects will be available on or before March 4th, 2010. Students must select the project from the list and send an email notification of their selection to yuri@cs.kent.edu by March 9th, 2010. Once project is selected, no project change is allowed without the instructor's permission. The project deadline is May 6, 2010 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 accomodations to ensure their equal access to course content. If you have a documented disability and require accomodations, 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)