CS 4400 - Introduction to Database Systems
Fall 2000

| Instructors |Textbook |Administration | Course Outline | New Stuff |







Course Listing: CS 4400. Introduction to Database Systems 3-0-3.
Prerequisite(s): CS 2330
Comprehensive coverage of mainstream database concepts such as the entity-relationship model, relational databases, query languages, and database design methodology. Includes a project.

Instructors

Section A:
Instructor:Leo Mark (leomark@cc)
Location: CCB 17 (MWF 1:00 - 2:00 pm)
Office Hours: Time (MWF 2:00 - 3:00 pm) CCB137
Phone: 4-2746
TAs: Ankur Gupta (agupta@cc), Office Hours COC Picnic Area MW:3-4:30
          Smita Ojha (smitao@cc), Office Hours CCB 104A MF:11-12:30
Section B:
Instructors:  Chris Jermaine (jermaine@cc) and
        Thom McLean (thom@cc)
Location: ESM 201 (MWF 11:00 - 12:00pm)
Office Hours:  Thom- CCB 328 (MW 12:00 - 1:30 pm)
        Chris- WF 1-2 CCB 137, WF CoC Picnic Area 3-3:30
Phone:  Thom-4-7486 Chris- 4-7008
TA: Cathy Eichholz Polk (cat@cc), Office hours CCB 148A 1-2:30 MW
.
Section C:
Instructors: Thom McLean (thom@cc) and
     Chris Jermaine (jermaine@cc)
Location: CCB 101 (MWF 2:00 - 3:00 pm)
Office Hours:  Thom- CCB 328 (MW 12:00 - 1:30 pm)
       Chris- WF 1-2 CCB 137, WF CoC Picnic Area 3-3:30
Phone:  Thom-4-7486 Chris- 4-7008
TA: Tanisha Hall (thall@cc.gatech.edu), Office Hours TBD

New Stuff (last updated September 6th)

  1. (9/6) The project description is now available here. It is in MS Word format.
  2. (9/6)This MS Word document tells you how to get started with Visual Basic and Access. While you won't actually start coding for 6 weeks or so, you can use this tutorial to help yourself get aquainted with the tools you'll need for the project.
  3. (9/6) Here (in pdf) is the example system that was modeled in class using the ER model, and here is the resulting model (in MS Power Point).
  4. (9/6) Quiz #1 has been scheduled to take place on September 20th.
  5. (9/6) Here is the take-home portion of Quiz #1, in MS Word format. This is due in class, at the time that Quiz #1 is held.  Please check the class newsgroup often for updates and questions/answers on this homework.

Reading

  1. Required Text:

    2. Elmasri and Navathe: Fundamentals of Database Systems (3rd Edition), Addison-Wesley, 2000
     
  2. Recommended Reference Books

    3. H. Korth and A. Siberschatz, Database System Concepts, McGraw-Hill Book Company, 1986.
  3. Oracle Documentation:
  4. Course NotesSlides:

    5. The course notes and project description are forthcoming.
    Notes for section A .

Prerequisite(s)

You are expected to have basic programming skills.

Grading

The grade will be determined

Project

Develop a small real-world relational database application. The details of the project are being finalized. The project description and deadlines will be given in the 3rd or 4th week.

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 (Mark) 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 (perhaps?) 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 (Mark/McLean) Notes
Data warehousing and data mining (Jermaine) 26

Last Updated: 08/23/2000