CS 4400 Sections A, B, C
Introduction to Database Systems
Spring 2008
Section A: CoC
17 (TTH
Section B: KACB
1447 (MWF
Section C: KACB
2447 (MWF
Professors
Sham Navathe (sham@cc.gatech.edu). Phone: (404) 894-0537
KACB (
Office Hours: Tuesday/Thursday
Ed Omiecinski (edwardo@cc.gatech.edu). Phone: (404) 894-3160
KACB (
Office Hours: MWF
Teaching Assistants (All TA
office hours are in the CoC Commons area)
Aditya Sakhuja (aditya.sakhuja@gatech.edu).
Office Hours: Monday, Wednesday, Friday 9:00am - 10:00am
Muhammad Haider(mhaider3@cc.gatech.edu).
Office Hours: Monday, Wednesday 1:30pm - 3:00pm
Yarong Tang(yarongt@cc.gatech.edu).
Office Hours: Tuesday, Thursday 10:00am - 11:30am
Nikhil Almeida(nikhil.almeida@gatech.edu).
Office Hours: Tuesday, Thursday 12:00pm - 1:30pm
Priyanka Prabhu(priyankaprabhu@gmail.com).
Office Hours: Tuesday, Wednesday 3:30pm - 5:00pm
Danupon Nanongkai(danupon@gmail.com).
Office Hours: Friday 3:30pm - 5:00pm
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, 2006.
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): Career Service Database Project
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 professor 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 |
|
Client-server and
distributed databases |
25 |
|
Quiz |
Topics |
Quiz
Date |
|
|
Section A |
Sections B & C |
||
|
OI |
DB
Concepts & ER/EER Model |
January
31 |
January
30 |
|
QII |
Relations,
Algebra & Calculus |
February
21 |
February
20 |
|
QIII |
Domain
Calculus, QBE, SQL and ER to Relational Mapping |
March
13 |
March
12 |
|
QIV |
Normalization
and Physical Design |
April
17 |
April
16 |
|
Final |
Cumulative |
GT
schedule |
|
|
Project Schedule |
|
|
Phase |
Due Date |
|
PI |
February 15 |
|
PII |
March 14 |
|
PIII |
April 21 |
|
Demo |
April 22-25 |