Unit Outline

This unit will familiarise you with the fundamental concepts of database design and implementation techniques to define, construct and query a database. In this unit you will develop basic skills in data modelling using relational data models and normalisation to ensure data integrity. You will learn how to transform a data model into a relational database design as well as effectively mine data using the structured query language (SQL). You will explore a range of data visualisation techniques to be able to address organisation information requests. Essential requirements for secure data management to ensure data privacy and other legal responsibilities will also be covered including data mining, data lakes, and data warehousing.

Intended Learning Outcomes

As per the Assessment and Results Policy 1.3, your results will reflect your achievement against specified learning outcomes.

On completion of this unit, you will be able to:


1	Develop database designs using relational data modelling, normalisation, and entity-relationship diagrams
2	Implement and administer secure databases using a database management system
3	Apply SQL commands to mine data from databases and data visualisation techniques to address organisation information needs
4	Explain the privacy and legal requirements associated with managing and storing data

Requisites


REQUISITE TYPE	REQUISITES
Anti-requisite (mutual excl)	KIT119

Alterations as a result of student feedback

How will I be Assessed?

For more detailed assessment information please see MyLO.

Assessment schedule


ASSESSMENT TASK #	ASSESSMENT TASK NAME	DATE DUE	WEIGHT	LINKS TO INTENDED LEARNING OUTCOMES
Assessment Task 1:	Database Design	Week 5	30 %	LO1
Assessment Task 2:	Database Implementation	Week 9	20 %	LO2, LO4
Assessment Task 3:	Data visualisation Report	Week 13	20 %	LO3
Assessment Task 4:	Module and Tutorial Exercises	Refer to Assessment Description	30 %	LO1, LO2, LO3, LO4

Assessment details

Assessment Task 1: Database Design

Task Description:

Given a scenario you will create a concept schema and normalised database design using relational modelling and entity relationship diagrams.

Task Length:

3-5 pages

Due Date:

Week 5

Weight:

30 %

CRITERION #

CRITERION

MEASURES INTENDED

LEARNING OUTCOME(S)


1	Develop a database design using relational data modelling and an entity-relationship diagram	LO1
2	Normalise the database design	LO1

Assessment Task 2: Database Implementation

Task Description:

Given a database design you will implement the design in a database management system using sql commands. You will apply sql commands to set the necessary protections to secure your database and meet privacy and other legal requirements.

Task Length:

A relational database comprising less than ten tables

Due Date:

Week 9

Weight:

20 %

CRITERION #

CRITERION

MEASURES INTENDED

LEARNING OUTCOME(S)


1	Implement a database from a database design using a database management system	LO2
2	Administer a secure database ensuring privacy and other legal requirements are fulfilled	LO2, LO4

Assessment Task 3: Data visualisation Report

Task Description:

Given a database and a set of information requests, using sql commands to extract the required data and then using data visualisation techniques you will compile a short report to provide informed answers.

Task Length:

3-5 pages

Due Date:

Week 13

Weight:

20 %

CRITERION #

CRITERION

MEASURES INTENDED

LEARNING OUTCOME(S)


1	Apply SQL commands to mine data from a database	LO3
2	Use data visualisation techniques to provide answers to information requests	LO3

Assessment Task 4: Module and Tutorial Exercises

Task Description:

Throughout semester you will complete module and tutorial exercises and answer questions that examine your knowledge and skills to complete database design, normalisation, database administration, querying, data visualisation and data management.

Task Length:

short quizzes and tutorial exercises

Due Date:

Refer to Assessment Description

Weight:

30 %

CRITERION #

CRITERION

MEASURES INTENDED

LEARNING OUTCOME(S)


1	Correctly answer questions on database design and data management	LO1, LO4
2	Apply sql and data visualization techniques to answer queries and administer a database	LO2, LO3

How your final result is determined

To pass this unit, you need to demonstrate your attainment of each of the Intended Learning Outcomes, achieve a final unit grade of 50% or greater, and pass any hurdle tasks.

Submission of assignments

Where practicable, assignments should be submitted to an assignment submission folder in MYLO. You must submit assignments by the due date or receive a penalty (unless an extension of time has been approved by the Unit Coordinator). Students submitting any assignment in hard copy, or because of a practicum finalisation, must attach a student cover sheet and signed declaration for the submission to be accepted for marking.

Academic integrity

Academic integrity is about acting responsibly, honestly, ethically, and collegially when using, producing, and communicating information with other students and staff members.

In written work, you must correctly reference the work of others to maintain academic integrity. To find out the referencing style for this unit, see the assessment information in the MyLO site, or contact your teaching staff. For more detail about Academic Integrity, see Important Guidelines & Support.

Requests for extensions

If you are unable to submit an assessment task by the due date, you should apply for an extension.

A request for an extension should first be discussed with your Unit Coordinator or teaching support team where possible. A request for an extension must be submitted by the assessment due date, except where you can provide evidence it was not possible to do so. Typically, an application for an extension will be supported by documentary evidence: however, where it is not possible for you to provide evidence please contact your Unit Coordinator.

The Unit Coordinator must notify you of the outcome of an extension request within 3 working days of receiving the request.

Late penalties

Assignments submitted after the deadline will receive a late penalty of 5% of the original available mark for each calendar day (or part day) that the assignment is late. Late submissions will not be accepted more than 10 calendar days after the due date, or after assignments have been returned to other students on a scheduled date, whichever occurs first. Further information on Late Penalties can be found on the Assessments and Results Procedure.

Review of results and appeals

You are entitled to ask for a review of the marking and grading of your assessment task if there is an irregularity in the marking standards or an error in the process for determining the outcome of an assessment. Details on how to request a review of a mark for an assignment are outlined in the Review and Appeal of Academic Decisions Procedure.