COMP9311 Database Systems - 2024
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
COMP9311 Database Systems - 2024
General Course Information
Course Code : COMP9311
Year : 2024
Term : Term 1
Teaching Period : T1
Course Details & Outcomes
Course Description
Large data resources are critical to the functioning of just about every signifcant 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 efcient 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 |
• Assignment 1 • Assignment 2 • Final Exam |
|
CLO2 : Realise data models as relational database schemas |
• Assignment 1 • Assignment 2 • Final Exam |
|
CLO3 : Formulate efcient and effective queries via the full range of SQL constructs |
• Project 1 • Final Exam |
|
CLO4 : Use stored procedures and triggers to extend DBMS capabilities |
• Project 1 • Final Exam |
|
CLO5 : Understand the overall architecture of relational DBMSs |
• Assignment 2 • Final Exam |
|
CLO6 : Understand the concepts behind transactions and concurrency control |
• Assignment 2 • Final Exam |
|
CLO7 : Appreciate the past, present, and future of database technology |
• Final Exam |
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 Format: Individual |
12% |
Due Date: Week 4: 04 March - 10 March |
|
Project 1 Assessment Format: Individual |
25% |
Due Date: Week 7: 25 March - 31 March |
|
Assignment 2 Assessment Format: Individual |
13% |
Due Date: Week 10: 15 April - 21 April |
|
Final Exam Assessment Format: Individual |
50% |
Due Date: TBA 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 specifc 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 specifc 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 efcient 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 specifc 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 beheld in the UNSW exam period. It involves short-answer, data modelling, schema analysis and relational algebra.
Marking will be against specifc 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 efcient 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 fnal 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 fnal mark is calculated using the geometric mean:
· Final Mark = sqrt ( (ass1 + ass2 + proj1) * Final Exam)
Marking will be against specifc 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 : 12 February - 18 February |
Lecture |
Course Introduction & Conceptual DB Design (ER) |
|
Week 2 : 19 February - 25 February |
Lecture |
Relational Data Model & Relational Algebra |
|
Laboratory |
Lab01 - Setting up a database server |
|
|
Assessment |
Assignment 1: Data Modelling and Relational Algebra |
|
|
Week 3 : 26 February - 3 March |
Lecture |
SQL |
|
Laboratory |
Lab02 – Schema defnition and data constraints |
|
|
Week 4 : 4 March - 10 March |
Lecture |
SQL and PLpgSQL programming |
|
Laboratory |
Lab03 – SQL practice |
|
|
Assessment |
Assignment 1 due |
|
|
Week 5 : 11 March - 17 March |
Lecture |
Functional Dependencies, Normal Forms |
|
Laboratory |
Lab04 – SQL queries with view defnitions |
|
|
Assessment |
Project 1: SQL |
|
|
Week 7 : 25 March - 31 March |
Lecture |
Relational DB Design & Disks, Files, Index |
|
Laboratory |
Lab05 - SQL functions and PLpgSQL functions |
|
|
Assessment |
Project 1 Due |
|
|
Week 8 : 1 April - 7 April |
Lecture |
Transaction Management |
|
Laboratory |
Lab06 - Database triggers |
|
|
Assessment |
Assignment 2: DB Design Theory, Database Storage Structures and Transaction |
|
|
Week 9 : 8 April - 14 April |
Lecture |
Advanced Topics: Graph Database |
|
Laboratory |
Lab07 - Relational design theory |
|
|
Week 10 : 15 April - 21 April |
Lecture |
Advanced Topics (Guest Lecture) & Revision |
|
Laboratory |
Lab08 - A practice on SQLite (an alternative DB) |
|
|
Assessment |
Assignment 2 Due |
2024-03-07