Unit aim

This unit will provide 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 emphasized and introduced using structured queried language (SQL) for creating and manipulating databases. Assignment work includes the analysis, design, and implementation of a database.

Unit content

1. Database fundamentals 
2. Introduction to relational databases 
3. Creating databases 
4. SQL scripts 
5. Data modelling 
6. Introduction to database web apps 
7. Advanced database design 
8. Client server databases 
9. More web applications 
10. 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.

Learning outcomes and graduate attributes

Prescribed texts

Session 1

  • Note: Page numbers for 6th edition are provided in the study guide.: Kroenke, DA & Auer, DJ, 2015, Database Concepts, 7th edn, Pearson Prentice Hall, New Jersey USA.

Session 3

  • Note: Page numbers for 6th edition are provided in the study guide: Kroenke, DA & Auer, DJ, 2015, Database Concepts, 7th edn, Pearson Prentice Hall, New Jersey USA.
Prescribed texts may change in future study periods.

Teaching and assessment

China - Guangxi UST

Teaching method
Workshop on-site
Assessment
Quiz15%
Practical skills15%
Project30%
Exam: closed book40%

Coffs Harbour

Teaching method
Lecture online 1 hour (12 weeks)
Tutorial on-site 2 hours (12 weeks)
Assessment
Quiz15%
Practical skills15%
Project30%
Exam: closed book40%

Gold Coast

Teaching method
Lecture online 1 hour (12 weeks)
Tutorial on-site 2 hours (12 weeks)
Assessment
Quiz15%
Practical skills15%
Project30%
Exam: closed book40%

Melbourne

Teaching method
Lecture on-site 1 hour (12 weeks)
Tutorial on-site 2 hours (12 weeks)
Assessment
Quiz15%
Practical skills15%
Project30%
Exam: closed book40%

Online

Teaching method
Lecture online 1 hour (12 weeks)
Assessment
Quiz15%
Practical skills15%
Project30%
Exam: closed book40%

Sydney

Teaching method
Lecture on-site 1 hour (12 weeks)
Tutorial on-site 2 hours (12 weeks)
Assessment
Quiz15%
Practical skills15%
Project30%
Exam: closed book40%
Notice

Intensive offerings may or may not be scheduled in every session. 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 study session.

Fee information

Domestic

Commonwealth Supported courses
For information regarding Student Contribution Amounts please visit the Student Contribution Amounts.
Commencing 2016 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.