CSE 5330/7330 FALL 2009

FILE ORGANIZATION AND DATABASE MANAGEMENT

Professor Margaret H. Dunham
800U Expressway Towers
phone:(214) 768-3087
fax: (214) 768-3085
email:
www: http://www.lyle.smu.edu/~mhd

Office Hours: 11-12:30 T/Th

312 SIC

214-768-1476

Text:

Database Management System Third Edition, by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill Press, 2003.

Course Description:

A survey of current database approaches and systems. Principles of design and use of these systems. Query language design, implementation constraints. Applications of large databases. Includes a survey of file structures and access techniques. Use of a relational DBMS to implement a database design project.

Prerequisite:

CSE 3358

It is expected that each student will keep up with the reading as outlined in the syllabus below. Additional materials may be referenced in class as needed.

All material submitted by students is to be their own work. No joint projects or homework solutions will be allowed unless students get prior approval from Dr. Dunham. Plagiarism will not be tolerated. All students are expected to be familiar with and follow the SMU honor code policy: http://www.smu.edu/studentlife/PCL_05_HC.asp

ANY STUDENT FOUND PLAGIARIZING WILL RECEIVE AN AUTOMATIC GRADE OF 0 ON THAT ASSIGNMENT. A SECOND INSTANCE OF CHEATING BY THAT STUDENT WILL RESULT IN A GRADE OF F FOR THE COURSE.

NO EXTENSIONS will be automatically given to due dates for distance students.

Grading:

Homework / 60%
Tests / 20%
Projects / 20%

There will be six homework assignments, two tests, and one project. Each homework is worth 10% of the grade, each test is worth 10% of your grade, and the project is worth 20% of the grade. 7330 students will be given a more extensive project than 5330 students.


Disability Accommodations: Students needing academic accommodations for a disability must first contact Ms. Rebecca Marin, Coordinator, Services for Students with Disabilities (214-768-4557) to verify the disability and establish eligibility for accommodations. Then schedule an appointment with the Dr. Dunham to make appropriate arrangements. (See University Policy No. 2.4.)

Religious Observance: Religiously observant students wishing to be absent on holidays that require missing class should notify Dr. Dunham in writing at the beginning of the semester, and should discuss with her, in advance, acceptable ways of making up any work missed because of the absence. (See University Policy No. 1.9.)

Excused Absences for University Extracurricular Activities: Students participating in an officially sanctioned, scheduled University extracurricular activity will be given the opportunity to make up class assignments or other graded assignments missed as a result of their participation. It is the responsibility of the student to make arrangements with Dr. Dunham prior to any missed scheduled examination or other missed assignment for making up the work. (University Undergraduate Catalogue)

Tentative Schedule:

TOPIC (Dates) / READING / SCHEDULE / HOMEWORK
Introduction, History / Ch1 / 8/27
File Organization & Indexing / Ch8,Ch9,Ch10,Ch11 / 8/27-9/3 / HW1
Data Models / Ch2 / 9/10 / HW2
Relational Model, Algebra, Calculus, Normalization / Ch3,Ch4,Ch19 / 9/10-10/1 / HW3
Oracle Introduction / 10/8
Test 1 / 10/15
SQL / Ch5 / 10/22-10/29 / HW4
Query Processing / Ch12,Ch14,Ch15 / 11/5-11/12 / HW5
Transactions / Ch16,Ch17,Ch18 / 11/12-11/19 / HW6
THANKSGIVING – NO CLASS / 11/26
Advanced Topics / 12/3
PROJECT DUE; FINAL / 12/17

CSE 5330/7330 Fall 2009 Page 1