Availabilities:

LocationDomesticInternational
SCU Online
Study Period3,6
Study Period3,6

Unit description

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.

GA1: Intellectual rigour, GA2: Creativity, GA3: Ethical practice, GA4: Knowledge of a discipline, GA5: Lifelong learning, GA6: Communication and social skills, GA7: Cultural competence
On completion of this unit, students should be able to:GA1GA2GA3GA4GA5GA6GA7
1identify and explain the terminology of the relational database modelKnowledge of a discipline
2model business information requirementsIntellectual rigourKnowledge of a disciplineCommunication and social skills
3understand the processes used to translate data models into a logical database design with normalised relationsIntellectual rigourKnowledge of a discipline
4identify and design the essential elements of testing strategies needed to test and prove the functionality of a databaseIntellectual rigourKnowledge of a discipline
5describe the steps to develop a physical database designIntellectual rigourKnowledge of a discipline
6explain the key managerial functions for effective administration of an enterprise’s databasesIntellectual rigourKnowledge of a disciplineCommunication and social skills
7describe the key elements of an effective database and data security strategy.Intellectual rigourKnowledge of a discipline

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

  1. identify and explain the terminology of the relational database model
    • GA4: Knowledge of a discipline
  2. model business information requirements
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline
    • GA6: Communication and social skills
  3. understand the processes used to translate data models into a logical database design with normalised relations
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline
  4. identify and design the essential elements of testing strategies needed to test and prove the functionality of a database
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline
  5. describe the steps to develop a physical database design
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline
  6. explain the key managerial functions for effective administration of an enterprise’s databases
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline
    • GA6: Communication and social skills
  7. describe the key elements of an effective database and data security strategy.
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline

Prescribed texts

  • This text is available via the Co-op Bookshop and may be available second-hand: Kroenke, D & Auer, DA, 2015, Database Concepts , 7th edn (Global Edition), Pearson Higher Education, USA. ISBN: 9781292076232.

  • This text is available via the Co-op Bookshop and may be available second-hand: Kroenke, D & Auer, DA, 2015, Database Concepts , 7th edn (Global Edition), Pearson Higher Education, USA. ISBN: 9781292076232.
Prescribed texts may change in future study periods.

Teaching and assessment

Teaching method
Structured online learning
Assessment
Quiz10%
Quiz10%
Create and test a database35%
Design, create and test a database and develop documentation report45%
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.

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.

+