Unit search

Search results

SIT772 - Database and Information Retrieval

Year:

2022 unit information

Important Update:

Unit delivery will be in line with the most current COVIDSafe health guidelines. We continue to tailor learning experiences for each unit to achieve the best possible mix of online and on-campus activities that successfully blend our approaches to learning, working and research. Please check your unit sites for announcements and updates.

Last updated: 4 March 2022

Enrolment modes:Trimester 1: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Trimester 2: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Trimester 3: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Credit point(s):1
EFTSL value:0.125
Unit Chair:Trimester 1: Jianxin Li
Trimester 2: Sunil Aryal
Trimester 3: Bahadorreza Ofoghi
Prerequisite:

Nil

Corequisite:

Nil

Incompatible with:

Nil

Typical study commitment:

Students will on average spend 150 hours over the teaching period undertaking the teaching, learning and assessment activities for this unit.

Scheduled learning activities - campus:

1 x 2 hour online class per week, 1 x 2 hour workshop per week, weekly drop-in sessions.

Scheduled learning activities - cloud:

Online independent and collaborative learning including optional scheduled activities as detailed in the unit site.

Note:

Students enrolled in S778, S779, S735, S536, S536J, S635, and S737 are not eligible to enrol in the following units:

SIT771 Object-Orientated Development
SIT772 Database and Information Retrieval
SIT773 Software Requirements Analysis and Modelling
SIT774 Web Technologies and Development

Content

The unit will cover two important foundational but related methods for capturing, representing, storing, organising, and retrieving structured, unstructured or loosely structured information. Firstly, the unit will focus on the fundamentals of data modelling and database technology. The relational data model will be investigated and the process of constructing database tables and related entities will be explored in depth. The second focus of the unit is information retrieval: the process of indexing and retrieving text documents. As a critical aspect of Web search engines, the field of Information Retrieval includes almost any type of unstructured or semi-structured data. Students will explore how search engines work, why they are successful, and to some degree how they fail.

Trimester 1:

ULO

These are the Learning Outcomes (ULO) for this unit. At the completion of this unit, successful students can:

Deakin Graduate Learning Outcomes

ULO1

Explain the difference between data and information and the difference between a traditional multiple- file system and a database.

GLO1: Discipline-specific knowledge and capabilities

ULO2

Apply the concept of data modelling and use Entity-Relationship (ER) models to represent/data.

GLO1: Discipline-specific knowledge and capabilities

ULO3

Design and implement relational database systems through the use of SQL.

GLO1: Discipline-specific knowledge and capabilities
GLO4: Critical thinking

ULO4

Compare the difference between information retrieval technologies and justify the use of a particular one over another for a given scenario.

GLO1: Discipline-specific knowledge and capabilities

ULO5

Demonstrate information retrieval skills in the context of a data processing system.

GLO1: Discipline-specific knowledge and capabilities

Trimester 2 and 3:

ULO

These are the Learning Outcomes (ULO) for this unit. At the completion of this unit, successful students can:

Deakin Graduate Learning Outcomes

ULO1

Interpret and explain fundamental concepts of data, information, and knowledge and demonstrate an understanding of differences between traditional file systems and databases.

GLO1: Discipline-specific knowledge and capabilities

ULO2

Analyse real-world problems to identify data requirements and apply data modelling concepts to design and develop Entity Relationship Diagrams for efficient data representation and storage.

GLO1: Discipline-specific knowledge and capabilities
GLO4: Critical thinking
GLO5: Problem solving

ULO3

Design, implement, evaluate and maintain relational database systems using SQL and Database Management Systems and explain the purpose of various SQL commands and operations.

GLO1: Discipline-specific knowledge and capabilities
GLO3: Digital literacy
GLO4: Critical thinking

ULO4

Analyse and critique the achievements of learning outcomes and justify meeting specified outcomes through providing relevant evidence and evaluating the quality of that evidence against given criteria.

GLO4: Critical thinking
GLO6: Self-management

ULO5

Conduct research on and critically evaluate tools and technologies used in contemporary business information systems to manage and analyse data.

GLO1: Discipline-specific knowledge and capabilities
GLO4: Critical thinking

Assessment

Trimester 1:
Assessment Description Student output Grading and weighting
(% total mark for unit)
Indicative due week
Database Design and Implementation Report Written report 30% Week 7
Information Retrieval Techniques Problem Solving Task Written responses to problem scenarios 30% Week 10
Examination 2-hour written examination 40% Examination period
Trimester 2 and 3:
Assessment Description Student output Grading and weighting
(% total mark for unit)
Indicative due week
Learning Portfolio  Portfolio consisting of research reports, online quizzes, completion reports, database design documents and SQL scripts, learning summary report. 100% Week 12

The assessment due weeks provided may change. The Unit Chair will clarify the exact assessment requirements, including the due date, at the start of the teaching period.

Hurdle requirement

Trimester 2 and 3: To be eligible to obtain a pass in this unit, students must meet certain milestones as part of the portfolio.

Learning Resource

The texts and reading list for the unit can be found on the University Library via the link below: SIT772 Note: Select the relevant trimester reading list. Please note that a future teaching period's reading list may not be available until a month prior to the start of that teaching period so you may wish to use the relevant trimester's prior year reading list as a guide only.

Unit Fee Information

Click on the fee link below which describes you: