CSC3400 Database Systems
|Semester 1, 2019 Online|
|Short Description:||Database Systems|
|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: Ji Zhang
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.
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.
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.
On completion of this course the student should be able to:
- demonstrate an in-depth understanding of the relational model;
- correctly construct relational algebra and relational calculus expressions;
- reformulate an English language query statement in the relational algebra, relational calculus, and SQL formalisms;
- create, modify, query, and update a relational database using SQL;
- design an Entity-Relationship diagram on the basis of a description of database requirements;
- translate an ER-diagram into a relational schema;
- normalise relations using functional dependencies.
|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/)
Student workload expectations
|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)|
- Examination dates will be available during the semester. Please refer to the examination timetable when published.
Important assessment information
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 (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.
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.
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).
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).
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.
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);
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.
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.
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.
Assignments should be submitted electronically, through the course website.
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.
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.