CIS3010 Oracle Development

CIS	3010	90367	2, 2009	ONC	Oracle Development	1.00	Toowoomba
Subject	Cat-nbr	Class	Term	Mode	Description	Units	Campus

Academic group:	FOBUS
Academic org:	FOB005
Student contribution band:	2
ASCED code:	020303

Staffing
Other requisites
Rationale
Synopsis
Objectives
Topics
Texts
Reference materials
Student workload
Assessment details
Important assessment information
Assessment notes
Other requirements
Production date
PDF version

STAFFING

Examiner: Glen Van Der Vyver
Moderator: Srecko Howard

OTHER REQUISITES

Students are required to have access to a personal computer, e-mail capabilities and Internet access to UConnect. Internet access is also required to use the USQ Oracle server. Students who have not previously completed CIS2002 at USQ will need to study module 1 of the Study Book in some detail in order to gain an understanding of the fundamentals of data modelling and normalisation. Current details of computer requirements can be found at <http://www.usq.edu.au/ict/students/standards/default.htm>.

RATIONALE

Large-scale databases have become core tools in modern Information Technology and are a key resource in companies of all sizes. It is therefore imperative that business students master the fundamentals of a major DBMS product and develop skills that will facilitate a critical understanding of complex business problems pertaining to databases and database management systems. The Oracle DBMS is a leading edge product which is very well established in the marketplace, and is therefore highly suitable as the software vehicle for this course.

SYNOPSIS

In this course, students build practical skills in the implementation of commercially oriented databases as well as the development of database queries and client and server-side database applications of limited scope. The course focuses on using data to solve business problems and the extraction of data that will facilitate corporate decision making. Students will gain a working knowledge of Oracle SQL and the procedural extension to SQL known as PL/SQL. The course will cover client-side as well as server-side PL/SQL, including stored procedures, functions and triggers. Finally, students extend their theoretical knowledge by studying a small number of selected topics in database theory. The course is aligned with several examinations conducted by Oracle Corporation. The course covers the syllabus (as at 1 August, 2008) of the Oracle Database SQL Certified Expert exam and a significant proportion of the syllabus of the Oracle Certified Associate (OCA) exam (in the PL/SQL Developer stream).

OBJECTIVES

The course objectives define the student learning outcomes for a course. On successful completion of this course, students should be able to:

1.: apply data modelling, normalisation and systems/business analysis skills to the creation and manipulation of database objects
2.: work comfortably in the Oracle (SQL) environment
3.: write SQL, DDL and DML statements at a variety of levels of complexity
4.: write client-side and server-side code using Oracle PL/SQL with a focus on producing reports that will facilitate business decision making
5.: demonstrate a factual and critical knowledge of a limited number of topics in database theory
6.: explain the architecture of Oracle and evaluate the extent to which it meets the requirements of selected theoretical architecture/s
7.: write PL/SQL programs, procedures, functions and triggers to solve business problems.

TOPICS

	Description	Weighting (%)
1.	Selected topics in database theory	15.00
2.	DBMS applications programming (Oracle)	85.00

TEXT and MATERIALS required to be PURCHASED or accessed

ALL textbooks and materials are available for purchase from USQ BOOKSHOP (unless otherwise stated). Orders may be placed via secure internet, free fax 1800642453, phone 07 46312742 (within Australia), or mail. Overseas students should fax +61 7 46311743, or phone +61 7 46312742. For costs, further details, and internet ordering, use the 'Textbook Search' facility at http://bookshop.usq.edu.au click 'Semester', then enter your 'Course Code' (no spaces).

CIS3010 study package available from the USQ Bookshop.

Casteel, J 2007, Oracle 10g: SQL, Thomson Course Technology, Boston, Massachusetts.

