Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
COMP9311 Database Systems
Course Details & Outcomes
Course Description
Large data resources are critical to the functioning of just about every significant modern computer application, and so knowledge of how to manage them is clearly important in the industry. One very important platform for this is relational database management systems (RDBMSs).
This course explores in-depth the practice of developing database applications and the theory behind RDBMSs. The course focuses on database design and querying, as well as analysis of database schemas. It will also give an overview of the technologies used in implementing database management systems and the past, present, and future of database systems and database research.
Course Aims
This course aims to give students a solid grounding in the use of relational database management systems.
In the context of further study, understanding how to use databases effectively provides a foundation for further study in advanced database topics, such as COMP9315 Database Systems Implementation and COMP9318 Data Mining. Database concepts are also relevant in courses such as COMP9319 Web Data Compression and Search and COMP6714 Information Retrieval and Web Search.
Course Learning Outcomes
| Course Learning Outcomes |
|---|
| CLO1 : Develop accurate, non-redundant data models |
| CLO2 : Realise data models as relational database schemas |
| CLO3 : Formulate efficient and effective queries via the full range of SQL constructs |
| CLO4 : Use stored procedures and triggers to extend DBMS capabilities |
| CLO5 : Understand the overall architecture of relational DBMSs |
| CLO6 : Understand the concepts behind transactions and concurrency control |
| CLO7 : Appreciate the past, present, and future of database technology |
| Course Learning Outcomes | Assessment Item |
|---|---|
| CLO1 : Develop accurate, non-redundant data models |
|
| CLO2 : Realise data models as relational database schemas |
|
| CLO3 : Formulate efficient and effective queries via the full range of SQL constructs |
|
| CLO4 : Use stored procedures and triggers to extend DBMS capabilities |
|
| CLO5 : Understand the overall architecture of relational DBMSs |
|
| CLO6 : Understand the concepts behind transactions and concurrency control |
|
| CLO7 : Appreciate the past, present, and future of database technology |
|
Learning and Teaching Technologies
Moodle - Learning Management System | Blackboard Collaborate | Echo 360 | EdStem | WebCMS
Other Professional Outcomes
https://www.unsw.edu.au/engineering/student-life/student-resources/program-design
Assessments
Assessment Structure
| Assessment Item | Weight | Relevant Dates |
|---|---|---|
|
Assignment 1
Assessment FormatIndividual
|
12% |
Due DateWeek 3: 10 June - 16 June
|
|
Project 1
Assessment FormatIndividual
|
25% |
Due DateWeek 6: 01 July - 07 July
|
|
Assignment 2
Assessment FormatIndividual
|
13% |
Due DateWeek 9: 22 July - 28 July
|
|
Final Exam
Assessment FormatIndividual
|
50% |
Due DateTBA during Exam Week
|
Assessment Details
-
Assignment 1
Assessment Overview
This assignment involves database design and writing relational algebra expressions to extract data.
Marking will be against specific criteria in a marking guide and formal feedback on your assessment task will be provided within 21 days of the relevant submission date through the Learning Management System
Course Learning Outcomes
- CLO1 : Develop accurate, non-redundant data models
- CLO2 : Realise data models as relational database schemas
Detailed Assessment Description
Details are on the WebCMS course website.
-
Project 1
Assessment Overview
This project requires students to devise SQL queries and functions on a non-trivial database.
Marking will be against specific criteria in a marking guide and formal feedback on your assessment task will be provided within 21 days of the relevant submission date through the Learning Management System
Course Learning Outcomes
- CLO3 : Formulate efficient and effective queries via the full range of SQL constructs
- CLO4 : Use stored procedures and triggers to extend DBMS capabilities
Detailed Assessment Description
Details are on the WebCMS course website.
-
Assignment 2
Assessment Overview
This assignment involves exercises in schema analysis, query processing and analysis of concurrency scenarios.
Marking will be against specific criteria in a marking guide and formal feedback on your assessment task will be provided within 21 days of the relevant submission date through the Learning Management System
Course Learning Outcomes
- CLO1 : Develop accurate, non-redundant data models
- CLO2 : Realise data models as relational database schemas
- CLO5 : Understand the overall architecture of relational DBMSs
- CLO6 : Understand the concepts behind transactions and concurrency control
Detailed Assessment Description
Details are on the WebCMS course website.
-
Final Exam
Assessment Overview
The exam is 2-hours long and will be held in the UNSW exam period. It involves short-answer, data modelling, schema analysis and relational algebra.
Marking will be against specific criteria in a marking guide and no formal feedback will be provided
Course Learning Outcomes
- CLO1 : Develop accurate, non-redundant data models
- CLO2 : Realise data models as relational database schemas
- CLO3 : Formulate efficient and effective queries via the full range of SQL constructs
- CLO4 : Use stored procedures and triggers to extend DBMS capabilities
- CLO5 : Understand the overall architecture of relational DBMSs
- CLO6 : Understand the concepts behind transactions and concurrency control
- CLO7 : Appreciate the past, present, and future of database technology
General Assessment Information
Below is the maximum mark you can get for each assessment and how the final mark is calculated.
- Assignment 1 - Data Modeling + Relational Algebra (full mark 24)
- Assignment 2 - DB design Theory + Transaction (full mark 26)
- Project 1 - SQL (Full mark 50)
- Final Exam (Full mark 100)
Late Submission Penalties for Assignments and Project 1:
- 5% reduction of the full mark for each day, up to 5 days
The final mark is calculated using the geometric mean:
- Final Mark = sqrt ( (ass1 + ass2 + proj1) * Final Exam)
Marking will be against specific criteria in a marking guide and formal feedback on your assessment task will be provided
Grading Basis
Standard
Course Schedule
| Teaching Week/Module | Activity Type | Content |
|---|---|---|
| Week 1 : 27 May - 2 June | Lecture |
Course Introduction & Conceptual DB Design (ER) |
| Assessment |
Assignment 1 Release: Data Modelling and Relational Algebra |
|
| Week 2 : 3 June - 9 June | Lecture |
Relational Data Model & Relational Algebra |
| Laboratory |
Lab01 - Setting up a database server |
|
| Week 3 : 10 June - 16 June | Lecture |
SQL |
| Laboratory |
Lab02 – Schema definition and data constraints |
|
| Assessment |
Assignment 1 Due |
|
| Week 4 : 17 June - 23 June | Lecture |
SQL and PLpgSQL programming |
| Laboratory |
Lab03 – SQL practice |
|
| Assessment |
Project 1 Release: SQL |
|
| Week 5 : 24 June - 30 June | Lecture |
Functional Dependencies, Normal Forms |
| Laboratory |
Lab04 – SQL queries with view definitions |
|
| Week 6 : 1 July - 7 July | Assessment |
Project 1 Due |
| Week 7 : 8 July - 14 July | Lecture |
Relational DB Design & Disks, Files, Index |
| Laboratory |
Lab05 - SQL functions and PLpgSQL functions |
|
| Assessment |
Assignment 2 Release: DB Design Theory, Database Storage Structures and Transaction |
|
| Week 8 : 15 July - 21 July | Lecture |
Transaction Management |
| Laboratory |
Lab06 - Database triggers |
|
| Week 9 : 22 July - 28 July | Lecture |
Advanced Topics: Graph Database |
| Laboratory |
Lab07 - Relational design theory |
|
| Assessment |
Assignment 2 Due |
|
| Week 10 : 29 July - 4 August | Lecture |
Advanced Topics (Guest Lecture) & Revision |
| Laboratory |
Lab08 - A practice on SQLite (an alternative DB) |
Attendance Requirements
Students are strongly encouraged to attend all classes and review lecture recordings.
General Schedule Information
The table summarises the planned weekly activities for the course. These are tentative. Please refer to the relevant sections of the course homepage for the most up-to-date information about the weekly schedule throughout the course delivery period.
Course Resources
Recommended Resources
Textbook:
- Fundamentals of Database Systems by Elmasri & Navathe, 7th edition, Addison-Wesley, UNSW Bookshop , eBook (Pearson)
Other References:
- A First Course in Database Systems by Jeffery D. Ullman, Jennifer Widom, a recent edition, Prentice Hall
- Database Management Systems by R. Ramakrishan, 3rd edition, McGraw-Hill, 2003
- The Theory of Relational Databases by D. Maier, 1st edition, Computer Science Press, 1983
Course Evaluation and Development
Students can give their feedback by sending emials to the course contact, and this course is evaluated using the myExperience system.
In the previous iteration of this course, some students expressed difficulty in following the theoretical aspects. Taking their feedback into account, we will refine the explanation of database theory and enrich the lecture notes with additional examples to enhance comprehension.