Data Management and Analytics
Overview
This unit will provide a solid foundation for the design, implementation and management of organisational databases. Organisational data and data modelling is introduced, focusing on structured and unstructured data, and entity-relationship (ER) modelling. The skills required to construct ER diagrams will be taught, with a focus on ensuring that the logic of the model reflects the real-world industry case it is representing. Relational databases will be introduced and the functionality they afford organisations will be explored through real world industry cases. The process of designing, building and retrieving information from a database using SQL will be a focus of this unit. The unit also introduces students to the role databases play in data analytics and helping organisations harness the power of and insights from their data.
Requisites
26-May-2024
27-October-2024
Learning outcomes
Students who successfully complete this unit will be able to:
- Define and explain fundamental data and database concepts including tables, relations, keys, queries, transactions, and structured, semi-structured, unstructured data
- Create, store, retrieve, exploit, and visualise data using modern database tools, functions, and techniques
- Understand and apply conventional data modelling techniques to solve practical database design problems
- Explain the impact of big data and modern data analytics tools in the design, use, and management of database systems
- Examine the application of database technologies and methods in Blockchain, Artificial Intelligence, and Chatbot technologies and social media
Teaching methods
Hawthorn
| Type | Hours per week | Number of weeks | Total (number of hours) |
|---|---|---|---|
| Face to Face Contact (Phasing out) Tutorial Labs | 2.00 | 12 weeks | 24 |
| Online Directed Online Learning and Independent Learning | 1.00 | 12 weeks | 12 |
| Unspecified Learning Activities (Phasing out) 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,4,5 |
Content
- Structured and unstructured data
- Database relations, tables, records, keys, filters, queries, parameters, forms, indexes
- Data formats, manipulation, and exchange tools
- Transactions and ACID
- Entity-relationship diagrams and modelling
- SQL
- Data warehousing, big data, and data normalisation
- Data analytics, business intelligence, data visualisation
Study resources
Reading materials
A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.