Availabilities:

Location Domestic International
SCU Online
Term2,5
N/A

Unit Summary

Unit type

PG Coursework Unit

Credit points

12

Unit aim

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. Furthermore, students will learn the importance of big data and security in database management.

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

Learning outcomes

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:
1 analyse and model business information requirements using the relational modelling technique.
2 apply database design principles, methods and tools to design, build and test the functionality of a database.
3 implement the key managerial functions for effective and secure administration of an enterprise’s databases.
4 articulate the importance of big data and big data analytics to business managers and other stakeholders.

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

  1. analyse and model business information requirements using the relational modelling technique.
  2. apply database design principles, methods and tools to design, build and test the functionality of a database.
  3. implement the key managerial functions for effective and secure administration of an enterprise’s databases.
  4. articulate the importance of big data and big data analytics to business managers and other stakeholders.

Prescribed texts

  • This text is available via the Co-op Bookshop and may be available second-hand: Kroenke, D & Auer, DA, 2015, Database Concepts , 7th edn (Global Edition), Pearson Higher Education, USA. ISBN: 9781292076232.

  • This text is available via the Co-op Bookshop and may be available second-hand: Kroenke, D & Auer, DA, 2015, Database Concepts , 7th edn (Global Edition), Pearson Higher Education, USA. ISBN: 9781292076232.
Prescribed texts may change in future teaching periods.