CIS 2004 Database Applications Development with Oracle

STAFFING:

REQUISITES:

RATIONALE:

Large-scale databases have become core tools in modern Information Technology. The overwhelming majority of IT professionals are exposed to databases in the workplace and they are often expected to develop expertise in one or more database product. It is therefore imperative that students are introduced to the fundamentals of a major DBMS product and the development of client side and server side applications, queries and utilities within the DBMS environment. Beyond this, students should also develop the capacity to think critically about database theory and the application thereof. 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 gain an understanding of the practical application of the techniques and theory covered in CIS2002 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.

OBJECTIVES:

The course objectives define the student learning outcomes for a course. The assessment item(s) that may be used to assess student achievement of an objective are shown in parentheses after each objective. On successful completion of this course, students should be able to:

1. apply the modelling and normalisation skills acquired in CIS2002 to the creation of database objects (Assignments, Practical Test, Examination)
2. write statements and programs in the Oracle (SQL) environment (Assignments, Practical Test)
3. build upon the skills in the relational algebra acquired in CIS2002 to write SQL and SQL*PLUS statements at a variety of levels of complexity (Assignments, Practical Test, Examination)
4. write client-side and server-side code using Oracle PL/SQL (Assignments, Practical Test, Examination)
5. demonstrate a factual and critical knowledge of a limited number of topics in database theory (Examination)
6. explain the architecture of Oracle and evaluate the extent to which it meets the requirements of selected theoretical architecture/s (Examination)
7. write PL/SQL programs, stored procedures and triggers to solve problems (Assignments, Practical Test, Examination).

TOPICS:

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

REFERENCE MATERIALS:

STUDENT WORKLOAD REQUIREMENTS:

ASSESSMENT DETAILS:

NOTES:

1.

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 3 hours.

IMPORTANT ASSESSMENT INFORMATION

1. Attendance requirements:
   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.
2. 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 available 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:
   If a student submits assignments or tutorial exercises after the due date without prior approval then a penalty of 10% of the total marks available for the assignment will apply for each working day late. The same penalty applies to students who submit later than the final day of an extension. No assignments will be accepted after model answers have been posted. Items submitted late are likely to be subject to processing delays.
4. 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 40% in all of the weighted assessment items, achieve at least 50% in the examination and at least 50% of the total weighted marks available for the course.
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:
   This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination. The examination consists of two parts. Part A is worth 20 marks and Part B is worth 80 marks.
7. 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.
8. University Regulations:
   Students should read USQ Regulations 5.1 Definitions, 5.6. Assessment, and 5.10 Academic Misconduct for further information and to avoid actions which might contravene University Regulations. These regulations can be found at the URL http://www.usq.edu.au/corporateservices/calendar/part5.htm. Students should also read the Faculty of Business Guide to Policies and Procedures of the Faculty which can be found at the URL http://www.usq.edu.au/handbook/current/buspolproc.html.

ASSESSMENT NOTES

OTHER REQUIREMENTS:

1. Learning resources: Prescribed texts and materials (see above); recommended reference materials (see above); printed Introductory Book, Study Book/s, and Book/s of Selected Readings; and course Website accessible via USQConnect.
2. E-mail and Internet Access: Students require access to e-mail and Internet access to USQConnect 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.
3. 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.