Units

---

Sample subject outline - Semester 1 2013

Note: Subject outlines often change before the semester begins. Below is a sample outline.

Rationale

Oracle Corporation is one of the leading suppliers of software for the management of the information. This includes database management, database application development, business intelligence, and the internet-based applications. Hence, it is essential for you to have familiarity with Oracle Software tools for your career in Information Systems and Internet based business applications. This unit provides practical introduction of Oracle Developer suite of software tools and emerging Oracle based technologies.

Aims

This unit aims to enable you to analyse, design, develop and test solutions for a variety of business processing problems using the latest releases of Oracle Database and Developer suite.

It is expected that students undertaking this unit will have prior knowledge of relational database terminology and concepts, be thoroughly able to develop SQL for querying, updating and creating tables, and have a sound knowledge of database design.

Objectives

Learning Outcomes
On successful completion of this you should be able to:

· develop an information system using the Oracle Developer Suite of software tools(GC1)
· apply the principles of program design to develop an information system(GC1)
· apply the principles associated with good screen and report design to develop an information system(GC1)
· develop your problem solving skills by learning how to interpret a set of specifications and implementing your solution as an information system(GC2)
· test your solution using standard testing techniques(GC1)
· use the Oracle Database facilities to create, modify, and query databases(GC1)
· develop an application from a given specification using Oracle Developer Suite of software tools(GC2)
· develop your ability to self-assess your skills in this area(GC5)

Key: Graduate Capabilities
GC1 Knowledge and Skills
GC2 Critical and Creative Thinking
GC3 Communication
CG4 Lifelong Learning
GC5 Independence and Collaboration
GC6 Social and Ethical Responsibility
GC7 Leadership and Change

Content

This unit will teach you about the practical aspects of database creation, manipulation, administration, management, and application development with principles of good report and screen design using the Oracle Developer Suite of software tools.

Approaches to Teaching and Learning

The content of the unit is delivered via a lectures/laboratory program, case studies, the 'On-Line Teaching web site' and the prescribed textbooks. Laboratory work will start from week 2. Case studies will focus on practical aspects of information systems development using Oracle Developer Suite of software tools. You will work on the case studies in the laboratory and do additional problem-solving exercises each week to apply the concept learned in the laboratory. You can do your case study work in groups. Group work will foster the ability to work as part of a development team. You are encouraged to discuss the difficulties you are having with the assignment with your group partner or tutor. To achieve the aims and objectives of the unit, it is essential that you have access to the prescribed textbooks and that you complete the laboratory exercises and problem-solving exercises on a weekly basis. If you understand your case study work you should achieve good results.

Assessment

You will be expected to undertake a number of assessments related to the learning outcomes of this unit (see below).The laboratory sessions on case study work are self-paced, with instructions provided through the textbook, lecture materials, unit Blackboard site and tutors. Additional problem-solving exercises are provided to help you self-assess your progress. Tutors will be available in laboratories to answer questions. Unit-coordinator and duty tutors will also be available in person at specified times or via email to answer questions.

Assessment name: Case Study
Description: You will practice developing an information system in the context of specific cases provided using Oracle Developer Suite of software tools. The case studies will draw together the material covered in lectures and textbooks. The studies will require you to apply the concept in additional case project work. Your ability to develop the system will be tested in a written examination to be held in the last week of the semester.
Relates to objectives: All
Weight: 40%
Internal or external: Internal
Group or individual: Individual
Due date: week 13

Assessment name: Examination (written)
Description: Presented during the semester. All the questions will be drawn from the case studies
Relates to objectives: All
Weight: 60%
Internal or external: Internal
Group or individual: Individual
Due date: exam period

Academic Honesty

QUT is committed to maintaining high academic standards to protect the value of its qualifications. To assist you in assuring the academic integrity of your assessment you are encouraged to make use of the support materials and services available to help you consider and check your assessment items. Important information about the university's approach to academic integrity of assessment is on your unit Blackboard site.

A breach of academic integrity is regarded as Student Misconduct and can lead to the imposition of penalties.

Resource materials

1. Author: Joline Morrison, Mike Morrison, Rocky Conrad
Title: Guide to Oracle 10g(0-619-21629-8)

No extraordinary charges or costs are associated with the requirements for this unit

Risk assessment statement

There is minimal health and safety risk in this unit. It is your responsibility to familiarise yourself with the Health and Safety policies and procedures applicable within FIT campus areas and laboratories.

Disclaimer - Offer of some units is subject to viability, and information in these Unit Outlines is subject to change prior to commencement of semester.

Disclaimer - Offer of some units is subject to viability, and information in these Unit Outlines is subject to change prior to commencement of semester.

Disclaimer - Offer of some units is subject to viability, and information in these Unit Outlines is subject to change prior to commencement of semester.

Last modified: 28-Feb-2013