 |
This course focuses on the basic principles of Database Management
Systems. Students learn why databases are important to the information age. Data
Modeling is taught using Entity Relationship diagrams. These data models are then
translated into Relational schemas as students learn about Relational Algebra,
Calculus, and Relational Database Systems. Practical experience is gained through
projects using the commercial RDBMS ORACLE. Students learn SQL (both DDL and DML),
database administration, and how to create complete database applications. The
course will culminate in a major programming project that demonstrates proficiency
in modern database technology. |
Textbooks:
- Database Systems, An Application Oriented Approach, by Kifer, Bernstein,
and LEWIS, Second Edition, ISBN 0-321-22838-3
- (Supplemental) Modern Operating
Systems, by Andrew Tanenbaum, Second Edition, ISBN 0-130-31358-0
Online
References
Syllabus (tentative):
Course Logistics:
Lectures are held Tu,Th 2:30-3:45 in Stanger 308.
The Lab
- Stanger 308:
Many of the homeworks and project will require you
to work in the lab located in Stanger 308 unless you install Oracle 10g on your
own machine. However, working up in the lab on these programming assignments is
a great way to meet other people in the course, ask me questions if I'm around,
and get to know the TA.. The lab is open from 8AM to 12AM during the week. During
some of that time the lab is used as a classroom. You can find the schedule
here.
Grading Policy:
Click here
to find out how I compute your grade. All homeworks and quizzes have the same
weight and count for a total of 40% of your grade. The final project accounts
for 30% of your grade. The Mid-Term and Final each count for 15% of your final
grade.
Late Work
Homework will be turned in at the
beginning of class on the day they are due. Late homeworks will not be accepted.
This policy is firm because homework solutions will be handed out on the due day.
Projects are due at 11:59:59 PM, on the due date. Late projects will be
accepted with a penalty of 10% per day for 3 days. After that, the project will
not be accepted.
Exams are to be taken at the specified date and time.
If you miss the exam, you will receive a 0.
Sometimes things happen. If
there are circumstances that prevent you from meeting your obligations for this
course, you need to talk to me to make arrangements IN ADVANCE.
Dropping
the Course
I want you to stay in the course! Please talk to me before
you decide to drop.
Getting Help:
| Instructor: Bob Dugan |
 |
| office | Stanger
206 | | office hours | M,W 3:45-5:00
Stanger 206 or
Stanger 308 | | office phone | 508-565-1682 |
| e-mail | bdugan@stonehill.edu |
| aol im | drbobdugan | |