Note: This unit is an archived version! See Overview tab for delivered versions.

COMP5138: Database Management Systems (2014 - Semester 2)

Download UoS Outline

Unit: COMP5138: Database Management Systems (6 CP)
Mode: Normal-Evening
On Offer: Yes
Level: Postgraduate
Faculty/School: School of Computer Science
Unit Coordinator/s: Professor Davis, Joseph
Session options: Semester 1, Semester 2
Versions for this Unit:
Site(s) for this Unit: eLearning
Campus: Camperdown/Darlington
Pre-Requisites: None.
Prohibitions: INFO2120 OR INFO2820 OR INFO2005 OR INFO2905. Students who have previously studied an introductory database subject as part of their undergraduate degree should not enrol in this foundational unit, as it covers the same foundational content.
Brief Handbook Description: This unit of study provides a conceptual and practical introduction to the use of common platforms that manage large relational databases. Students will understand the foundations of database management and enhance their theoretical and practical knowledge of the widespread relational database systems, as these are used for both operational (OLTP) and decision-support (OLAP) purposes. The unit covers the main aspects of SQL, the industry-standard database query language. Students will further develop the ability to create robust relational database designs by studying conceptual modelling, relational design and normalization theory. This unit also covers aspects of relational database management systems which are important for database administration. Topics covered include storage structures, indexing and its impact on query plans, transaction management and data warehousing.

Objectives: In this unit students will develop the ability to:

- Understand the foundations of database management;

- Strengthen their theoretical knowledge of database systems in general and relational data model and systems in particular;

- Create robust relational database designs;

- Understand the theory and applications of relational query processing and optimization;

- Study the critical issues in data and database administration;

- Explore the key emerging topics in database management.
Assumed Knowledge: Some exposure to programming and some familiarity with data model concepts
Lecturer/s: Dr Sladescu, Matthew
Tutor/s: Tutors: Ben Drinkwater, Waiho Wong, Iwan Budiman
Timetable: COMP5138 Timetable
Time Commitment:
# Activity Name Hours per Week Sessions per Week Weeks per Semester
1 Lecture 2.00 1 13
2 Tutorial 1.00 1 13
3 Independent Study 3.00 14
4 Project Work - own time 3.00 10
T&L Activities: A variety of learning situations will be employed during the unit of study, including lectures, on-line demos, tutorials, directed computer laboratory exercises, self-learning SQL exercises (`SQL Challenge`), assessed assignments and a small practical database project. To benefit fully from this unit it is necessary to participate fully in all aspects of the unit of study.

Laboratory: Laboratory and Tutorial work includes hands-on use of DBMS, and also practice in problem-solving related to the course content.

Independent Study: Work on assignments, reading material from notes/references, and the SQL Challenge system; this should allow students to engage with the material and to integrate it into their understanding.

Attributes listed here represent the key course goals (see Course Map tab) designated for this unit. The list below describes how these attributes are developed through practice in the unit. See Learning Outcomes and Assessment tabs for details of how these attributes are assessed.

Attribute Development Method Attribute Developed
Experience in conceptual data design and ability to design a schema which says how information about a particular domain will be stored in a relational DBMS (given a conceptual data model); also ability to apply normalization theory to evaluate or improve a relational schema. Ability to capture business rules as integrity constraints in a database schema. Design (Level 3)
Understanding of the concept of a DBMS: differences from other ways to store and share data; DBMS role in organizations; the types of work done with a DBMS.

Ability to work with data stored in a relational database management system (understand table definitions including integrity constraints, extract information through SQL queries, modify information through SQL queries, use views and permissions for security)

Experience of how application software can use data stored in a DBMS (eg a dynamic content web site) and understand the basic architectural alternatives for data management applications.

Understanding of the basic concepts of transaction management.
Engineering/IT Specialisation (Level 3)
The unit teaches the students the basic technology needed for managing data on a very large scale.

Understanding of the SQL mechanisms for basic concepts of data security and privacy.
Professional Conduct (Level 3)

For explanation of attributes and levels see Engineering & IT Graduate Outcomes Table.

Learning outcomes are the key abilities and knowledge that will be assessed in this unit. They are listed according to the course goal supported by each. See Assessment Tab for details how each outcome is assessed.

