Related Course/s:

A unit of study in the Bachelor of Business Information Systems, Bachelor of Information Technology and Bachelor of Science (Professional Software Development)

Aims & Objectives:

• Apply techniques and facilities such as stored procedures, database triggers and cursors.
• Explain and describe the implications of accessing a database via the web. 
• Demonstrate an ability to work in a project team environment on a project focussed on one of a variety of topics or problems in information systems.
• Demonstrate an ability to synthesise prior learning and offer solutions using a range of tools, techniques, methods and other
  appropriate resources. 
• Better appreciate the relationship between and understanding of theoretical constructs and their practical application to a real life problem.
• Apply a range of problem solving skills in an information systems context.
• Show willingness to present ideas for scrutiny to group members and working professionals, and demonstrate a willingness and ability to accept criticism from others. 
• Show evidence of self-reliance and time management skills, and an ability to organise a project in order to gain greater independence as a learner and project team member. 
• Demonstrate increased awareness and understanding of ethical and professional behaviours in an organisational context.

Teaching Methods:

Lecture (24 hrs), Tutorial (labs) (12 hrs)

Assessment:

Content:

• Data integrity
• Integrity independence
• Business rules 
• PL/SQL 
• Database Triggers
• Stored procedures
• Programming with cursors
• Web based database systems
• Communication skills in dealing with clients and colleagues
• Design
• Project planning and management
• Quality assurance via process
• Test planning, execution and record-keeping
• Working to standards
• Technical documentation
• Document version control