Database, Analysis and Design
Overview
This unit challenges participants to critically explore modern database design and application in contemporary society. After delivering the fundamental principles and techniques required for modern database management, the unit challenges participant's to develop innovative database solutions to practical problems, through novel application of data modelling techniques, and commercial and open-source database tools. The opportunities, challenges, and implications of big data, social media, data analytics, and unstructured data on conventional database systems are explored in parallel.
Requisites
27-October-2024
Learning outcomes
Students who successfully complete this unit will be able to:
- Critically evaluate data and database definitions and concepts
- Develop novel solutions to practical data management challenges using modern database tools and data modelling techniques
- Critically explore the organisational, societal, and technical impact of big data, unstructured data, and modern data analytics tools on database system design and management
Teaching methods
Hawthorn
| Type | Hours per week | Number of weeks | Total (number of hours) |
|---|---|---|---|
| On Campus Class (computer labs) |
1.00 | 12 weeks | 12 |
Online Lecture (asynchronous) |
2.00 | 12 weeks | 24 |
| Unspecified Activities Independent Learning |
9.50 | 12 weeks | 114 |
| TOTAL | 150 |
OUA
| Type | Hours per week | Number of weeks | Total (number of hours) |
|---|---|---|---|
| Online Directed Online Learning and Independent Learning | 12.50 | 12 weeks | 150 |
| TOTAL | 150 |
Assessment
| Type | Task | Weighting | ULO's |
|---|---|---|---|
| Portfolio | Individual | 100% | 1,2,3 |
Content
- Data and database fundamentals and conventions
- Data management including SQL
- Data modelling including ERD
- Data warehousing, big data, and data normalisation
- Business intelligence and data analytics
- Semi-structured and unstructured data storage
- Critical design and application of databases in organisations
Study resources
Reading materials
A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.