You are currently viewing the 2018 version of this course. Change to 2019

Subject details

Students who successfully complete this subject will be able to:

  1. Explain the concepts of structured, semi-structured and unstructured data and how they are used by organisations
  2. Use data analysis methods to produce and document a logical data model
  3. Explain and demonstrate the key principles involved in good database design
  4. Design and use simple database systems using a commercial relational database and management system tools
  5. Work collaboratively in diverse groups
    • Information in the organisation
    • DBMS terminology and concepts.
    • The relational data model.
    • Structured Query Language
    • Entity relational analysis
    • Normalisation of data
    • Data integrity
    • Data warehousing
    • Data normalisation
    • Storage of semi-structured and unstructured data
    • Querying semi-structured and unstructured data

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:

  • INF20004
  • SWI-CIS211

Special requirements

No special requirements

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

This subject describes how to deal with the data available to organisations from both internal and external sources, how data is stored and retrieved in ways which are useful and effective. Students are introduced to techniques of data modelling and database design as a means of analysing, understanding and recording data. Some of the key commercial database management tools are discussed along with tools for quick and easy data retrieval and visualisation. The subject also introduces students to how people and organisations can access, analyse and make use of data found in social media etc.

  • Individual (Portfolio) (100%)

Textbook information is pending.

Related degrees

undergraduate SWI-CIS-DEG-2018

Bachelor of Business Information Systems

  • Core Subjects Information Systems
  • Major in Business Analysis
  • Major in Data Analytics
  • Co-Major in Economics
  • Co-Major in Marketing

undergraduate SWI-BUS-DEG-2018

Bachelor of Business

  • Bachelor of Business Core Subjects
  • Major in Advertising (this Major is currently in teach-out)
  • Major in Economics
  • Major in Finance
  • Major in Information Systems
  • Major in Marketing
  • Co-Major in Advertising (this Co-Major is currently in teach-out)
  • Co-Major in Economics (for Finance students)
  • Co-Major in Economics (not for Finance students)
  • Co-Major in Finance (cannot be taken with the Finance or Economics Major)
  • Co-Major in Finance (for Economics students)
  • Co-Major in Information Systems
  • Co-Major in Marketing (cannot be taken with the Marketing Major)