Availabilities:

LocationDomesticInternational
China - Guangxi USTN/A
Coomera
Gold Coast
Term1,5
Term1,5
MelbourneN/A
Term1,5
Online
Term1,5
N/A
Papua New Guinea - IBSU Port MoresbyN/A
Term1,5
PerthN/A
Term1,5
SydneyN/A
Term1,5

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

  1. Database fundamentals
  2. The relational database model
  3. Creating databases
  4. Database design
  5. Advanced database design
  6. Database administration and client server databases

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:
1Write and execute SQL queries for a relational database
2analyse business or application requirements and model solutions using entity relationship diagrams (ERD)
3design a logical database which meets business, application and the security needs for a client/server application
4design, develop, test and prove the functionality of a database

On completion of this unit, students should be able to:

  1. Write and execute SQL queries for a relational database
  2. analyse business or application requirements and model solutions using entity relationship diagrams (ERD)
  3. design a logical database which meets business, application and the security needs for a client/server application
  4. design, develop, test and prove the functionality of a database

Prescribed Learning Resources

Prescribed Texts
  • No prescribed texts.
Prescribed Resources/Equipment
  • Microsoft Visio or similar is required. See Optional online resources below for alternatives.

    Note that the Study Guide (available on MySCU) has textbook readings and several activities set for each week. The Workshops folders on MySCU provide, for each topic, additional hands-on exercises which may be downloaded.

Prescribed Texts
  • Prescribed text information is not currently available.
Prescribed Resources/Equipment
  • Prescribed resources/equipment information is not currently available.
Prescribed Learning Resources may change in future Teaching Periods

Teaching and assessment

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%

Teaching method
Workshop 1 hour (Weekly)
Tutorial 2 hours (Weekly)
Assessment
Project45%
Portfolio45%
Practical Skills (Access and SQL)10%
Notice

Intensive offerings may or may not be scheduled in every teaching period. Please refer to the timetable for further details.

Southern Cross University employs different teaching methods within units to provide students with the flexibility to choose the mode of learning that best suits them. SCU academics strive to use the latest approaches and, as a result, the learning modes and materials may change. The most current information regarding a unit will be provided to enrolled students at the beginning of the teaching period.

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.

+