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.