CS 3430 - Introduction to Database Systems


Fall 2002- Course Syllabus

      PLEASE CHECK THE WEB PAGE OF THIS COURSE (http://www.cs.appstate.edu/~rt/DBMS/f02)
PERIODICALLY FOR UPDATES, ASSIGNMENTS, CLASS NOTES, ANNOUNCEMENTS, and POSSIBLE CHANGES.



Professor: Dr. Rahman Tashakkori, e-mail:  rt@cs.appstate.edu, Web Page: http://www.cs.appstate.edu/~rt/
Office: CAP 121, Office Phone: 262-7009
Office Hours: MWF 8:30-11:00, MWF 12:00-1:00 PM,  and whenever my office door is open
Class Time/Location: MWF 11:00-11:50 /Room 150 CAP
Lab Location: 439 CAP
Start Date: August 27, 2002    End Date: December 11, 2002
Professor's e-mail:  rt@cs.appstate.edu

Prerequisite
CS2490 (Introduction to Theoretical Computer Science)
Text-book
Fundamentals of Database Systems, R. Elmasri and S. B. Navathe, Addison Wesley, Third Edition, 2000.
Other References
An Introduction to Database Systems, C. J. Date, Addison Wesley.
Objective of the Course
This course is intended to give students an understanding of data modelling concepts as well as an introduction to database theory and database systems organization.
Tentative Course Outline
Introduction: Chapters 1 and 2

Entity-Relationship Model: Chapter 3
Relational Model and Relational Algebra: Chapter 7
ER-to-Relational Mapping: Chapter 9
Database Design: Chapter 16
SQL: Chapter 8
Relational Calculus: Chapter 9
Relational Database Design: Chapter 14, 15
File Organization and Indexing Chapter 5, 6
Query Processing and Optimization: Chapter 18
Transaction: Chapter 19
Concurrency: Chapter 20
Recovery: Chapter 21
Security and Integrity: Chapter 22
 
Team Project

We will have one team project in this course.  This project should be based on a real-world application.   We will follow the "Team Software Process" approach to complete the project.  Thus, we will approach the project as a software engineer and a database developer.  All students are required to record their activities regarding the project.  Students will be graded based on their individual performance and activities, and their contributions to the team.  More details will be given on the procedure during the semester.

Grading policy
The following grading scale will used in this course:
                        Exam (1), 25%,
                        Final exam, 30%,
                        Homework 15%,
                        Team Project 20%, and
                        Quizzes and Class Participation %10.

Students are required to attend all classes.  All assignments are due before the start of the class on the due date. No assignment will be accepted once the solution is discussed in the classroom.   No make-up exams will be given in this course.  If you missed an exam due to an "extreme circumstances" such as illnesses, death of a relative, or problems of this nature, you have to present documents (e.g. a letter from a doctor, a letter from a hospital, or an obituary from the funeral).  In the such cases, student's final exam's grade will be used for the missed exam.

All assignments and programs MUST be completed by students individually unless the assignment or project is given as a team project.  In such a case, the team members can work together on the project.  You may discuss the assignments and programs among each other but you have to write/edit programs by YOURSELF.   Please see the ASU Academic Integrity Policy for a description of the woes that befall a transgressor!

Grading Scale
A = 93 to 100,  A- = 90-93.9
B+ = 87 to 89.9, B = 83-86.9, B- = 80-82.9
C+ = 77 to 79.9, C = 73-76.9, C- = 70-72.9
D+ = 67 to 69.9, D = 63-66.9, D- = 60-62.9
F = Below 60
No incomplete grade (I) will be given in this course.

Important Note
If you have a question send me e-mail at any time, and I will try to reply to your e-mail as soon as possible.  I encourage all students to communicate with me using e-mail whenever they have questions.  I will set several  online office hours at nights and strongly encourage you to take advantage of those hours.  I also encourage you to check the announcements page periodically for updates regarding our class, assignments, etc....



Fall 2002 Academic Calendar
To view the calendar, click on the link below:
(http://www.appstate.edu/www_docs/registrar/calendar/fall02.html)

Final Exam
Noon-2:30, Tuesday 12/17/2002