CS 4400 Sections A & B
Introduction to Database Systems
Summer 2006
Room/Time:
College of Computing room 17
TR 12:05pm-1:45pm Section A
Room/Time:
College of Computing room 17
TR 2:05pm-3:45pm Section B
Instructor:
Sham Navathe (sham@cc.gatech.edu). Phone: 894-0537
Office Hours:
Friday 1-2 pm (CRB 259)
Instructor:
Ed Omiecinski(edwardo@cc.gatech.edu). Phone: 894-3160
Office Hours: TR 11-11:55am CoC Commons Area or by appointment
Secretary:
Della Phinisee (della@cc.gatech.edu). Phone: 894-8358
Office: 221A CRB (Centennial Research Bldg.)
Teaching Assistants:
Instructor's Teaching Schedule:
May 16,18 Omiecinski
May 23,25 Navathe
May 30, June 1 Navathe
June 6,8 Navathe
June 13,15 Omiecinski
June 20,22 Omiecinski
June 27,29 Navathe
July 6 Navathe
July 11,13 Navathe
July 18,20 Omiecinski
July 25,27 Omiecinski
Finals Week Omiecinski
Newsgroup:
git.cc.class.cs4400
New Stuff: (last updated July 26, 2006)
Required Text:
·
Fundamentals of Database Systems, 5th edition, Elmasri & Navathe,
Addison-Wesley, 2006
Lecture Notes: Slides
for Text
Prerequisite(s): Basic Java programming skills.
Grading:
4 quizzes; 15% each
Project (PhaseI 10%,PhaseII 10%, PhaseIII 5%
(Light) or 20% (Heavy))
Final Exam 15% (ONLY for students doing
light weight project)
Project:
You will design and implement a database
application using the ORACLE relational database system available on ACME. You
may suggest an alternative implementation, but it must be approved by the instructor.
The project should be done in groups of 3-4 students.
No more than 4 students may be in a group. We will follow a typical database design methodology for this project.
The project will consist of 3 phases (deliverables) as well as a final
demonstration to the TA. Phase I and Phase II of the project are worth 10%
credit. Phase III of the project is worth 5% credit without/GUI and 20% credit
with/GUI.
All members of a group get the same grade for
each phase of the project. If a member
of a group does not carry his/her weight, then the group may remove that
member at the end of phase I or Phase II,
only. The instructor must be notified of this via email.
Course Content:
We introduce the fundamental concepts necessary
for the design and use of modern database systems. We examine the concepts in
the order that we encounter them in the actual database design process. We
start with the problem of conceptually representing data that is to be stored
in a database. From there, we see how the data in a conceptual data model can
be converted to a database specific model (e.g., the relational data model). We
also discuss various forms for relations that possess good properties. We see
how to use the relational database language SQL to define the relations and to
write SQL statements to insert, delete, retrieve and update the data. We also
examine some of the fundamental storage structures that are used in relational
database systems. We end the course with a discussion of some advanced topics
in the database management area.
|
Topic |
Chapter(s) |
|
Basic concepts - data independence, 3 level
database architecture, database system components |
1,2 |
|
Conceptual database level -
Entity-Relationship Model |
3,4 |
|
Relational Data Model: Introduction, Algebra
and Calculus |
5, 6 |
|
Mapping from ER Model to Relational Model |
7 |
|
SQL Query Language |
8, 9 |
|
Relational database design - Normal Forms,
Functional Dependencies |
10, 11 |
|
Oracle JDBC and JAVA |
Notes |
|
Internal database level - storage structures |
13, 14 |
|
Data mining |
28 |
Quiz and Project Due Dates:
| Project Schedule | Quiz Schedule | ||||
| Phase | Due Date | Quiz | Date | ||
| I | June 8 | I | June 1 | ||
| II | June 27 | II | June 15 | ||
| III | July 25 | III | July 6 | ||
| Demo | July 26-28 | IV | July 20 | ||
The final exam will be held
during the scheduled Georgia Tech final exam period for this class.