back Back to course home page

FORDHAM UNIVERSITY
Fordham College at Lincoln Center

Department of Computer & Information Sciences

SYLLABUS


 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.




Robert Moniot 2004-01-08