CSCI 4370-6370
Database Management

John A. Miller
Fall 2004

---

Textbook

Database Systems: The Complete Book,
Garcia-Molina, Ullman and Widom, 2002

---

Class Time (in GSRC 306)

Day	Period 4	Period 73
.	11:15 - 12:05	11:00 - 12:15
Monday	Recitation	x
Tuesday	x	Class
Thursday	x	Class

---

Course Description

A comprehensive course on the use and implementation of Database Management Systems (DBMSs).

---

Course Topics

• Introduction (Ch. 1)
• Entity-Relationship Model (Ch. 2)
• Relational Model (Ch. 3: 3.1-3.3)
• Normalization Theory (Ch. 3: 3.4-3.7)
• Object Model (Ch. 4: 4.1-4.4)
• Object-Relational Model (Ch. 4: 4.5)
• Relational Algebra (Ch. 5)
• SQL (Ch. 6)
• Data Storage (Ch. 11)
• Representing Data Elements (Ch. 12)
• Index Structures (Ch. 13)
• Query Execution (Ch. 15)
• Query Compiler (Ch. 16)

---

Grading

20%	Exam I	.
20%	Exam II	.
25%	Final	.
30%	Programs (groups of 2)	[languages: Java 1.5.0, MySQL 4.1]
5%	Homework	[presentation]

---

Projects

Number	Description	Due
1	RA Operators: Select, Project, Union	August 30
2	Additional Operators: Join, Minus; Persistence	September 9
3	Implement FileList	September 20
4	Implement TreeMap and HashMap	September 30
5	Implement MyMap	October 11
6	Compare TreeMap, HashMap and MyMap (98 + bonus)	October 21
7	Support Interactive Queries in MyRA	November 1
8	Top Ten Queries in MySQL and MyRA (PG#5)	November 11
9	Database application with Web access to a database	November 22

---

Policies

• Late Points - 10 points off per day late.
• Make-Up Tests - written pre-approval or medical documentation required