CS 3430 - Introduction to Database Systems

Fall 2007- Course Syllabus

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-10:00 and MWF 12:00-1:00
Class Time/Location: MWF 10:00-10:50 /Room 307 CAP
Lab Location: Room 336 or 439 CAP
Final Exam: Thursday, December 6, 2007 from 9:00 AM - 11:30 AM
CS2490 (Introduction to Theoretical Computer Science)

Fundamentals of Database Systems, R. Elmasri and S. B. Navathe, Addison Wesley, 4th 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 modeling 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
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.  You will approach the project as a software engineer and a database developer.  You are required to record your activities regarding the project in a log book.  You will be graded based on your individual performance and activities, and your contributions to the project.  More details will be given on the procedure during the semester.

Grading policy
The following grading scale will used in this course:
                        Two Exams  15% each,
                        Final exam, 20%,
                        Assignments 15%,
                        Team Project 25%, and
                        Quizzes and Class Participation %10.

Students are required to attend all classes.  Each unexcused absence will result in a 3 point drop from the semester grade.  Students with more than 8 absences will fail the course.  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 such cases, student's final exam's grade will be used for the missed exam.

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.  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 an e-mail at any time, and I will try to reply to your e-mail as soon as possible.  I encourage you to communicate with me using e-mail whenever you have questions.  I also encourage you to check the announcements page periodically for updates regarding our class, assignments, etc....

Fall 2007 Academic Calendar
To view the calendar, click on this link: (http://www.registrar.appstate.edu/calendar/fall07.html)