Note: This unit is an archived version! See Overview tab for delivered versions.
COMP5138: Database Management Systems (2014 - Semester 2)
| 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: |
|
|||||||||||||||||||||||||
| 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: |
|
||||||||||||||||||||||||||||||||||||
| 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: |
|
||||||||||||||||||||||||||||||||||||
| 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.
|
| 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 Professional Engineering (Software) | 2013, 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.
