Back to Find Units Page

Unit of Study DTB91001 - Data Management Systems (2018)

Show me unit information for year

Unit Snapshot

  • Enrolment information

    N/A

Unit description

Provides introduction to data management in an enterprise. Students will learn to design, build and evaluate databases, including relational and non-relational database technologies. Furthermore, students will learn some advanced techniques for managing Big Data.

Unit content

Topic 1: Introduction to Data Management

Topic 2: Relational Data Models

Topic 3: Creating Normalised Databases

Topic 4: Structured Query Language (SQL) Scripts

Topic 5: Data Modelling and Entity-Relationship Model

Topic 6: Database Design

Topic 7: Web/Client-Server Database Applications

Topic 8: Database Administration

Topic 9: Database Security

Topic 10: Big Data and Non-traditional Databases

Topic 11: Data Warehousing

Topic 12: Recent Advances in Big Data Management

Availabilities

Not currently available in 2018

Learning outcomes and graduate attributes

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.

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

GA1: Intellectual rigour, GA2: Creativity, GA3: Ethical practice, GA4: Knowledge of a discipline, GA5: Lifelong learning, GA6: Communication and social skills, GA7: Cultural competence
Learning outcome count Learning outcome description GA1 GA2 GA3 GA4 GA5 GA6 GA7
1 discuss the database model
2 model organisation database needs
3 explain the process of database design
4 design and develop databases from business organisation needs
5 identify and design the essential elements of testing strategies needed to test and prove the functionality of a database
6 create, write and execute SQL queries

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

  1. discuss the database model
    • GA4:
  2. model organisation database needs
    • GA1:
    • GA4:
  3. explain the process of database design
    • GA1:
    • GA4:
  4. design and develop databases from business organisation needs
    • GA1:
    • GA2:
    • GA4:
  5. identify and design the essential elements of testing strategies needed to test and prove the functionality of a database
    • GA1:
    • GA2:
    • GA4:
  6. create, write and execute SQL queries
    • GA2:
    • GA4: