Skip to Content

Introduction to Database Design and Management - WISY114

This unit introduces students to the principles and concepts of data storage, management and modelling, including the role of data and information in organisations. The unit will cover conceptual modelling techniques, converting conceptual data models into relational data models and verifying its structural characteristics with normalisation techniques, and implementing and utilising a relational database using a database-management system. Fundamental data modelling tools, techniques and query languages such as Structured Query Language (SQL) will be used. Ethical and green approaches to the collection, backup, use and storage of data and the construction of systems are emphasised. An introduction to the concepts and issues relating to data warehousing, governance, administration, security and privacy and alternative database structures such as distributed and object oriented databases will be provided. The unit concentrates upon building a firm foundation in information representation, organisation and storage with particular emphasis upon the application of database systems.

Credit Points: 3
When Offered:

MUIC Term 1 - Macquarie University International College, North Ryde

MUIC Term 2 - Macquarie University International College, North Ryde

MUIC Term 4 - Macquarie University International College, North Ryde

MUIC Term 5 - Macquarie University International College, North Ryde

Staff Contact(s): Ms Kimberley Duncan
Prerequisites:

 

Corequisites:

NCCW(s): ISYS114, COMP114, COMP124, COMP154, ISYS154
Unit Designation(s):
Unit Type: DiplomaMUIC unit
Assessed As: Graded
Offered By:

Macquarie University International College

Course structures, including unit offerings, are subject to change.
Need help? Ask us.