Introduction to Database Design and Management - ISYS114
This unit introduces students to the principles and concepts of data storage, modelling and management with an emphasis on 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 such as ER Modelling and query languages such as Structured Query Language (SQL) will be used. Concepts relating to data warehousing, governance, administration, security and privacy, ethical and green approaches to the collection, backup, use and storage of data and the construction of systems are also discussed. Overall, this 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.