Availabilities:

2021 unit offering information will be available in November 2020

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. 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.

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
1list and explain the terminology of the relational database modelKnowledge of a discipline
2analyse business information requirements using entity relationship diagrams (ERD)Intellectual rigourCreativityKnowledge of a discipline
3analyse a data model (ERD) into a logical database design with normalised relationsKnowledge of a discipline
4design, develop, test and prove the functionality of a databaseIntellectual rigourCreativityKnowledge of a discipline
5construct, write and execute SQL queriesKnowledge of a discipline
6explain the necessary steps to develop an effective physical database designIntellectual rigourKnowledge of a discipline
7explain the main functions of database administration and data warehouses.Intellectual rigourKnowledge of a discipline

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

  1. list and explain the terminology of the relational database model
    • GA4: Knowledge of a discipline
  2. analyse business information requirements using entity relationship diagrams (ERD)
    • GA1: Intellectual rigour
    • GA2: Creativity
    • GA4: Knowledge of a discipline
  3. analyse a data model (ERD) into a logical database design with normalised relations
    • GA4: Knowledge of a discipline
  4. design, develop, test and prove the functionality of a database
    • GA1: Intellectual rigour
    • GA2: Creativity
    • GA4: Knowledge of a discipline
  5. construct, write and execute SQL queries
    • GA4: Knowledge of a discipline
  6. explain the necessary steps to develop an effective physical database design
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline
  7. explain the main functions of database administration and data warehouses.
    • GA1: Intellectual rigour
    • GA4: Knowledge of a discipline

Teaching and assessment

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 2021 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.

+