CS 4400 Sections A and B
Introduction to Database Systems
Summer 2008
Section A: KACB
1456 (TTH
Section B: KACB
1456 (TTH
Professors
Sham Navathe (sham@cc.gatech.edu). Phone: (404) 894-0537
KACB (
Office Hours: Thursday
Ed Omiecinski (edwardo@cc.gatech.edu). Phone: (404) 894-3160
KACB (
Office Hours: Tuesday and Thursday
4-5 PM
Admin Assistant: Deborah Mitchell (deborah@cc.gatech.edu).
Phone:
404-385-2892
Office: 3342 KACB
Instructor's Teaching Schedule (Tentative):
[Changes to this schedule will be posted when applicable]
May 13,15 Navathe
May 20, 22 Navathe
May 27, 29 Navathe
June 3 Navathe
June 5,10,12 Omiecinski
June 17,19 Navathe
June 24,26 Navathe
July 1,3 Omiecinski
July 8,10 Omiecinski
July 15,17 Omiecinski
July 22, 24 Omiecinski
July 28-31 Final Exam
Teaching Assistants (All TA
office hours are in the CoC Commons area)
Neha Sugandh ( Office Hours: Monday and Wednesday
11:30AM - 1PM Zhigang Hua( Office Hours: Tuesday 9-11AM and Friday 10-11AM
Minh Quoc Nguyen ( Office Hours: Monday 1-2PM and Friday 11AM-1PM
Newsgroup:
git.cc.class.cs4400
(Monitored by TAs on Monday through Friday) New Stuff: (last updated Required Text: Fundamentals of Database Systems, 5th edition, Elmasri & Navathe, Addison-Wesley, 2007. Lecture Notes: Slides
for Text Data
Mining Slides (for Prof. Omiecinski's class) Database Design Methodology Notes: Database Design Methodology Notes Oracle, SQL, Java, JDBC Information: Oracle, SQL,
Java, JDBC information Sample Quizzes: Quiz 1 Quiz 2 Quiz 3 Quiz 4 Class Project (updated version): 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. The
Project can be done in groups of 3-4 students.
We will follow a typical database design methodology for this project.
Notes describing the methodology will be available via the class web page. 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
kick out that member at the end of phase
I or Phase II, only. The course professors should be notified of this. 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 DBMS Design Methodology
(Part I): Analysis and Specification notes Relational Data
Model: Introduction, Algebra and Calculus 5, 6 SQL Query
Language 8 Mapping from ER
Model to Relational Model 7 Relational database
design - Normal Forms, Functional Dependencies 10, 11 Oracle JDBC and
JAVA Notes DBMS Design
Methodology (Part II): Design and Implementation Notes Internal database
level - storage structures 13, 14 Data warehousing and
data mining 28, 29 IMPORTANT DATES: Due Dates: June 3 (Tu) – Quiz 1 June 10 (Tu) – Project
Phase 1 June 19 (Th) – Quiz 2 July 3 (Th) – Project
Phase 2 July 8 (Tu) – Quiz 3 July 17 (Th) – Quiz 4 July 22 (Tu) - Project
Phase 3 Quiz Topic Date OI DB Concepts & ER/EER Model June 3 QII Relations,
Algebra & Calculus June 19 QIII
QBE, SQL and ER to Relational Mapping July 8 QIV Normalization and
Physical Design July 17 Final Cumulative Week of July 28 Project Schedule Phase Due
Date PI June 10 PII July 3 PIII July 22 Demo July 23-25
