Subject details

Students who successfully complete this subject will be able to:

  1. Define and explain fundamental data and database concepts including tables, relations, keys, queries, transactions, and structured, semi-structured, unstructured data

  2. Create, store, retrieve, exploit, and visualise data using modern database tools, functions, and techniques

  3. Understand and apply conventional data modelling techniques to solve practical database design problems

  4. Explain the impact of big data and modern data analytics tools in the design, use, and management of database systems.

    • Database relations, tables, records, keys, filters, queries, parameters, forms, indexes
    • Data formats, manipulation, and exchange tools
    • Transactions and ACID
    • Entity-relationship diagrams and modelling
    • SQL
    • Data warehousing, big data, and data normalisation
    • Data analytics, business intelligence, visualisations, and functions
    • Semi-structured and unstructured data storage
    • Applications and examples of data and databases in organisations

Equivalent subjects

You cannot enrol in this subject if you have successfully completed any of the following subject(s) because they are considered academically equivalent:

  • SWI-INF20004
  • SWI-CIS211
  • SWI-CIS210

Special requirements

No special requirements

This subject was previously known as INF20004 Database Concepts and Modelling.

This subject delivers the fundamental principles needed to effectively design and use databases. Databases are the tool used to create, store, organise, and disseminate data.  It seeks to unpack the notion of data, and introduce contemporary tools and techniques for storing, retrieving, exploiting, and visualising data. Emphasis is given to understanding data modelling and design approaches, and the emerging opportunities afforded by big data, social media, data analytics, and unstructured data. The unit focuses on commercial and open-source database management tools.

  • Individual (Portfolio) (100%)

Textbook information is pending.

Related degrees

undergraduate SWI-CIS-DEG-2019

Bachelor of Business Information Systems

close
  • Core Subjects Information Systems
  • Major in Business Analysis
  • Major in Data Analytics
  • Co-Major in Economics (THIS CO-MAJOR IS CURRENTLY IN TEACH-OUT)
  • Co-Major in Marketing

undergraduate SWI-BUS-DEG-2019

Bachelor of Business

close
  • Major in Economics (THIS MAJOR IS CURRENTLY IN TEACH-OUT)
  • Major in Finance (THIS MAJOR IS CURRENTLY IN TEACH-OUT)
  • Major in Information Systems
  • Major in Marketing
  • Co-Major in Economics (for Finance students) (THIS CO-MAJOR IS CURRENTLY IN TEACH-OUT)
  • Co-Major in Economics (not for Finance students) (THIS CO-MAJOR IS CURRENTLY IN TEACH-OUT)
  • Co-Major in Finance (cannot be taken with the Finance or Economics Major) (THIS CO-MAJOR IS CURRENTLY IN TEACH-OUT)
  • Co-Major in Finance (for Economics students) (THIS CO-MAJOR IS CURRENTLY IN TEACH-OUT)
  • Co-Major in Information Systems
  • Co-Major in Marketing (cannot be taken with the Marketing Major)