The course addresses the engineering of software application systems with extensive use of client-server database components. It encompasses all phases of the lifecycle of a software system, including planning, analysis, design, implementation, testing, and operation and maintenance. In a team project students participate in the development of an integrated medium-size information system that uses Oracle - a contemporary large database management system. The following Oracle subsystems are introduced and used: Oracle SQL Plus, PL/SQL, Forms Builder, and Report Builder.

Textbook:

Morrison, J., Morrison, M. (2005) Guide to Oracle 10g, Thomson

Class notes and additional course materials will be posted on the N: drive in the folder N:/Class/GanchevG/CS305

Attendance: You are expected to be present for each class session.

Assessment: Three semester test, team project, and a final exam (2 hours).

Grading:

Semester tests . . . . . 30%

Practical assignment . . 30%

Final exam . . . . . . . 40%

Tentative Schedule of Topics:

Date	Session	TOPIC	Reference
Mo, Jan 23	1.	Introduction to the course. Overview of Software Processes	Notes
We, Jan 25	2.	Requirements and Design	Notes
Mo, Jan 30	3.	Information Engineering Methodology	TBA
We, Feb 01	4.	Information Engineering Methodology	TBA
Mo, Feb 06	5.	Project Management	Notes
We, Feb 08	6.	Project Management	Notes
Mo, Feb 13	7.	SQL revision	Ch.3
We, Feb 15	8.	SQL revision	Ch.3
Mo, Feb 20		Holiday
We, Feb 22	9.	PL/SQL	Ch. 4
Mo, Feb 27	10	PL/SQL	Ch. 4
We, Mar 01	11.	PL/SQL	Ch. 4
Mo, Mar 06	12.	User Interface Design	TBA
We, Mar 08	13.	Introduction to Form Builder	Ch. 5
Mo, Mar 13	14.	Creating custom forms	Ch. 6
We, Mar 15	15.	Creating custom forms	Ch. 6
Mar 20-25		Break
Mo, Mar 27	16.	Creating database reports	Ch. 7
We, Mar 29	17.	Creating database reports	Ch. 7
Mo, Apr 03	18.	Creating database reports	Ch. 7
We, Apr 05	19.	Example integrated application	Ch. 8
Mo, Apr 10	20.	Example integrated application	Ch. 8
We, Apr 12	21.	Advanced SQL and PL/SQL topics	Ch. 9
Mo, Apr 17	22.	Advanced SQL and PL/SQL topics	Ch. 9
We, Apr 19	23.	Advanced Form-Builder topics	Ch.10
Mo, Apr 24	24.	Advanced Form-Builder topics	Ch.10
We, Apr 26	25.	Software Prototyping	TBA
Mo, May 01	26.	Verification, Validation and Testing	TBA
We, May 03	27.	Architectural Design and Distributed Systems Architectures	TBA
We, May 08	28.	Design with Reuse	TBA
We, May 10	29.	Software Evolution	TBA