The University of Maryland Baltimore County
Department of Information Systems
IFSM 420 Advanced Database Projects
Instructor: Aryya Gangopadhyay
E-mail: gangopad@umbc.edu
Office: ACIV 481
Phone: 455-2620
Office Hours: Monday 1:00pm-5:00pm, or by appointment
Class Time: Monday 5:30 - 6:45
Lecture: LH6
Lab:
0101 M..........7:00pm- 8:15pm (ECS 333)
0102 M..........2:30pm- 3:45pm (ECS 333)
0103 W..........4:00pm- 5:15pm (ECS 333)
0104 M..........4:00pm- 5:15pm (ECS 333)
0105 W..........5:30pm-6:45pm (ECS 333)
Lab instructor 1 : Preeti Prabhu
Lab instructor 2: Sharada Natarajan
E-mail: loboprab@gl.umbc.edu
E-mail: snatar4@gl.umbc.edu
Office:
Office:
Phone:
Phone:
Office Hours:.
Office hours:
Course objectives:
The purpose of this course is to provide hands-on coverage
of database application development and administration. Topics that
will be covered in class include client/server databases, implementing
business logic in database applications, database administration, and web
database connectivity. Students will have hands-on experience using
Oracle8 database management system, SQL, PL/SQL, Developer/2000 including
Forms and Reports.
Required Text: Morrison, J. and Morrison, M., "A
Guide to Oracle8", Course Technologies, 2000
Other Materials: as supplied in class
Exams and grading:
| Midterm Exam |
25%
|
| Final Exam |
40%
|
| Problem solving cases |
10%
|
| Term project |
15%
|
| Lecture and lab attendance |
10%
|
Assignments:
This is a hands-on course. Hence, students will be expected
to complete a variety of assignments during the course. The course is designed
around self paced tutorials supplemented with lectures and problem solving
cases. The tutorials provide step-by-step instructions for how to
develop new application components. At the end of each chapter are
problem solving cases that allow you to create an application similar to
the ones described in the chapter. You need to complete the tutorials
prior to working the problem solving cases. In addition, students
in groups of two will develop a comprehensive term project using a real-life
project of their choice. The project submission schedules are
shown below.
| Deliverable |
Date |
| Proposal |
2/28/00 |
| Database structure (tables with data and constraints) |
3/27/00 |
| Final project report with completed application |
5/15/00 |
All projects are expected to be delivered in class on the
days specified in the schedule. Any late assignments will be subject to
a 10% penalty (for each delayed day) and will in no case (unless prior
arrangements have been made with the instructor) be accepted after Friday
of the week the assignment is due.
Academic integrity:
Cheating in any form, during exams or projects will be
subject to discipline according to university regulations. Projects that
contain plagiarized materials will receive an automatic letter grade of
'F'. Multiple violations will be handled according to university regulations.
Tentative class schedule:
|
Week
|
Date |
Topic
|
|
1
|
1/31/00 |
Introduction to client/server
databases, Lab. organization |
|
2
|
2/07/00 |
Creating and modifying database
tables and constraints |
|
3
|
2/14/00 |
Querying the database using SQL |
|
4
|
2/21/00 |
Querying the database using SQL |
|
5
|
2/28/00 |
Implementing business logic using
PL/SQL |
|
6
|
3/6/00 |
Creating Oracle data block forms |
|
7
|
3/13/00 |
Midterm Exam |
|
8
|
3/27/00 |
Creating custom forms |
|
9
|
4/3/00 |
Developing forms for business
applications |
|
10
|
4/10/00 |
Developing Reports |
|
11
|
4/17/00 |
Developing Reports |
|
12
|
4/24/00 |
Creating Integrated database application |
|
13
|
5/1/00 |
Database administration |
|
14
|
5/8/00 |
|
|
15
|
5/15/00 |
Project report due |