UniMate AI

INFS7901

数据库原理

2 学分难度 超难👥 13 人学过

Database technology is a fundamental part of information technology and plays an important role in data analytics. Database technology is used to store and manage data with reliable services such as data integrity, shareability, recoverability, and security. In this course, we will study data modelling, representation, query and maintenance of data integrity. Hands-on experiences will be provided for students to create a basic database application system. In order to provide effective and efficient data management, we will study algorithms for effective access to structured data with different data processing requirements.

Syllabus

每周大纲

  1. 1

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 1; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  2. 2

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 2; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  3. 3

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 3; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  4. 4

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 4; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  5. 5

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 5; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  6. 6

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 6; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  7. 7

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 7; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  8. 8

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 8; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  9. 9

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 9; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  10. 10

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 10; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  11. 11

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 11; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

  12. 12

    Lectures / Applied Class

    No separate week-by-week topic is publicly listed for Week 12; official repeated teaching activities are shown below: - Lecture: Lectures - The course lectures will provide in-depth knowledge of various concepts and techniques in the design of Database Management Systems (DBMS). Lecture notes will be available for all the material covered in this course. A series of in-class questions related to the course content will be raised to provide opportunities for better student engagement with content and in-depth discussions. Learning outcomes: L01, L02, L03, L04, L05 - Applied Class: Applied Class - Hands-on applied classes will provide an opportunity to further practice the concepts introduced in the lectures via examples, exercises and problem-solving. They will also allow students to become familiar with various methods in the implementation and optimization of database systems. Learning outcomes: L01, L02, L03, L04, L05 Official timetable activities: - Lecture | Thu 10:00 | 120 mins | 63-358 Physiology Building, Learning Theatre - Tutorial | Thu 13:00 | 60 mins | 46-441 Andrew N. Liveris Building, Computer Lab Source: 2026 S1 UQ Course Profile - https://course-profiles.uq.edu.au/course-profiles/INFS7901-21184-7620

Assessment

考核结构

Database Project Part 1 - Design Proposal

Official due date: 1/04/2026 3:00 pm. Source: 2026 S1 UQ Course Profile.

15%

Database Project Part 2 - SQL Implementation

Official due date: 15/05/2026 3:00 pm. Source: 2026 S1 UQ Course Profile.

15%

Online Quizzes Online

Official due date: Quiz Set 1 (ER Diagram and Relational Model) 13/03/2026 3:00 pm Quiz Set 2 (Functional Dependencies and Normalisation) 27/03/2026 3:00 pm Quiz Set 3 (SQL Programming) 17/04/2026 3:00 pm Quiz Set 4 (Asymptotic Analysis, Sorting, and Binary Search Trees) 8/05/2026 3:00 pm Quiz Set 5 (Hashing, Indexing, Relational Algebra and Query Optimisation) 29/05/2026 3:00 pm. Source: 2026 S1 UQ Course Profile.

20%

Final Exam Hurdle Identity Verified In-personHurdle

Official due date: End of Semester Exam Period 6/06/2026 - 20/06/2026. Source: 2026 S1 UQ Course Profile.

50%

From Seniors

学长留下的

基础信息谁都查得到,真正值钱的是过来人的经验。

学姐说

比你早一年的学长留下的真实经验 —— ChatGPT 给不了。

这门课还没有学长经验,你可以是第一个 —— 注册后在课内分享。

往年考点 / 踩坑

这门课暂无往年考点记录。

毕业生去向(整体)

下面是匠人学院毕业生整体去过的公司分布(来自脱敏校友证言)。这是全平台的总体去向,不代表选这门课的人一定去这些公司。

统计自 313 份脱敏校友证言

Deloitte

6 位校友

岗位:Graduate Program · Graduate Consulting · Platform Engineer · Web developer · Platform engineer

Zerologix

4 位校友

岗位:Frontend Dev · junior frontend developer · Front-end Developer · Full Stack Developer

Servian

4 位校友

岗位:Full-stack Developer · Data Engineer · Consultant

关于这块数据,我们说实话

雇主墙来自脱敏毕业生证言(testimonials)的整体分布,无法关联到具体学员或其所选课程;仅作为毕业生去向的总体社会证明展示。

我们没有"某位学长选了这门课、后来进了哪家公司"这种可查询的个人去向档案 —— 校友证言是脱敏的,无法关联到具体的人或他选过的课。所以这里只给整体分布,不给个人路径,不编。