Design (Level 3)
1. Students should have basic understanding of the design of database solutions to data management problems
Engineering/IT Specialisation (Level 3)
2. Understanding of the transaction concept and its role in transaction processing systems
3. Students should be competent in the use of SQL
4. Indexing of databases and query optimisation
Assessment Methods:
# Name Group Weight Due Week Outcomes
1 Homework exercises No 10.00 Multiple Weeks 1, 2, 3, 4,
2 DB design assignment Yes 10.00 Week 6 1, 3,
3 DB schema assignment Yes 10.00 Week 9 1, 3,
4 DB application development assignment Yes 10.00 Week 13 1, 2, 3, 4,
5 Final Exam No 60.00 Exam Period 1, 2, 3, 4,
Assessment Description: Homework exercises: Each week a set of questions will be posed on that week`s topic, based on the recommended reading. Answers are submitted online and are mostly limited to simple formats such as multiple choice.

DB design assignment: Students work together in small groups to develop the conceptual model of a database based upon a requirements list for a db project. This assignment will build upon the skills developed in labs.

DB schema assignment: Second part of the db project in which students work together in small groups to develop a SQL schema from a given E-R diagram and then create this in Oracle.

DB application development assignment: Third part of the db project in which students gain experience in application development using a database. This includes learning how to expose database records to a client interface, as well as the implementation of more advanced backend features such as stored procedures and indexes.

Final Exam: Final exam
Assessment Feedback: Homework submissions are graded and correct answers are presented the following week on eLearning.

Assignments receive feedback during tutorials, with general points discussed in the following lecture.
Grading:
Grade Type Description
Standards Based Assessment Final grades in this unit are awarded at levels of HD for High Distinction, DI (previously D) for Distinction, CR for Credit, PS (previously P) for Pass and FA (previously F) for Fail as defined by University of Sydney Assessment Policy. Details of the Assessment Policy are available on the Policies website at http://sydney.edu.au/policies . Standards for grades in individual assessment tasks and the summative method for obtaining a final mark in the unit will be set out in a marking guide supplied by the unit coordinator.
Policies & Procedures: IMPORTANT: School policy relating to Academic Dishonesty and Plagiarism.

In assessing a piece of submitted work, the School of IT may reproduce it entirely, may provide a copy to another member of faculty, and/or to an external plagiarism checking service or in-house computer program and may also maintain a copy of the assignment for future checking purposes and/or allow an external service to do so.

Other policies

See the policies page of the faculty website at http://sydney.edu.au/engineering/student-policies/ for information regarding university policies and local provisions and procedures within the Faculty of Engineering and Information Technologies.
Prescribed Text/s: Note: Students are expected to have a personal copy of all books listed.
  • Database Management Systems
Recommended Reference/s: Note: References are provided for guidance purposes only. Students are advised to consult these books in the university library. Purchase is not required.
Online Course Content: see course site on eLearning

Note that the "Weeks" referred to in this Schedule are those of the official university semester calendar https://web.timetable.usyd.edu.au/calendar.jsp

Week Description
Week 1 Introduction
Week 2 Conceptual Database Design
Week 3 Relational Data Model & Logical Database Design
Week 4 Relational Algebra and SQL
Week 5 Complex SQL
Week 6 Complex SQL
Assessment Due: DB design assignment
Week 7 Schema Refinement and Normalisation
Week 8 Database Application Development and Database Security
Week 9 Transaction Management
Assessment Due: DB schema assignment
Week 10 Storage and Indexing
Week 11 Query Evaluation
Week 12 Query Optimisation
Week 13 Revision
Assessment Due: DB application development assignment
Exam Period Assessment Due: Final Exam

Course Relations

The following is a list of courses which have added this Unit to their structure.

Course Year(s) Offered
Master of Health Informatics 2010, 2011
Master of Professional Engineering (Software) 2013, 2014
Graduate Certificate in Information Technology Management (till 2014) 2013, 2014
Graduate Certificate in Information Technology (till 2014) 2012, 2013, 2014
Graduate Diploma in Computing (till 2014) 2012, 2013, 2014
Graduate Diploma in Information Technology Management (till 2014) 2013, 2014
Graduate Diploma in Information Technology (till 2014) 2012, 2013, 2014
Master of Information Technology Management (till 2014) 2011, 2012, 2013, 2014
Master of Information Technology (till 2014) 2014

Course Goals

This unit contributes to the achievement of the following course goals:

Attribute Practiced Assessed
Maths/Science Methods and Tools (Level 3) No 0%
Design (Level 3) Yes 30%
Engineering/IT Specialisation (Level 3) Yes 70%
Professional Conduct (Level 3) Yes 0%

These goals are selected from Engineering & IT Graduate Outcomes Table which defines overall goals for courses where this unit is primarily offered. See Engineering & IT Graduate Outcomes Table for details of the attributes and levels to be developed in the course as a whole. Percentage figures alongside each course goal provide a rough indication of their relative weighting in assessment for this unit. Note that not all goals are necessarily part of assessment. Some may be more about practice activity. See Learning outcomes for details of what is assessed in relation to each goal and Assessment for details of how the outcome is assessed. See Attributes for details of practice provided for each goal.