ICOP225 — Intro to Database & Design
This unit introduces students to the principles and concepts of data storage, modelling and management with an emphasis on 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 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.