Course syllabus

Jump to today

Class timetable

Week

Topic

Activities

Assessments

Week 1

 Introduction to databases and a brief overview of database management systems

Reading: Week 1 lecture slides

Activity: Watch LinkedinLearning Video, Lectorial 1 discussions. No prac sessions in Week 1.

Week 2

 Relational Database Concepts

Reading: Week 2 lecture slides

Activity: Watch LinkedinLearning Video, Lectorial 2 discussions. Attend Week 2 Prac Sessions

Week 3

 Entity-Relationship Modeling -- Part 1

Reading: Week 3-4 lecture slides, Chapter 12, Database Systems: a Practical Approach to Design, Implementation, and Management by Carolyn Begg, Thomas Connolly; Listen to Chapter 4 (sections: Understanding Entities, Developing Relationships) of Adam Wilbert's LinkedIn Tutorial

Activity: Get yourself familiarised with SQLite Studio, Lectorial 3 discussions. Attend Week 3 Prac Sessions

Week 4

 Entity-Relationship Modeling -- Part 2

Reading: Week 3-4 lecture slides and watch video recordings; Chapter 12 and 17, Database Systems: a Practical Approach to Design, Implementation, and Management by Carolyn Begg, Thomas Connolly.

Activity: Get yourself a free educational account with LucidChart and familiarise with its interface; Lectorial 4 discussions. Attend Week 4 Prac Sessions.

Week 5

 Basic SQL Programming -- Part 1

Reading: Week 5 lecture slides

Activity: Watch LinkedinLearning Video, Lectorial 2 discussions. Attend Week 2 Prac Sessions

Week 6

 Basic SQL Programming -- Part  2

Reading: Course text, Wks 1 to 5

Assignment 1 due

 

 Semester break – no class

Reading: Review all the lecture slides from Week 1 to Week 6

Activity: No defined learning activities.  Continue working on Assignment 1 and start working on Milestone 1 requirements for the Database Design Project

Week 7

 Advanced SQL Programming -- Part 1

Reading: Week 7 lecture slides

Activity: Lectorial 7 discussions. Attend Week 7 Prac Sessions

Week 8

 Advanced SQL Programming -- Part 2

Reading: Week 8 lecture slides

Activity: Lectorial 8 discussions. Attend Week 8 Prac Sessions

Week 9

 Relational Database Design

Reading: Week 9 lecture slides

Activity: Lectorial 9 discussions. Attend Week 9 Prac Sessions

 Online mid-semester quiz

Week 10

 Relational Database Design -- A case study

Reading: Week 10 lecture slides

Activity: Lectorial 10 discussions. Attend Week 10 Prac Sessions

Week 11

 Advanced Topic -- NoSQL Database Design with MongoDB

Reading: Week 11 lecture slides

Activity:  Lectorial 11 discussions. Attend Week 11 Prac Sessions

 Assignment 2 due

Week 12

 Revision

Reading: Week 12 lecture slides

Activity: Lectorial 12 discussions. Attend Week 12 Prac Sessions

Week 13

Week 14

 Assignment 4 due

Week 15

Week 16

 

 

Assessment Summary and Rubric

Click/Tap on the assessment items for more information

Assessment Task 1 - [Enter title here]

Due Date [...]
Weighting [...]
Course learning outcomes [CLO1, CLO2,....]

Summary and purpose of assessment

Use your innovative concepts and search for necessary information from anywhere in the world.

Assignment 1 is to develop your ability to manage a large scale risk management process. This assignment a group assignment and will be submitted as a written report.

The international risk management standard ISO 31000 should be used to develop your risk management plan. You should select a case from any of the following:

  • Build a high rise building in the central business district of Melbourne
  • Supply 10% of Victoria energy requirements with tidal generation
  • Ban all fossil fuel vehicles in Australia by 2035

Assessment criteria and rubric

The assessment scheme for Assignment 1 is outlined in Table below. The score total is 100% for the purpose of marking. The system will scale the score to 30% of the overall course assessment score.

The detailed rubric can downloaded HERE [insert rubric file]

Assessment item Percent
Clarity of the context of the case. 15
Appropriateness and clarity of the risks identified. 20
Thoughtful application of techniques to each risk identified above.   Likelihood and consequences assessments are reasonable. 20
Elaborated reasoning on the evaluation of risk levels based on the risk framework matrix. 20
Clarity of planned actions for all risks that are found unacceptable. 15
Overall structure of risk management plan, clarity of arguments. 10

 

Assessment Task 2 - [Enter title here]

Due Date [...]
Weighting [...]
Course learning outcomes [CLO1, CLO2,....]

Summary and purpose of assessment

Enter assessment summary and purpose here

Assessment criteria and rubric

The assessment scheme for Assignment 2 is outlined in Table below. The score total is 100% for the purpose of marking. The system will scale the score to [30%] of the overall course assessment score.

The detailed rubric can downloaded HERE [insert rubric file]

Assessment item Percent
Clarity of the context of the case. 15
Appropriateness and clarity of the risks identified. 20
Thoughtful application of techniques to each risk identified above.   Likelihood and consequences assessments are reasonable. 20
Elaborated reasoning on the evaluation of risk levels based on the risk framework matrix. 20
Clarity of planned actions for all risks that are found unacceptable. 15
Overall structure of risk management plan, clarity of arguments. 10

 

Assessment Task 3 - [Enter title here]

Due Date [...]
Weighting [...]
Course learning outcomes [CLO1, CLO2,....]

Summary and purpose of assessment

Enter assessment summary and purpose here

Assessment criteria and rubric

The assessment scheme for Assignment 3 is outlined in Table below. The score total is 100% for the purpose of marking. The system will scale the score to [20%] of the overall course assessment score.

The detailed rubric can downloaded HERE [insert rubric file]

Assessment item Percent
Clarity of the context of the case. 15
Appropriateness and clarity of the risks identified. 20
Thoughtful application of techniques to each risk identified above.   Likelihood and consequences assessments are reasonable. 20
Elaborated reasoning on the evaluation of risk levels based on the risk framework matrix. 20
Clarity of planned actions for all risks that are found unacceptable. 15
Overall structure of risk management plan, clarity of arguments. 10

 

Assessment Task 4 - [Enter title here]

Due Date [...]
Weighting [...]
Course learning outcomes [CLO1, CLO2,....]

Summary and purpose of assessment

Enter assessment summary and purpose here

Assessment criteria and rubric

The assessment scheme for Assignment 4 is outlined in Table below. The score total is 100% for the purpose of marking. The system will scale the score to [20%] of the overall course assessment score.

The detailed rubric can downloaded HERE [insert rubric file]

Assessment item Percent
Clarity of the context of the case. 15
Appropriateness and clarity of the risks identified. 20
Thoughtful application of techniques to each risk identified above.   Likelihood and consequences assessments are reasonable. 20
Elaborated reasoning on the evaluation of risk levels based on the risk framework matrix. 20
Clarity of planned actions for all risks that are found unacceptable. 15
Overall structure of risk management plan, clarity of arguments. 10

 

 

Course summary:

Date Details Due