Lahey, H (ed) 2000, Information systems developers handbook: a road map for students, University of Southern Queensland, Toowoomba, Queensland.
(This handbook is available on the USQ website at <http://www.usq.edu.au/business/schools/is/isdevhandbook.htm>.)

Shah, N 2005, Database systems using Oracle: a simplified guide to SQL and PL/SQL, 2nd edn, Pearson-Prentice Hall, Upper Saddle River, New Jersey.
(international edn)

Summers, J & Smith, B 2006, Communication skills handbook: how to succeed in written and oral communication, 2nd edn, John Wiley & Sons, Milton, Queensland.

REFERENCE MATERIALS

Reference materials are materials that, if accessed by students, may improve their knowledge and understanding of the material in the course and enrich their learning experience.

Casteel, J 2003, Oracle 9i developer: PL/SQL programming, Thomson Course Technology, Australia.

Connolly, T & Begg, C 2005, Database systems: a practical approach to design, implementation, and management, 4th edn, Addison-Wesley, Boston, Massachusetts.

Morrison, J & Morrisson, M 2003, A guide to Oracle 9i, Thomson/Course Technology, Boston, Massachusetts.

Rob, P & Coronel, C 2009, Database systems: design implementation and management, 8th edn, Thomson/Course Technology, Boston, Massachusetts.

Sunderraman, R 2004, Oracle8 programming: a primer, 2nd edn, Addison-Wesley, Reading, Massachusetts.

STUDENT WORKLOAD REQUIREMENTS

ACTIVITY	HOURS
Lectures	12.00
Practical Classes	24.00
Private Study	139.00

ASSESSMENT DETAILS

Description	Marks out of	Wtg(%)	Due date	Objectives assessed	Notes
ASSIGNMENT 1	100.00	1.00	07 Aug 2009	3, 5, 6	(see note 1)
ASSIGNMENT 2	100.00	1.00	10 Sep 2009	3, 5, 6	(see note 2)
ASSIGNMENT 3	100.00	8.00	28 Sep 2009	1, 2, 3	(see note 3)
PRACTICAL TEST	100.00	13.00	12 Oct 2009	1, 2, 3, 4, 7	(see note 4)
ASSIGNMENT 4	100.00	12.00	19 Oct 2009	2, 4, 5, 6, 7
EXAMINATION - PART A	10.00	7.00	END S2	1, 3, 4, 5, 6, 7	(see note 5)
EXAMINATION - PART B	90.00	58.00	END S2	1, 3, 4, 5, 6, 7

NOTES

1.: Assignment 1 comprises an online multiple choice test.
2.: Assignment 2 comprises an online multiple choice test.
3.: Assignments 3 and 4 must be submitted electronically via EASE.
4.: The practical test will be held during the final two weeks of the semester. It will assess work completed during tutorials.
5.: The examination is scheduled to be held in the end-of-semester examination period. Students will be advised of the official examination date for exam (parts A and B) after the timetable has been finalised. The total working time for exam (parts A and B) is 2 hours.

IMPORTANT ASSESSMENT INFORMATION

Attendance requirements:
It is the students' responsibility to attend and participate appropriately in all activities (such as lectures, tutorials, laboratories and practical work) scheduled for them, and to study all material provided to them or required to be accessed by them to maximise their chance of meeting the objectives of the course and to be informed of course-related activities and administration.
Requirements for students to complete each assessment item satisfactorily:
To satisfactorily complete an individual assessment item a student must achieve at least 50% of the marks. (Depending upon the requirements in Statement 4 below, students may not have to satisfactorily complete each assessment item to receive a passing grade in this course.)
Penalties for late submission of required work:
If students submit assignments after the due date without prior approval of the examiner, then a penalty of 5% of the total marks gained by the student for the assignment may apply for each working day late up to ten working days at which time a mark of zero may be recorded. No assignments will be accepted after model answers have been posted. Model answers will be posted on the discussion group approximately ten days after the due date.
Requirements for student to be awarded a passing grade in the course:
To be assured of receiving a passing grade a student must achieve at least 50% of the total weighted marks available for the course.
Method used to combine assessment results to attain final grade:
The final grades for students will be assigned on the basis of the aggregate of the weighted marks obtained for each of the summative assessment items in the course.
Examination information:
This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination.
Examination period when Deferred/Supplementary examinations will be held:
Any Deferred or Supplementary examinations for this course will be held during the next examination period.
University Regulations:
Students should read USQ Regulations 5.1 Definitions, 5.6 Assessment, and 5.10 Student Academic Misconduct for further information and to avoid actions which might contravene university regulations. These regulations can be found at <http://www.usq.edu.au/corporateservices/calendar/part5.htm>. Students should also read the Faculty of Business Procedures which can be found at <http://www.usq.edu.au/business/aboutfob.htm>.

ASSESSMENT NOTES

1.	Assignments: (i) The due date for an assignment is the date by which a student must submit the assignment to the USQ. (ii) Students must retain a copy of each assignment submitted for assessment. This must be produced within 24 hours if required by the examiner. (iii) In accordance with university policy, the examiner may grant an extension of the due date of an assignment in extenuating circumstances. (iv) The examiner will normally only accept assessments that have been written, typed or printed on paper-based media. (v) In the event that a due date for an assignment falls on a local public holiday in their area, such as a show holiday, the due date for the assignment will be the next day. Students are to note on the assignment cover the date of the public holiday for the examiner's convenience.
2.	Course weightings: Course weightings of topics should not be interpreted as applying to the number of marks allocated to questions testing those topics in an examination paper.
3.	Referencing in assignments: Harvard (AGPS) is the referencing system required in this course. Students should use Harvard (AGPS) style in their assignments to format details of the information sources they have cited in their work. The Harvard (AGPS) style to be used is defined by the USQ Library's referencing guide at <http://www.usq.edu.au/library/help/referencing/default.htm>.
4.	Make-up work: Students who have undertaken all of the required assessments in a course but who have failed to meet some of the specified objectives of a course within the normally prescribed time may be awarded the temporary grade: IM (Incomplete - Make up). An IM grade will only be awarded when, in the opinion of the examiner, a student will be able to achieve the remaining objectives of the course after a period of non-directed personal study.
5.	Deferred work: Students who, for medical, family/personal, or employment-related reasons, are unable to complete an assignment or to sit for an examination at the scheduled time may apply to defer an assessment in a course. Such a request must be accompanied by appropriate supporting documentation. One of the following temporary grades may be awarded: IDS (Incomplete - Deferred Examination); IDM (Incomplete Deferred Make-up); IDB (Incomplete - Both Deferred Examination and Deferred Make-up).

OTHER REQUIREMENTS

E-mail and Internet access: Students require access to e-mail and Internet access to UConnect for this course. Students also require a PC and Internet access for a connection to the USQ Oracle server. The PC should have the following specifications: Pentium 4 or above; 8 GB free disk space; 512 MB of memory, although 256 MB may be sufficient.
Some study materials and important information about the course will be made available via the online discussion group. Students are therefore expected to access the discussion group regularly and read all postings.

This version produced 19 Nov 2009.