Professor

Rick Schumeyer
Mendel 291web: www.csc.villanova.edu/~rschumey/csc4480
(302) 893-4083
Office HoursTuesday, Thursday 2:30 - 3:30.
Other hours by appointment.

Lecture

Tuesday, Thursday 4:00 - 5:15 Mendel G86

Textbook

Book Cover R. Ramakrishnan and J. Gehrke, Database Management Systems, Third Edition, McGraw-Hill, 2003.

Course Description

The purpose of the course is to introduce students to the use of current database systems.

This course presents databases from an applications perspective. The topics to be covered include database design, normalization, the relational model, SQL, and transactions.

Each student will also develop a database application.  This project will include schema design, implementation within a commercial database system, and the use of an appropriate interface such as JDBC.

Course Requirements

All assignments are due at the beginning of the class period.  Depending on the nature of the assignment, the assignments may be physically handed in, or emailed to the professor.

Late assignments will not be accepted.  Partial credit may be given for incomplete assignments turned in by the due date.

If you must miss an exam, notify the professor before the exam.

It is occasionally necessary to communicate to the class between regular class meetings.  All such communication from the professor will be sent to your Villanova email address.

Evaluation

3 Exams 300
Final 100
Homework 200
Quizzes 100
   
Total 700

 

Grade A A- B+ B B- C+ C C- D+ D D-
Min % 95 90 87 83 80 77 73 70 67 63 60

Ethics

Please see the Villanova Policy on Academic Integrity and the Department of Computing Sciences Academic Integrity Policy .

Address any questions to the professor.

Resources

Data Modeling CoverG. Simsion and G. Witt, Data Modeling Essentials, 3rd ed., Elsevier, 2005.

 

 

Oracle Database Concepts, 10g Release 2, part number B14220-02, October 2005.

Oracle SQL Developer

Oracle JDBC Guide