Back to course home page| Semester: | Spring, 2004 | ||
|---|---|---|---|
| Course Number: | CSEU 3500 | ||
| Course Title: | Data Base Systems | ||
| Instructor: | Dr. Robert K. Moniot | ||
| LC Office LL 817-E, Phone (212) 636-6311 | |||
| LC Office hours : MR 10:15-11:15, W 4:30-5:40 | |||
| RH Office FR 111-B, Phone (718) 817-5206 | |||
| RH Office hours : T 11:00-12:00 | |||
| Other office hours by appointment | |||
| E-mail: moniot@fordham.bogus.edu | |||
| URL: http://www.dsm.fordham.edu/~moniot | |||
| Class Hours: | W 6:00-8:45 Room LL 520 | ||
| Text: | Database System Concepts, 4th ed., by Silberschatz, Korth and Sudarshan (McGraw-Hill, 2002, ISBN 0-07-255481-9) |
Course Outline:
| Date | Chapter | Topic |
| Jan. 21 | 1 | Terminology and overview. |
| Jan. 28 | 2 | Entity-Relationship Model. Attributes and keys. E-R diagrams. (Skip §2.10) |
| Feb. 11 | 3 | Relational model. Relational Algebra. Views. (Skip §§3.6-3.7.) |
| Mar. 3 | 4 | The SQL language. Constructing queries. (Skip §§ 4.10, 4.12-4.14.) |
| Mar. 31 | 6 | Database integrity. (Skip §§6.5-6.7.) |
| Apr. 21 | 7 | Relational database design. Pitfalls and anomalies. Functional dependencies. Normalization. |
Protocol: Grade will be based on homework (30%), quizzes
(30%) and a final exam (40%).
Test Dates: Ten-minute quizzes will be given approximately every 2
weeks (announced one week in advance).
Final Exam: May 12.
Prerequisite: CS 1600--Computer Science I or permission.