CSC443 Database Management Spring 2006
Course Webpage: http://www.adelphi.edu/~pe16132/csc443
Course#: 0145-443-001 Data Base Management
Systems
Time: MWF
11:00 am-11:50 am in Computer Lab
Science Lab 227
Instructor: Professor Pepper
Office: Alumni Room 114 or Science Lab
227:
Telephone: 516-747-2362, but leave a message
with your phone number.
Office Hours: Tuesday & Thursday
12:15-1:30; Wed 12-12:30
E-mail: pepper@adelphi.edu
http://www.adelphi.edu/~pe16132
Blackboard: http://my.adelphi.edu/
Description: Course Description:
In-depth analysis of
the hierarchical, network, and relational database models. Objectives of
database processing. Storage structures and access methods. Database design and
normalization, normal forms. Relational algebra and calculus. Programming assignments will be done
using Access or Oracle 9i under the Panther Unix operating system.
At the end of this course, you will be able to do the following:
Prerequisites: CSC343 Data Structures.
Textbooks:
Database System Concepts, Fifth Edition, by A. Silberschatz, H. F. Korth, and S. Sudarshan, McGraw-Hill Publishing Company, 2006, ISBN: 0-07-295886-3
Oracle 9i Programming - A Primer, by R. Sunderraman,
Addison-Wesley, 2003, ISBN: 0-321-19498-5.
Grading Distribution: 2 projects: 40%; homework assignments: 20%;
Midterm: 20%; Final: 20%.
Course Requirements:
The midterm must be
completed as a minimum for credit.
Each exam must be taken at the time scheduled. Regardless of the reason, 2% will be dropped for anything 1 day
late. 10% will be dropped for anything 1 week late.
All assignments must
be done individually unless specified otherwise. Each student must hand
in hard copy of your programs (with full comments and documentation) and
running results with adequate testing cases, and the source code. (The code can
be submitted via an e-mail attachment, my digital dropbox, or the assignment
discussion board.) Instructions on how to run your programs must be in the README file. Please include your name and
e-mail address both in the README file and on the hardcopy.
Schedule
This is a weekly schedule. All reading should be done by the beginning of the week.
|
wk |
Date |
Subject |
DB Cpts |
Oracle 9i pgming |
Major Assignments |
|
1 |
1/25,
1/27 |
Intro |
1 |
1-1.4 |
|
|
2 |
1/30,
2/1, 2/3 |
Access introduction |
|
|
|
|
3 |
2/6, 2/8,
2/10 |
Access |
6 |
|
|
|
|
2/7 |
2/7 -
last day to add |
6 |
|
|
|
4 |
2/13,
2/15, 2/17 |
E-R Model |
6 |
|
|
|
5 |
2/20,
2/22, 2/24 |
ER Model |
2
|
1.5 |
|
|
|
|
2/21 -
last day to drop |
|
|
|
|
6 |
2/27,
3/1, 3/3 |
Relational
Model |
2, |
|
|
|
7 |
3/6, 3/8,
3/10 |
Relational
Queries |
2 |
|
Access Project Due |
|
8 |
3/13,
3/15, 3/17 |
Review |
|
|
|
|
9 |
3/20,
3/22, 3/24 |
SQL |
3 |
2 |
Midterm |
|
10 |
3/27,
3/29, 3/31 |
SQL |
3 |
2 |
|
|
|
|
3/31 -
last day to withdraw |
|
|
|
|
11 |
4/3, 4/5,
4/7 |
SQL; Importing
Data using sqlldr |
3 |
2 |
|
|
|
4/10-
4/16 |
spring
break |
|
|
|
|
12 |
4/17,
4/19, 4/21 |
Integrity,
Security, Authorization & Authentication Be able
to query to answer questions |
4.1-3; 8.6-8 |
|
|
|
13 |
4/24, 4/26,
4/28 |
Oracle
Connections to other Lang |
4.4-4.6 |
|
|
|
14 |
5/1, 5/3,
5/5 |
Functional
Dependencies; Closure; Cononical Cover |
7 |
|
Major Project II Due |
|
15 |
5/8 |
Review |
|
|
|
|
|
5/10 |
emergency
day |
|
|
|
|
FINAL |
5/12,
5/15 or 5/17 |
See
Adelphi Final Schedule |
|
|
Final |