CSC3400 Database Systems
|Semester 1, 2012 External Toowoomba|
|Faculty or Section :||Faculty of Sciences|
|School or Department :||Maths and Computing|
|Version produced :||30 December 2013|
Examiner: Ji Zhang
Moderator: Stijn Dekeyser
Recommended Pre-requisite: MAT1101 and CSC2401 and CSC2407 and CSC2408
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://bookshop.usq.edu.au/bookweb/subject.cgi?year=2012&sem=01&subject1=CSC3400)
Please contact us for alternative purchase options from USQ Bookshop. (https://bookshop.usq.edu.au/contact/)
Connolly, T & Begg, C 2010, Database systems, a practical approach to design, implementation and management, 5th edn, Addison-Wesley, Harlow.
(ISBN 0-201-70857-4, http://www.booksites.net/connbegg/.)
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.
Date, CJ 2004, An introduction to database systems, 8th edn, Pearson/Addison-Wesley, Boston.
Elmasri, R & Navathe, SB 2004, Fundamentals of database systems, 4th 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 2005, Database system concepts, 5th edn, McGraw-Hill, Boston.
Student workload requirements
|Description||Marks out of||Wtg (%)||Due Date||Notes|
|ASSIGNMENT 1||20||5||21 Mar 2012|
|ASSIGNMENT 2||20||15||24 Apr 2012|
|ASSIGNMENT 3||20||15||24 May 2012|
|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:
If students submit assignments after the due date without (prior) approval of the examiner then a penalty of 5% of the total marks gained by the student for the assignment may apply for each working day late up to ten working days at which time a mark of zero may be recorded. No assignments will be accepted after model answers have been posted.
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.
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.
Candidates are allowed access only to specific materials during a Restricted Examination. The only materials that candidates may use in the restricted examination for this course are: writing materials (non-electronic and free from material which could give the student an unfair advantage in the examination); 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.