CIS2002 Database Design and Implementation
|Semester 1, 2019 On-campus Springfield|
|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|
Examiner: Srecko Howard
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.
The database is an integral and essential component of the overwhelming majority of information systems. The efficient daily operations of the organization, its business intelligence and long-term sustainability are all significantly dependent upon well designed and efficient databases.
It is imperative that those who wish to become information systems practitioners have a sound understanding of the design, implementation and management of databases, as well as the optimised retrieval and manipulation of the data in the database. Information systems students and practitioners should therefore build sound data modelling, normalisation and relevant communication skills and should be able to apply these skills to the design of a wide range of databases, in particular commercial databases. Building upon these design skills, students should also develop sound DDL (Data Definition Language) and DML (Data Manipulation Language) skills using the language of the database, SQL (Structured Query Language). It is also highly advantageous for students to gain hands-on experience with enterprise level DBMS software such as Oracle as this provides them with greater insight into the theoretical and methodological aspects of the course and allows them to build industry relevant skills.
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.
On successful completion of this course, students should be able to:
- describe, use and apply data analysis and modelling techniques, including ER diagramming and normalisation, and derive a relational database design
- demonstrate an ability to analyse and justify database designs, with clear verbal and written statements of any assumptions about the data
- demonstrate an understanding of selected core topics in database theory
- construct, understand and evaluate a wide variety of ORACLE SQL DML (Data Manipulation Language) and DDL (Data Definition Language) statements.
Database implementation and management using Oracle
Text and materials required to be purchased or accessed
ALL textbooks and materials available to be purchased can be sourced from USQ's Online Bookshop (unless otherwise stated). (https://omnia.usq.edu.au/textbooks/?year=2019&sem=01&subject1=CIS2002)
Please contact us for alternative purchase options from USQ Bookshop. (https://omnia.usq.edu.au/info/contact/)
(ISBN 9781305251038 Or alternatively eBook version from https://www.cengage.com.)
Student workload expectations
|Lectures or Tutorials or Practicals||36.00|
|Private Study and Assignments||119.00|
|Description||Marks out of||Wtg (%)||Due Date||Notes|
|ONLINE TEST||100||5||18 Mar 2019|
|Assignment 1||100||10||23 Apr 2019||(see note 1)|
|Assignment 2||100||25||27 May 2019||(see note 2)|
|EXAMINATION||100||60||End S1||(see Examination notes below)|
- data modelling and SQL
- data modelling, normalisation and SQL
|Description||Marks out of||Wtg (%)||Notes|
|EXAMINATION PART A||20||10||(see exam note 1)|
|EXAMINATION PART B||80||50|
- The total working time for the examination (parts A and B) is 2 hours. The examination date will be available via UConnect when the official examination timetable has been released.
Important assessment information
Online: 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.
On-campus: It is the students' responsibility to attend and participate appropriately in all activities (such as lectures, tutorials, laboratories and practical work) scheduled for them, and 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.
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 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.)
Penalties for late submission of required work:
Students should refer to the Assessment Procedure http://policy.usq.edu.au/documents.php?id=14749PL (point 4.2.4)
Requirements for student to be awarded a passing grade in the course:
To be assured of receiving a passing grade a student must obtain at least 50% of the total weighted marks available for the course (i.e. the Primary Hurdle), and have satisfied the Secondary Hurdle (Supervised), i.e. the end of semester examination by achieving at least 40% of the weighted marks available for that assessment item.
Supplementary assessment may be offered where a student has undertaken all of the required summative assessment items and has passed the Primary Hurdle but failed to satisfy the Secondary Hurdle (Supervised), or has satisfied the Secondary Hurdle (Supervised) but failed to achieve a passing Final Grade by 5% or less of the total weighted Marks.
To be awarded a passing grade for a supplementary assessment item (if applicable), a student must achieve at least 50% of the available marks for the supplementary assessment item as per the Assessment Procedure http://policy.usq.edu.au/documents/14749PL (point 4.4.2).
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.
This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination.
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.
University Student Policies:
Students should read the USQ policies: Definitions, Assessment and Student Academic Misconduct to avoid actions which might contravene University policies and practices. These policies can be found at http://policy.usq.edu.au.
Referencing in assignments:
Harvard (AGPS) is the referencing system required in this course. Students should use Harvard (AGPS) style in their assignments to format details of the information sources they have cited in their work. The Harvard (AGPS) style to be used is defined by the USQ Library's referencing guide at http://www.usq.edu.au/library/referencing.
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.