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

CIS2002 Database Design and Implementation

Units : 1
Faculty or Section : Faculty of Business and Law
School or Department : School of Information Systems
Version produced : 21 July 2014

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.

Synopsis

This course focuses on the design and implementation of relational databases and includes extensive exposure to Oracle SQL. Practical methodologies for data analysis, data modelling and database design are examined, coupled with study of the relational database model. The course builds applied skills in data modelling, normalisation, database design and the creation and management of database objects using Oracle SQL. 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 CIS3010 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.

Course offers

Semester Mode Campus
Semester 1, 2013 External
Semester 1, 2013 On-campus Toowoomba
Semester 3, 2013 External