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

Semester 1, 2012 On-campus Toowoomba
Units : 1
Faculty or Section : Faculty of Business and Law
School or Department : School of Information Systems
Version produced : 30 December 2013

Contents on this page

Staffing

Examiner: Glen Van Der Vyver
Moderator: Srecko Howard

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.

Rationale

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 dependant 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.

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.

Objectives

On successful completion of this course, students should be able to:

  1. describe, use and apply data analysis and modelling techniques, including ER diagramming and normalisation, and derive a relational database design
  2. demonstrate an ability to analyse and justify database designs, with clear verbal and written statements of any assumptions about the data
  3. demonstrate an ability to understand and make use of a variety of forms of business communication in the design process
  4. demonstrate an understanding of selected topics in database theory
  5. use data analysis, modelling and normalization techniques to analyse and solve information systems and business problems
  6. write, understand and critique a wide variety of ORACLE SQL DML (Data Manipulation Language) and DDL (Data Definition Language) statements.

Topics

Description Weighting(%)
1. Database theory
  1. The database environment
  2. Physical database design
10.00
2. Database design
  1. Data modelling
  2. Data analysis
  3. Relational model
  4. E.R. diagramming
  5. Normalisation
55.00
3. Database implementation and management using Oracle
  1. SQL SELECT statements
  2. Table and constraint creation and maintenance
35.00

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://bookshop.usq.edu.au/bookweb/subject.cgi?year=2012&sem=01&subject1=CIS2002)

Please contact us for alternative purchase options from USQ Bookshop. (https://bookshop.usq.edu.au/contact/)

  • Casteel, J 2010, Oracle 11g: SQL, Course Technology/Cengage, Boston, Massachusetts.

Reference materials

Reference materials are materials that, if accessed by students, may improve their knowledge and understanding of the material in the course and enrich their learning experience.
  • Connolly, T & Begg, C 2010, Database systems: a practical approach to design, implementation, and management, 5th edn, Addison-Wesley, Boston, Massachusetts.
  • Finkelstein, C 1992, Information engineering: strategic systems development, Addison-Wesley, Sydney, New South Wales.
  • Hoffer, J, Ramesh, V & Topi, H 2010, Modern database management, 10th edn, Pearson/Prentice Hall, Upper Saddle River, New Jersey.

Student workload requirements

Activity Hours
Lectures or Tutorials or Practicals 36.00
Private Study and Assignments 119.00

Assessment details

Description Marks out of Wtg (%) Due Date Notes
PRACTICAL TESTS 100 20 28 Feb 2012
ONLINE TEST 1 100 1 21 Mar 2012
ASSIGNMENT 1 100 9 04 May 2012 (see note 1)
ONLINE TEST 2 100 1 18 May 2012
ASSIGNMENT 2 100 19 01 Jun 2012 (see note 2)
EXAMINATION PART A 20 10 End S1 (see note 3)
EXAMINATION PART B 80 40 End S1

NOTES
  1. data modelling, SQL and case study
  2. data modelling, normalisation and SQL
  3. The examination is scheduled to be held in the end-of-semester examination period. Students will be advised of the official examination date after the timetable has been finalised. The total working time for Exam (Parts A and B) is 2 hours.

Important assessment information

  1. Attendance requirements:
    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.

  2. 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.)

  3. Penalties for late submission of required work:
    No assignments will be accepted after assignment feedback has been posted. Feedback will be posted on the discussion group approximately ten days after the due date of the assignment. Items submitted late are likely to be subject to processing delays.

  4. Requirements for student to be awarded a passing grade in the course:
    To be assured of receiving a passing grade a student must achieve at least 50% of the total weighted marks available for the course.

  5. 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.

  6. Examination information:
    This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination.

  7. 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.

  8. 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.

Assessment notes

  1. Assignments: (i) The due date for an assignment is the date by which a student must submit the assignment to the USQ. (ii) Students must retain a copy of each item submitted for assessment. This must be produced within 24 hours if required by the examiner. (iii) In accordance with university policy, the examiner may grant an extension of the due date of an assignment in extenuating circumstances. (iv) The examiner will normally only accept assessments that have been written, typed or printed on paper-based media. (v) In the event that a due date for an assignment falls on a local public holiday in their area, such as a show holiday, the due date for the assignment will be the next day. Students are to note on the assignment cover the date of the public holiday for the examiner's convenience.

  2. Course weightings: Course weightings of topics should not be interpreted as applying to the number of marks allocated to questions testing those topics in an examination paper.

  3. 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.

  4. Make-up work: Students who have undertaken all of the required assessments in a course but who have failed to meet some of the specified objectives of a course within the normally prescribed time may be awarded the temporary grade: IM (Incomplete - Make up). An IM grade will only be awarded when, in the opinion of the examiner, a student will be able to achieve the remaining objectives of the course after a period of non-directed personal study.

  5. Deferred work: Students who, for medical, family/personal, or employment-related reasons, are unable to complete an assignment or to sit for an examination at the scheduled time may apply to defer an assessment in a course. Such a request must be accompanied by appropriate supporting documentation. One of the following temporary grades may be awarded: IDS (Incomplete - Deferred Examination); IDM (Incomplete Deferred Make-up); IDB (Incomplete - Both Deferred Examination and Deferred Make-up).

  6. Appeals: Any appeal against the award of a grade in the course will be conducted in accordance with university regulations. These regulations are published in the university handbook.

Other requirements

  1. Computer, e-mail and Internet access: 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.

  2. 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, and this is particularly true of lectures and tutorials. Tutorial exercises will be assigned during tutorials and will be due seven days later. It is the responsibility of students to ascertain whether a tutorial exercise was assigned during a tutorial. These exercises will not be posted on the discussion group. The practical tests are treated in the same way as an examination. Students who do not attend will receive a mark of zero unless they provide an appropriate reason with supporting documentation.