USQ Logo
The current and official versions of the course specifications are available on the web at https://www.usq.edu.au/course/specification/current.
Please consult the web for updates that may occur during the year.

CIS3010 Oracle Development

Semester 2, 2020 Online
Short Description: Oracle Development
Units : 1
Faculty or Section : Faculty of Health, Engineering and Sciences
School or Department : School of Sciences
Student contribution band : Band 2
ASCED code : 020303 - Database Management
Grading basis : Graded

Staffing

Examiner: Srecko Howard

Requisites

Pre-requisite: CIS2002

Other requisites

Students are required to have access to a personal computer, e-mail capabilities and Internet access to UConnect. Current details of computer requirements can be found at http://www.usq.edu.au/current-students/support/computing/hardware.

Rationale

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.

Synopsis

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.

Objectives

On successful completion of this course, students should be able to:

  1. write client-side and server-side applications of limited scope using Oracle PL/SQL
  2. demonstrate a factual and critical knowledge of a limited number of topics in database theory
  3. 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
  4. write PL/SQL programs, procedures, functions, triggers and packages to solve applied business problems and specifications.

Topics

Description Weighting(%)
1. Selected topics in database theory/trends 20.00
2. DBMS applications programming (Oracle PL/SQL) 80.00

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://omnia.usq.edu.au/textbooks/?year=2020&sem=02&subject1=CIS3010)

Please contact us for alternative purchase options from USQ Bookshop. (https://omnia.usq.edu.au/info/contact/)

Casteel, J 2013, Oracle 11g: PL/SQL programming, 2nd edn, Course Technology/Cengage Learning, Boston, Massachusetts.
(ISBN 9781133947363 Or alternatively eBook version from https://www.cengage.com.)

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.
Connolly, T & Begg, C 2014, Database systems: a practical approach to design, implementation, and management, 6th edn, Addison-Wesley, Boston, Massachusetts.
Hoffer, J, Ramesh, V & Topi, H 2015, Modern database management, 12th edn, Pearson/Prentice Hall, Upper Saddle River, New Jersey.

Student workload expectations

Activity Hours
Directed Study 39.00
Private Study 130.00

Assessment details

Description Marks out of Wtg (%) Due Date Notes
ONLINE TEST 100 5 06 Aug 2020
ASSIGNMENT 1 100 15 18 Sep 2020 (see note 1)
ASSIGNMENT 2 100 30 09 Oct 2020 (see note 2)
Online Exam 20 50 End S2 (see note 3)

Notes
  1. PL/SQL programming and case study - must be submitted electronically.
  2. PL/SQL programming - must be submitted electronically.
  3. This will be an open examination. Students will be provided further instruction regarding the exam by their course examiner via StudyDesk. The examination date will be available via UConnect when the official Alternate Assessment Schedule has been released.

Important assessment information

  1. Attendance requirements:
    External/Online: If you are an international student in Australia, you are advised to attend all classes at your campus. For all other students, there are no attendance requirements for this course. However, it is the students' responsibility 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.

    On-campus: 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.

  2. Requirements for students to complete each assessment item satisfactorily:
    Due to COVID-19 the requirements for S2 2020 are:
    To satisfactorily complete an individual assessment item a student must achieve at least 50% of the marks for that item.

    Requirements after S2 2020:
    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.)

  3. Penalties for late submission of required work:
    Students should refer to the Assessment Procedure http://policy.usq.edu.au/documents.php?id=14749PL (point 4.2.4).

  4. Requirements for student to be awarded a passing grade in the course:
    Due to COVID-19 the requirements for S2 2020 are:
    To be assured of receiving a passing grade a student must achieve at least 50% of the total weighted marks available for the course.

    Requirements after S2 2020:
    To be assured of receiving a passing grade a student must obtain at least 50% of the total weighted marks available for the course (i.e. the Primary Hurdle), and have satisfied the Secondary Hurdle (Supervised), i.e. the end of semester examination by achieving at least 40% of the weighted marks available for that assessment item.

    Supplementary assessment may be offered where a student has undertaken all of the required summative assessment items and has passed the Primary Hurdle but failed to satisfy the Secondary Hurdle (Supervised), or has satisfied the Secondary Hurdle (Supervised) but failed to achieve a passing Final Grade by 5% or less of the total weighted Marks.

    To be awarded a passing grade for a supplementary assessment item (if applicable), a student must achieve at least 50% of the available marks for the supplementary assessment item as per the Assessment Procedure http://policy.usq.edu.au/documents/14749PL (point 4.4.2).

  5. 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.

  6. Examination information:
    Due to COVID-19 the requirements for S2 2020 are:
    An Open Examination is one in which candidates may have access to any printed or written material and a calculator during the examination.

    Requirements after S2 2020:
    This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination.

  7. Examination period when Deferred/Supplementary examinations will be held:
    Due to COVID-19 the requirements for S2 2020 are:
    The details regarding deferred/supplementary examinations will be communicated at a later date.

    Requirements after S2 2020:
    Any Deferred or Supplementary examinations for this course will be held during the next examination period.

  8. 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.

Assessment notes

  1. 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.

Other requirements

  1. 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.

  2. 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.

Date printed 6 November 2020