|Course Title||Database Systems|
|Joint lecturer||Xiaoyang Wang|
|Admin||Helen Paik and Tim Arney|
: a mix of face-to-face (in person) and live online (e.g., using Zoom) presentations. All lectures will be recorded and uploaded to Echo360. See the course menu for details
Timetable for all classes
|Consultations||To be advised|
|Units of Credit||6|
This course explores in depth the practice of developing database applications and the theory behind relational database management systems (RDBMSs). This course focuses on Database Design. 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.
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 industry. In the context ofthe further study, understanding how to use databases effectively is essential for courses such as COMP9321 Data Services Engineering and COMP9322 Software Service Design and Engineering. COMP9311 also 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.
There is no formal prerequisite for the course. But we assume you have background similar to what you would have obtained in a undergraduate engineering/science degree.
By the end of the course, you should be able to:
This course contributes to the development of the following graduate capabilities:
|Graduate Capability||Acquired in|
|Scholars capable of independent and collaborative enquiry, rigorous in their analysis, critique and reflection, and able to innovate by applying their knowledge and skills to the solution of novel as well as routine problems||Lectures and Labs|
|Entrepreneurial leaders capable of initiating and embracing innovation and change, as well as engaging and enabling others to contribute to change||Assignment design and development|
|Professionals capable of ethical, self- directed practice and independent lifelong learning||Online forum discussion, meetings with course staff members|
|Global citizens who are culturally adept and capable of respecting diversity and acting in a socially just and responsible way||
Online forum discussion
This course is taught the way it is because:
The Student Code of Conduct ( Information , Policy ) sets out what the University expects from students as members of the UNSW community. As well as the learning, teaching and research environment, the University aims to provide an environment that enables students to achieve their full potential and to provide an experience consistent with the University's values and guiding principles. A condition of enrolment is that students inform themselves of the University's rules and policies affecting them, and conduct themselves accordingly.
In particular, students have the responsibility to observe standards of equity and respect in dealing with every member of the University community. This applies to all activities on UNSW premises and all external activities related to study and research. This includes behaviour in person as well as behaviour on social media, for example Facebook groups set up for the purpose of discussing UNSW courses or course work. Behaviour that is considered in breach of the Student Code Policy as discriminatory, sexually inappropriate, bullying, harassing, invading another's privacy or causing any person to fear for their personal safety is serious misconduct and can lead to severe penalties, including suspension or exclusion from UNSW.
If you have any concerns, you may raise them with your lecturer, or approach the School Ethics Officer , Grievance Officer , or one of the student representatives.
Plagiarism is defined as using the words or ideas of others and presenting them as your own. UNSW and CSE treat plagiarism as academic misconduct, which means that it carries penalties as severe as being excluded from further study at UNSW. There are several on-line sources to help you understand what plagiarism is and how it is dealt with at UNSW:
Make sure that you read and understand these. Ignorance is not accepted as an excuse for plagiarism. In particular, you are also responsible that your assignment files are not accessible by anyone but you by setting the correct permissions in your CSE directory and code repository, if using. Note also that plagiarism includes paying or asking another person to do a piece of work for you and then submitting it as your own work.
UNSW has an ongoing commitment to fostering a culture of learning informed by academic integrity. All UNSW staff and students have a responsibility to adhere to this principle of academic integrity. Plagiarism undermines academic integrity and is not tolerated at UNSW. Plagiarism at UNSW is defined as using the words or ideas of others and passing them off as your own.
If you haven't done so yet, please take the time to read the full text of
The pages below describe the policies and procedures in more detail:
You should also read the following page which describes your rights and responsibilities in the CSE context:
|Item||Topics||Due||Marks||Contributes to Learning Outcomes|
|Quizzes||All topics||Weeks 1,2,3,4,5,7,8,9,10||5%||1-10|
Data Modelling + SQL DDL
SQL and PLpgSQL programming
|Final Exam||All topics||Exam period||50%||1-10|
Course introduction, Data Modelling
Textbook ref: Chapters 3 & 4
Lab01 – setting up a database server
Relational Data Model and Constraints, Relational Mapping and SQL (Data Definition)
Textbook ref: Chapters 5 & 9
Lab02 – schema definition and data constraints
||Ass1 release||Quiz 2||-|
Relational Algebra and SQL
Textbook ref: Chapters 6, 7 & 8
SQL and PLpgSQL programming (I)
Textbook ref: Chapters 6 & 7, plus PostgreSQL documentation
Lab03 – SQL queries and view definitions
SQL and PLpgSQL programming (II), Database Application Programming
Textbook ref: Chapters 6, 7 & 10, plus PostgreSQL documentation
Lab04 - PLpgSQL functions
Ass 2 release
|6||QUIET WEEK||QUIET WEEK||-||-||-|
Relational Design Theory
Textbook ref: Chapters 14 & 15
Lab05 - database tiggers
Database Architecture and Indexes, Query Processing
Textbook ref: Chapters 2, 16, 18 & 19
Lab06 - a practice on SQLite (an alternative DB)
Textbook ref: Chapters 20, 21 & 22
Lab07 - more practice on SQLite
||Ass2 due||Quiz 9||*|
Future DB technologies, course revision
Textbook ref: Chapters 24 & 25
Special consideration is the process for assessing the impact of short-term events beyond your control (exceptional circumstances), on your performance in a specific assessment task. All special consideration requests you may have on a specific assessment tasks (e.g., for giving an extension) will be managed through the standard UNSW special consideration policy and procedures. For details, please visit UNSW special consideration Web site .
This course is evaluated each session using the myExperience system.
In the previous offering of this courses, students noted that some of the examples in relational design theory were not easy to follow and could have presented better. The switch between PostgreSQL and SQLite was inconvenient. Also, some of the quiz questions were too easy in that a straight look up of the lecture notes was all that was required to find the answer.
Based on their comments, we have better prepared the examples for the relational design theory topic and check their correctness. We will bring SQLite exercise earlier - so that students can more time to practice. The quizzes (main purpose) are there to make sure that weekly revision of the lecture materials happen. So some questions deliberately reference lecture notes. However, from this term, we will make some of the quiz questions less obvious to answer to encourage more higher order thinking on the lecture topics.
We are also removing group work for the assignments as many students experienced difficulties organising group activities online. All assessments are carried out on an individual basis.
Resource created Wednesday 07 September 2022, 07:17:28 PM, last modified Saturday 10 September 2022, 04:44:48 PM.