CIS2002 Database Design and Implementation
|Short Description:||Database Design & Implementa'n|
|Faculty or Section :||Faculty of Health, Engineering and Sciences|
|School or Department :||School of Agric, Comp and Environ Sciences|
|Student contribution band :||Band 2|
|ASCED code :||020303 - Database Management|
|Grading basis :||Graded|
|Version produced :||26 April 2019|
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.
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.