CS 4400 - Introduction to Database Systems

Jan - May 2000


| Instructors | Textbook | Administration | Course Outline |

Section A:

Instructor: Sham Navathe (sham@cc)
Location: Boggs B6A (TTh 1:30 - 3:00pm)
Office Hours: Th 10-11 and F 1:30-2:30
Phone: 4-0537
TAs:
Cathy Eichholz Polk (cat@cc), MWF 10-11 in CoC Commons
Minho Sung (mhsung@cc), MWF 3-4 in CoC Commons
Ayo Alaran (ayo@resnet.gatech.edu), T 10-11:30 and R 3-4:30 in CoC Commons
Section B:
Instructor: Ling Liu (lingliu@cc)
Location: Physics S106 (TTh 3:00-4:30pm)
Office Hours: TTh (4:30-6:00pm) at CCB 223
Phone: 5-1139
TA: Wanxia Xie (wanxia@cc),
Section C:
Instructor: Chris Jermaine (jermaine@cc)
Location: CCB 17 (TTh 1:30 - 3:00pm)
Office Hours: TBA
Phone: 4
TA: TBA (TBA@cc).
Section D:
Instructor: Leo Mark (leomark@cc)
Location: Physics S104 (TTh 3:00 - 4:30pm)
Office Hours: TuTh 1:30-3pm in CCB137
Phone: 4-2746
TA: Lilia Moshkina (lilia@cc), UPDATED! Tu 11-12:30 and Fri 8:30 - 10am, in CCB Darts Lab, second floor


Reading

  1. Required Text:
    Elmasri and Navathe: Fundamentals of Database Systems (3rd Edition), Addison-Wesley, 2000

  2. Oracle Documentation:

  3. Reading Materials for Programming in C

  4. Course Notes
    Section D


Prerequisite(s)

You are expected to know programming in C or programming in Java.


Grading


Project

Develop a small real-world relational database application.
 

For Project Schedule and Project Description, you need to go to the Section with which you are registered


Course Outline

TOPICS CHAPTER
Basic concepts - data independence, database architecture, database system components 1, 2
Relational data model - introduction and algebra 7
Conceptual database level - entity-relationship model 3, 4
Mapping from ER model to relational model 9.1, 9.2
Methodology for the analysis, specification, design and implementation of database applications Notes
Relational database design - normal forms, functional dependencies 14, 15
Relational Database Management System - Oracle 10
SQL query language 8
Embedded SQL in C programming language Notes
Relational calculus qery languages 9.3, 9.4
Internal database level - storage structures 5, 6
Database security and authorization 22
Object-oriented databases 11, 12, 13
Client-server and distributed databases 24
Database and the Web Notes
Data warehousing and data mining 26


Last Updated: 12/9/99