Availabilities:
2020 unit offering information will be available in September 2019
Unit aim
Provides students with an overall understanding of database concepts and theory. Students will learn the steps required to design and build databases and the key elements required to manage and maintain databases in an enterprise.
Unit content
Topic 1: Database Fundamentals
Topic 2: Using Databases and Scripts
Topic 3: Data Modelling and Database Design
Topic 4: Physical Database Design and Client-Server Databases
Topic 5: Database Administration and Security
Topic 6: Big Data and Database 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.
Learning outcomes and graduate attributes
| On completion of this unit, students should be able to: | GA1 | GA2 | GA3 | GA4 | GA5 | GA6 | GA7 | |
|---|---|---|---|---|---|---|---|---|
| 1 | identify and explain the terminology of the relational database model | Knowledge of a discipline | ||||||
| 2 | model business information requirements | Intellectual rigour | Knowledge of a discipline | Communication and social skills | ||||
| 3 | understand the processes used to translate data models into a logical database design with normalised relations | Intellectual rigour | Knowledge of a discipline | |||||
| 4 | identify and design the essential elements of testing strategies needed to test and prove the functionality of a database | Intellectual rigour | Knowledge of a discipline | |||||
| 5 | describe the steps to develop a physical database design | Intellectual rigour | Knowledge of a discipline | |||||
| 6 | explain the key managerial functions for effective administration of an enterprise’s databases | Intellectual rigour | Knowledge of a discipline | Communication and social skills | ||||
| 7 | describe the key elements of an effective database and data security strategy. | Intellectual rigour | Knowledge of a discipline | |||||
Prescribed texts
Study Period 3
- This text is available via the Co-op Bookshop and may be available second-hand: Kroenke, D & Auer, DA, 2015, Database Concepts , 7th (Global Edition), Pearson Higher Education, USA. ISBN: 9781292076232.
Study Period 6
- Prescribed text information is not currently available.
Teaching and assessment
SCU Online (intensive)
| Teaching method |
| Structured online learning |
| Assessment | |
| Quiz | 10% |
| Quiz | 10% |
| Create and test a database | 35% |
| Design, create and test a database and develop documentation report | 45% |
Fee information
Domestic
Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.
Commencing 2020 Commonwealth Supported only. Student contribution band: 2
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.