Summer Semester 2000 (MWF 12-1:10)
Space Science Technology Bldg. Lecture Room 2
Professor: Ed Omiecinski (edwardo@cc.gatech.edu)
Phone: 894-3160
Office: CoC 138
Office Hours: 1:30-2:30 pm (MW)
TA: Cathy Polk (cat@cc.gatech.edu)
Office: COC Commons Area
Office Hours: 1:10-2:30 (M) 10:30-12 (W)
TA: Hao Wang (wanghao@cc.gatech.edu)
Office: COC Commons Area
Office Hours: 1:30-3pm (Th,F)
TEXT:
Fundamentals of Database Systems, 3rd edition, Elmasri Navathe, Addison-Wesley, 2000
ORACLE Documentation Site: http://aistweb.gtri.gatech.edu/oracle
PROJECT:
You will design and implement a database application using the ORACLE relational database system available on ACME (acmex, acmey, acmez). We will use the embedded SQL (relational query language) feature of ORACLE, called , which allows us to embed SQL statements in a C program. The project can be done in groups of 2 or 3 students. Here is the notes (PS format) about the Database Design Methodology we will use for the project.
The class project will be posted in the newsgroup git.cc.class.cs4400a and/or the class web page (which can be located via http://www.cc.gatech.edu/classes/AY2000/cs4400a_summer/CS4400a_project.htm). You should read this newsgroup and web page regularly to ensure that you do not miss important information about the course. The project will consist of 3 phases (deliverables) as well as a final demonstration to the TA.
Project Schedule
Phase Due Date
----- --------
I June 5
II June 26
III July 24
Project demo will be done between July 24-July 28
COURSE CONTENT:
In this course 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. Next, we look at the topic of security and authorization in relational databases. We end the course with a discussion of some current/advanced topics in the database systems area.
Topic |
Chapter |
|
Primer on C programming language |
notes |
|
Basic concepts - data independence, 3 level database architecture, database system components |
1, 2 |
|
Relational data model introduction 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 query 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 |
|
Data warehousing and data mining |
26 |
GRADING:
1 midterm - 25%
1 final exam - 35%
1 Project - 40%
The Midterm exam will be held in class on Monday, June 19.
The Final exam will be held during the scheduled final exam time period.