Back to Find Units Page

Unit of Study ISY92115 - Data Management (2020)

Show me unit information for year

Unit Snapshot

  • Enrolment information

    N/A

Unit description

Provides students with an overall understanding of database concepts and theory. Students will learn the steps required to design and build databases and the key elements required to manage and maintain databases in an enterprise.

Unit content

Topic 1: Database Fundamentals

Topic 2: Using Databases and Scripts

Topic 3: Data Modelling and Database Design

Topic 4: Physical Database Design and Client-Server Databases

Topic 5: Database Administration and Security

Topic 6: Big Data and Database Warehousing

Availabilities

Location Domestic International
SCU Online
Study Period3,6
Study Period3,6

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 identify and explain the terminology of the relational database model
2 model business information requirements
3 understand the processes used to translate data models into a logical database design with normalised relations
4 identify and design the essential elements of testing strategies needed to test and prove the functionality of a database
5 describe the steps to develop a physical database design
6 explain the key managerial functions for effective administration of an enterprise’s databases
7 describe the key elements of an effective database and data security strategy.

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

  1. identify and explain the terminology of the relational database model
    • GA4:
  2. model business information requirements
    • GA1:
    • GA4:
    • GA6:
  3. understand the processes used to translate data models into a logical database design with normalised relations
    • GA1:
    • GA4:
  4. identify and design the essential elements of testing strategies needed to test and prove the functionality of a database
    • GA1:
    • GA4:
  5. describe the steps to develop a physical database design
    • GA1:
    • GA4:
  6. explain the key managerial functions for effective administration of an enterprise’s databases
    • GA1:
    • GA4:
    • GA6:
  7. describe the key elements of an effective database and data security strategy.
    • GA1:
    • GA4:

Prescribed learning resources

Prescribed Texts
  • No prescribed texts.

Prescribed Texts
  • No prescribed texts.

Prescribed Learning Resources may change in future Teaching Periods.