Overview

This unit prepares students to demonstrate knowledge of designing and developing database systems on cloud infrastructure. Students will undertake the basics of create, read, update and delete of database records. This unit will also discuss basic architecture and potential use cases for the setup of database systems for the collection, analysing and presenting data.

Requisites

Teaching Periods
Location
Start and end dates
Last self-enrolment date
Census date
Last withdraw without fail date
Results released date
HE Block 8
Location
Hawthorn
Start and end dates
29-July-2024
15-December-2024
Last self-enrolment date
11-August-2024
Census date
30-August-2024
Last withdraw without fail date
11-October-2024
Results released date
17-December-2024

Learning outcomes

Students who successfully complete this unit will be able to:

  • Understand essential database requirements to perform data manipulation
  • Perform create, read, update and delete tasks to data set
  • Analyse requirements and conduct ETL of large datasets in the cloud
  • Determine appropriate database management system type for cloud deployment
  • Use tools to ensure optimization of dynamic datasets

Teaching methods

Hawthorn

Type Hours per week Number of weeks Total (number of hours)
Face to Face Contact (Phasing out)
Laboratory
3.00 13 week 39
Face to Face Contact (Phasing out)
Laboratory
3.00 13 week 39
Unspecified Learning Activities (Phasing out)
Independent Learning
3.54 13 week 46
Online
Directed Online Learning and Independent Learning
2.00 13 week 26
TOTAL150

Assessment

Type Task Weighting ULO's
AssignmentGroup 40 - 60% 2,3,4,5 
TestIndividual 30 - 40% 2,3,5 
TestIndividual 10 - 20% 1,2 

Hurdle

As the minimum requirements of assessment to pass a unit and meet all ULOs to a minimum standard, an undergraduate student must have achieved:

  • An aggregate mark for the unit of 50% or more, including
  • At least 35% of the possible final marks for each Major Assessment Component (any assessment worth 20% or more)
  • At least 45% in the final exam

 

Students who do not achieve at least 35% of the possible final marks for each Major Assessment Component and at least 45% for the final exam (if applicable), will receive a maximum of 44% as the total mark for the unit and will not be eligible for a conceded pass. 
 
The Major Assessment Components in this unit are the Online Activities (combined grade), Computer Lab Reports (combined grade) and the Exam. 

Content

  • CRUD for Databases
  • Identify appropriate cloud services
  • Managing and Executing ETL
  • Prepare cloud services for data scalability

    Types of data including structured, semi-structured and unstructured

    Data storage types including database, data lakes, data warehouses and data marts Data schema

  • Identifying opportunities to create business value through use of BI concepts and tools.

Study resources

Reading materials

A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.