Skip to main content
USQ Logo
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.

CSC3400 Database Systems

Semester 1, 2019 On-campus Toowoomba
Short Description: Database Systems
Units : 1
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

Staffing

Examiner: Ji Zhang

Other requisites

Recommended Pre-requisite: MAT1101 and CSC2401 and CSC2407 and CSC2408.
Students who have enrolled in or completed CSC8500 Advanced Relational Database Design and Technology cannot enrol in this course.

Rationale

A key component of information systems is its database management system. These are widely used in scientific, business, government, and industrial organisations. It is important for a computing professional to understand the basic concepts of database systems, to be proficient in a database query languages, and to know the design principles of database systems. It is also important to be able to integrate a database in the context of data-driven web application.

Synopsis

This course covers the fundamental issues of the relational model, relational languages, database design and query processing. It starts with a structured overview of database systems, their history and application. The relational model is then covered in detail. Relational languages such as the relational algebra and calculus are discussed before introducing the SQL language. Then we cover the Entity-Relationship model and discuss how ER diagrams are translated to the relational model. Topics on database design principles in this course further include functional dependencies and normalization. Students will gain a good understanding of database design theory and principles and be able to develop database systems and application programs on a DBMS.

Objectives

On completion of this course the student should be able to:

  1. demonstrate an in-depth understanding of the relational model;
  2. correctly construct relational algebra and relational calculus expressions;
  3. reformulate an English language query statement in the relational algebra, relational calculus, and SQL formalisms;
  4. create, modify, query, and update a relational database using SQL;
  5. design an Entity-Relationship diagram on the basis of a description of database requirements;
  6. translate an ER-diagram into a relational schema;
  7. normalise relations using functional dependencies.

Topics

Description Weighting(%)
1. The relational model 10.00
2. The relational algebra and calculus 25.00
3. The SQL language 20.00
4. The Entity-Relationship model 20.00
5. Relational database design 25.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://omnia.usq.edu.au/textbooks/?year=2019&sem=01&subject1=CSC3400)

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

Connolly, T & Begg, C 2014, Database systems, a practical approach to design, implementation and management, 6th edn, Pearson Education Limited, Harlow.
A relational database management system (DBMS) such as: MySQL, latest version, http://www.mysql.com free download ; PostgreSQL, latest version, http://postgreSQL free download. Students may choose any of these two or any other to practise their knowledge of SQL. Manuals for these systems are included in the downloads.

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.
Date, CJ 2004, An introduction to database systems, 8th edn, Pearson/Addison-Wesley, Boston.
(Vol 1.)
Elmasri, R & Navathe, SB 2015, Fundamentals of database systems, 7th edn, Pearson/Addison-Wesley, New York.
Ramakrishnan, R & Gehrke, J 2003, Database management systems, 3rd edn, McGraw-Hill, Boston.
Silberschatz, A, Korth, HF & Sudarshan, S 2011, Database system concepts, 6th edn, McGraw-Hill, Boston.

Student workload expectations

Activity Hours
Assessments 39.00
Laboratory or Practical Classes 10.00
Lectures 39.00
Private Study 77.00

Assessment details

Description Marks out of Wtg (%) Due Date Notes
ASSIGNMENT 1 20 5 20 Mar 2019
ASSIGNMENT 2 20 15 24 Apr 2019
ASSIGNMENT 3 20 15 23 May 2019
2HR RESTRICTED EXAMINATION 100 65 End S1 (see note 1)

Notes
  1. Examination dates will be available during the semester. Please refer to the examination timetable when published.

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 (including course Web pages) 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 assessment item a student must achieve at least 50% of the marks or a grade of at least C-. Students do not have to satisfactorily complete each assessment item to be awarded a passing grade in this course. Refer to Statement 4 below for the requirements to receive a passing grade in this course.

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

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

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

  5. Method used to combine assessment results to attain final grade:
    The final grades for students will be assigned on the basis of the weighted aggregate of the marks obtained for each of the summative assessment items in the course.

  6. Examination information:
    Candidates are only allowed to access specific materials during a Restricted Examination. The only materials that candidates may use in the restricted examination for this course are:
    i. writing materials (non-electronic and free from material which could give the student an unfair advantage in the examination);
    ii. calculators which cannot hold textual information (students must indicate on their examination paper the make and model of any calculator(s) they use during 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. The due date for an assignment is the date by which a student must despatch the assignment to the USQ. The onus is on the student to provide proof of the despatch date, if requested by the Examiner.

  2. Students may be required to provide a copy of assignments submitted for assessment purposes. Such copies should be despatched to the USQ within 24 hours of receipt of a request to do so.

  3. Assignments should be submitted electronically, through the course website.

  4. The referencing system to be used in this course is supported by the Department. Information on this referencing system and advice on how to use it can be found in the course materials.

Other requirements

  1. Students will require access to e-mail and internet access to UConnect and the Course Web site, and are expected to check these resources frequently.