Availabilities:
| Location | Domestic | International |
|---|---|---|
| Gold Coast |
Unit description
Provides introduction to data management in an enterprise. Students will learn to design, build and evaluate databases, including relational and non-relational database technologies. Furthermore, students will learn some advanced techniques for managing Big Data.
Unit content
Topic 1: Introduction to Data Management
Topic 2: Relational Data Models
Topic 3: Creating Normalised Databases
Topic 4: Structured Query Language (SQL) Scripts
Topic 5: Data Modelling and Entity-Relationship Model
Topic 6: Database Design
Topic 7: Web/Client-Server Database Applications
Topic 8: Database Administration
Topic 9: Database Security
Topic 10: Big Data and Non-traditional Databases
Topic 11: Data Warehousing
Topic 12: Recent Advances in Big Data Management
Learning outcomes
Unit Learning Outcomes express learning achievement in terms of what a student should know, understand and be able to do on completion of a unit. These outcomes are aligned with the graduate attributes. The unit learning outcomes and graduate attributes are also the basis of evaluating prior learning.
| On completion of this unit, students should be able to: | GA1 | GA2 | GA3 | GA4 | GA5 | GA6 | GA7 | |
|---|---|---|---|---|---|---|---|---|
| 1 | discuss the database model | Knowledge of a discipline | ||||||
| 2 | model organisation database needs | Intellectual rigour | Knowledge of a discipline | |||||
| 3 | explain the process of database design | Intellectual rigour | Knowledge of a discipline | |||||
| 4 | design and develop databases from business organisation needs | Intellectual rigour | Creativity | Knowledge of a discipline | ||||
| 5 | identify and design the essential elements of testing strategies needed to test and prove the functionality of a database | Intellectual rigour | Creativity | Knowledge of a discipline | ||||
| 6 | create, write and execute SQL queries | Creativity | Knowledge of a discipline | |||||
On completion of this unit, students should be able to:
- discuss the database model
- GA4: Knowledge of a discipline
- model organisation database needs
- GA1: Intellectual rigour
- GA4: Knowledge of a discipline
- explain the process of database design
- GA1: Intellectual rigour
- GA4: Knowledge of a discipline
- design and develop databases from business organisation needs
- GA1: Intellectual rigour
- GA2: Creativity
- GA4: Knowledge of a discipline
- identify and design the essential elements of testing strategies needed to test and prove the functionality of a database
- GA1: Intellectual rigour
- GA2: Creativity
- GA4: Knowledge of a discipline
- create, write and execute SQL queries
- GA2: Creativity
- GA4: Knowledge of a discipline
Prescribed texts
- Prescribed text information is not currently available.
- Prescribed text information is not currently available.
Teaching and assessment
| Teaching method |
| Lecture online 1 hour (12 weeks) |
| Workshop online 2 hours (12 weeks) |
| Assessment | |
| Quiz | 30% |
| Practical skills | 20% |
| Database Design and Modelling | 25% |
| Practical skills | 25% |
Fee information
Domestic
Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.
Fee paying courses
For postgraduate or undergraduate full fee paying courses please check Domestic Postgraduate Fees OR Domestic Undergraduate Fees
International
Please check the international course and fee list to determine the relevant fees.