CS 2233

Database Management Systems

Fall 2009

Professor:                   John Youssefi, Ph.D

Course Hours:           Monday 6:30 – 9:30.

Office Hours:             Monday & Friday 5:30 - 6:30,

Offices/Contact:        SM 205B, (650) 508-3450, jyoussefi@ndnu.edu

Required Text:          A First Course in Database Systems, Jeffrey D. Ullman

                                    and Jennifer Widom Third Edition

Prerequisites:             CS1130 or equivalent experience with JAVA,

                                    MA045A, C51140 is recommended.

Course Description:

File organization and storage management. Access methods. Logical versus physical organization. Relational, network and hierarchical models. Database architecture, schemas and query facilities. Transaction processing, recovery, concurrency. Distributed systems. Issues of performance, integrity and reliability. Project: designing and implementing an MySQL DBMS application

Course Objectives:

• Introduction to Relation Database Management Systems(RDBMS), theory, application and implementation
• Understanding Data Modeling and Entity-Relationship(ER) Diagramming
• Exposure to application building using RDBMS
• Higher competency in software design and programming (Java and SQL/PLSQL)

Assessment Methods:

• Through homework and programming assignments
• Through quizzes and tests
• Through a comprehensive project

GRADING:

Grades will be assigned based on a combination of homework, midterm, quizzes, final and project.  The weighting for the components will be:

Homework – 15%

Quizzes – 15%

Midterm – 20%

Project – 25%

Final Exam – 25%

The final grade will be calculated using this formula:

      FG = 15%*homework + 15%*Quizzes + 20%*Midterm + 25%*Project + 25%*Final

Letter grades will be assigned on the following basis:

A = 93-100, A- = 89-92

B+ = 85-88, B = 80-84, B- = 76-79

C+ = 72-75, C= 67-71, C- = 63-66

D+ = 59-62, D= 54-58, D- = 50-53

F = 0-49

Procedures:

Class work includes homework, projects, discussions and presentations.

Homework will be assigned each class.

Homework will be due by next week on Monday, 6:30 pm

The purpose of the homework is to help achieve understanding of the material. Credit will be given for incorrect answers if they are followed up with the instructor in order to achieve this understanding. Some assignments may include lab activities using a commercial database.

Homework turned in must indicate on the first page:

Your Name:

Due Date:

Date Turned In:

Exercise/Problem Numbers, Chapter, Page in textbook

For each programming exercise/problem:

  Does/Does not compile without error,

  Does/Does not execute without error

  Source code

  Output

Regular attendance is essential.  Roll will be taken for each class and grades can be affected by attendance.

The reading assignments in the text are very important and should be completed before each class.

Midterm and Final Exam:

Make-up Midterm Exam or Final Exam will be approved only in very special situations that are beyond your control.

The Final Exam is COMPREHENSIVE from the whole course.

Quizzes:

I will give you several unannounced quizzes to check that you completed the reading assignments.  As attendance is mandatory, if you miss a quiz, without being in a situation beyond your control, you will get 0 points for it.

Project:

Each student will write requirements for, design and implement a small database for a commonly understood problem domain (such as banking, retail store, airline reservation, student registration, etc.) and populate the database with sample data.  A client application will be written which provides access to the data.  Criteria for grading the project will be: completeness of requirements, satisfaction of requirements by the design and implementation of the database, presentation of the design, and the sample data with which the database is populated.  A detailed explanation of project expectations will be provided.

Tentative Schedule:

References:

O’Neil,O’Neil & Gray, Database: Principles, Programming, and Performance, Second Edition

Elmasri & Navathe, Fundamentals of Database Systems , 3rd Edition

ACM Website, http://www.acm.org for related papers

Oracle Technology Network, http://otn.oracle.com for Oracle technology resources