Introduction to Database Design and Management - ISYS114
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 nomalisation techniques, and implementing and utlising 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: | S2 Day - Session 2, North Ryde, Day S2 Evening - Session 2, North Ryde, Evening |
| Staff Contact(s): | Computing staff |
| Prerequisites: |
|
| Corequisites: | |
| NCCW(s): | COMP114, COMP124, COMP154, ISYS154 |
| Unit Designation(s): | |
| Unit Type: | |
| Assessed As: | Graded |
| Offered By: | Department of Computing Faculty of Science and Engineering |
Course structures, including unit offerings, are subject to change.
Need help? Ask us.