CIS3010 Oracle Development
|Semester 2, 2012 On-campus Toowoomba|
|Faculty or Section :||Faculty of Business and Law|
|School or Department :||School of Information Systems|
|Version produced :||30 December 2013|
Examiner: Glen Van Der Vyver
Moderator: Srecko Howard
It is highly recommended that students complete CIS2002 or an equivalent course before commencing this course. 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, normalisation and SQL. Current details of computer requirements can be found at http://www.usq.edu.au/current-students/support/computing/hardware.
The database is an integral and essential component of the overwhelming majority of information systems. The efficient daily operations of the organization, its business intelligence and long-term sustainability are all significantly dependent upon well managed and optimised databases. The vast majority of commercial applications utilise corporate databases extensively and many software vendors such as Oracle have designed procedural languages specifically to address the complex demands of database processing. It is desirable that students master the fundamentals of a major DBMS product and develop a critical understanding of current database technologies and trends, and their impact upon business. Students should also develop skills that will facilitate a critical understanding of complex business problems pertaining to databases and database management systems. Finally, it is also desirable that students develop practical skills in writing server-side and client-side applications of limited scope using a procedural database language.
This course complements CIS2002 and an important focus is the architecture of the Oracle DBMS and procedural database programming in the Oracle environment. Students also extend and develop their critical knowledge of key topics and trends in database theory and practice, often in alignment with the applied coverage of Oracle. Beginning with a rapid review of SQL, the course moves into an extensive coverage of PL/SQL, Oracle's procedural extension to SQL. The course covers client-side as well as server-side PL/SQL, including anonymous blocks, packages, stored procedures, functions and triggers. Students gain extensive practical skills writing PL/SQL applications of limited scope to solve business problems and / or address business requirements. The course operates within a framework that focuses on developing business problem-solving and communication skills, and extensive use is made of business case studies of limited scope. This course and CIS2002 together provide students with extensive hands-on exposure to the Oracle DBMS and cover a significant proportion of the syllabus for the OCP (Oracle Certified Professional) designation. Upon completion of both courses, highly motivated students should be in a position to attempt two of the three papers leading towards the OCP and, depending upon the options chosen, become candidates for the designations of OCA (Oracle Certified Associate) and Oracle Database SQL Expert. In terms of our long-standing membership in the Oracle Academic Initiative, on-campus students are exposed to materials and exercises taken from official Oracle training courses and selected assessments are based upon these presentations.
On successful completion of this course, students should be able to:
- write client-side and server-side applications of limited scope using Oracle PL/SQL
- demonstrate a factual and critical knowledge of a limited number of topics in database theory and trends, focusing on database administration
- explain the architecture of Oracle, evaluate the extent to which it meets the requirements of selected theoretical architecture/s and understand the implications of this architecture for data-centric applications
- create and maintain Oracle users and other database objects, including sequences, indexes and synonyms
- write PL/SQL programs, procedures, functions, triggers and packages to solve applied business problems and specifications.
|1.||Selected topics in database theory/trends||20.00|
(i) Oracle architecture
(ii) DBMS applications programming (Oracle)
(iii) The Oracle DBA
Text and materials required to be purchased or accessed
ALL textbooks and materials available to be purchased can be sourced from USQ's Online Bookshop (unless otherwise stated). (https://bookshop.usq.edu.au/bookweb/subject.cgi?year=2012&sem=02&subject1=CIS3010)
Please contact us for alternative purchase options from USQ Bookshop. (https://bookshop.usq.edu.au/contact/)
Casteel, J 2008, Oracle 10g developer: PL/SQL programming, Course Technology/Cengage Learning, Boston, Massachusetts.
Connolly, T & Begg, C 2010, Database systems: a practical approach to design, implementation, and management, 5th edn, Addison-Wesley, Boston, Massachusetts.
Hoffer, J, Ramesh, V & Topi, H 2010, Modern database management, 10th edn, Pearson/Prentice Hall, Upper Saddle River, New Jersey.
Morrison, J & Morrisson, M 2006, A guide to Oracle 10g, Course Technology/Cengage, Boston, Massachusetts.
Sunderraman, R 2004, Oracle 9i programming: a primer, 2nd edn, Addison-Wesley, Reading, Massachusetts.
Student workload requirements
|Description||Marks out of||Wtg (%)||Due Date||Notes|
|PRACTICAL TESTS||100||20||17 Jul 2012||(see note 1)|
|ONLINE TEST 1||10||1||08 Aug 2012|
|ASSIGNMENT 1||100||9||19 Sep 2012||(see note 2)|
|ONLINE TEST 2||10||1||03 Oct 2012|
|ASSIGNMENT 2||100||19||22 Oct 2012||(see note 3)|
|EXAMINATION - PART A||20||15||End S2||(see note 4)|
|EXAMINATION - PART B||80||35||End S2|
- Date of practical tests to be advised in lectures and tutorials.
- PL/SQL programming and case study - must be submitted electronically via EASE.
- PL/SQL programming - must be submitted electronically via EASE.
- 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
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.
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 Student Policies:
Students should read the USQ policies: Definitions, Assessment and Student Academic Misconduct to avoid actions which might contravene University policies and practices. These policies can be found at http://policy.usq.edu.au.
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.
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.
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/referencing.
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.
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).
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.