Office Hours : Mon 9:15am – 11:15am

Course webpage: http://web2.uwindsor.ca/courses/cs/rituch/470/index.html

Aim of the course: To be able to use an RDBMS for Systems Development - specifically, to create an application software from scratch to implementation using Oracle DBMS tools for both front-end and back-end.

Course Requirements:

Projects must be done using Oracle Tools

ü SQL – DML, DDL

ü SQL*Plus

ü PL/SQL – PL/SQL blocks, procedures, functions, triggers, exceptions

ü Oracle Forms

ü Oracle Reports

Students have to work in groups.

The title of the project must be emailed to me at rituch@uwindsor.ca by the 20^th of January.

Midterm: In the week of 21st February, each group has to give a 10-minute presentation on the progress it has made in developing their application. A written report of the same must be handed over as well.

In the week of 11^th April, the final presentation has to be given - each group is required to

1. Demonstrate the application developed which will be followed by a viva-voce.

2. Submit a printed report (approximately 2500 in words), which must include:

ü The basic characteristics of the tools used

ü A detailed case study describing the development of a non-trivial

application done by your group. This must include

Ø An Entity Relationship Diagram representing your application

Ø The database design (Basically , the set of normalized relations forming your database, keys, indexes etc)

Ø The Interfaces used in your application (Forms and reports)

ü System and User documentation.

ü Source Codes(if applicable)

Although our classes are scheduled for T,R at 10:0am in DH 263, we need not meet every week as this is not a teaching course. You can contact me in person or through email whenever u need help.

Assessment:

Midterm:: Presentation in the week of 21^st February: 20 %

Final:: (Week of 11^th April)

Demonstration of the application developed: 30%

Viva Voce (written or oral): 15%

Report: 35 %

Reference Book: Oracle 9i Developer: Developing web applications with Forms Builder By John Adolph Palinski (Thomson – Course Technology)

§ Teaching Evaluation

Student Evaluation of Teaching (SET) forms will be administered during the last two weeks of the class schedule.

Grading Scheme:

% Score	Grade	% Score	Grade
93-100	A+	63-66.9	C
86 – 92.9	A	60-62.9	C-
80 – 85.9	A-	57-59.9	D+
77-79.9	B+	53-56.9	D
73-76.9	B	50-52.9	D-
70-72.9	B-	35 – 49.9	F
67-69.9	C+	< 35	F-

Please check the course web page on a regular basis – the schedule for midterm and finals shall be posted on the web soon, besides other information / resources.