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
  • Topics
    • 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

Entry Requirements

Equivalent Subjects

You cannot enrol in this unit 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 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.

  • Assignment 1 - Individual ((100%)%)

Textbooks are subject to change within the academic year. Students are advised to purchase their books no earlier than one to two months before the start of a subject

Related degrees