Availabilities:
| Location | Domestic | International |
|---|---|---|
| China - Guangxi UST | N/A | |
| Gold Coast | ||
| Melbourne | N/A | |
| Online | N/A | |
| Papua New Guinea - IBSU Port Moresby | N/A | |
| Perth | N/A | |
| Sydney | N/A |
Unit description
Provides the student with an overall understanding of database concepts and theory. Students will learn how to design and build a database, from data analysis to mapping a specific database model. The relational model is emphasised and introduced using structured queried language (SQL) for creating and manipulating databases.
Unit content
- Database fundamentals
- Introduction to relational databases
- Creating databases
- SQL scripts
- Data modelling
- Introduction to database web apps
- Advanced database design
- Client server databases
- More web applications
- Database administration and warehousing
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 | list and explain the terminology of the relational database model | Knowledge of a discipline | ||||||
| 2 | analyse business information requirements using entity relationship diagrams (ERD) | Intellectual rigour | Creativity | Knowledge of a discipline | ||||
| 3 | analyse a data model (ERD) into a logical database design with normalised relations | Knowledge of a discipline | ||||||
| 4 | design, develop, test and prove the functionality of a database | Intellectual rigour | Creativity | Knowledge of a discipline | ||||
| 5 | construct, write and execute SQL queries | Knowledge of a discipline | ||||||
| 6 | explain the necessary steps to develop an effective physical database design | Intellectual rigour | Knowledge of a discipline | |||||
| 7 | explain the main functions of database administration and data warehouses. | Intellectual rigour | Knowledge of a discipline | |||||
On completion of this unit, students should be able to:
- list and explain the terminology of the relational database model
- GA4: Knowledge of a discipline
- analyse business information requirements using entity relationship diagrams (ERD)
- GA1: Intellectual rigour
- GA2: Creativity
- GA4: Knowledge of a discipline
- analyse a data model (ERD) into a logical database design with normalised relations
- GA4: Knowledge of a discipline
- design, develop, test and prove the functionality of a database
- GA1: Intellectual rigour
- GA2: Creativity
- GA4: Knowledge of a discipline
- construct, write and execute SQL queries
- GA4: Knowledge of a discipline
- explain the necessary steps to develop an effective physical database design
- GA1: Intellectual rigour
- GA4: Knowledge of a discipline
- explain the main functions of database administration and data warehouses.
- GA1: Intellectual rigour
- GA4: Knowledge of a discipline
Prescribed texts
- Note: While the 7th edition of the following text is recommended, page numbers for the 6th edition are also provided in the study guide: Kroenke, DA & Auer, DJ, 2015, Database Concepts, 7th edn, Pearson Education, New Jersey, USA.
- Prescribed text information is not currently available.
- Prescribed text information is not currently available.
Teaching and assessment
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.