Database, Analysis and Design
Available to incoming Study Abroad and Exchange students
Overview
This unit delivers the fundamental principles needed to effectively design and use databases. Databases are the tool used to create, store, organise, and disseminate data. It seeks to unpack the notion of data, and introduce contemporary tools and techniques for storing, retrieving, exploiting, and visualising data. Emphasis is given to understanding data modelling and design approaches, and the emerging opportunities afforded by big data, social media, data analytics, and unstructured data. The unit focuses on commercial and open-source database management tools.
Requisites
Teaching periods
Location
Start and end dates
Last self-enrolment date
Census date
Last withdraw without fail date
Results released date
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
Teaching methods
Hawthorn
| Type | Hours per week | Number of weeks | Total (number of hours) |
|---|---|---|---|
| Face to Face Contact (Phasing out) Lecture | 2.00 | 12 weeks | 24 |
| Face to Face Contact (Phasing out) Tutorial Labs | 2.00 | 12 weeks | 24 |
| Unspecified Learning Activities (Phasing out) Independent Learning | 8.50 | 12 weeks | 102 |
| TOTAL | 150 |
OUA
| Type | Hours per week | Number of weeks | Total (number of hours) |
|---|---|---|---|
| Online Contact (Phasing out) Online Learning Activities | 12.00 | 12 weeks | 144 |
| Online Directed Online Learning and Independent Learning | 0.50 | 12 weeks | 6 |
| TOTAL | 150 |
Assessment
| Type | Task | Weighting | ULO's |
|---|---|---|---|
| Portfolio | Individual | 100% | 1,2,3,4 |
Content
- 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, visualisations, and functions
- Semi-structured and unstructured data storage
- Applications and examples of data and 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.