Database Analysis and Design
Duration: 1 Teaching Period
Unit Code: INF10002
Contact Hours: Recommended 10 hours of study per week
About this unit
Digital data is central to the modern economy. Transactions, managerial decisions and strategy development rely on data. Databases are the tool used to create, store, organise and disseminate data. This unit delivers the fundamental principles needed to effectively design and use databases. It seeks to unpack the notion of data, and introduce contemporary tools and techniques for storing, retrieving, exploiting and visualising data. Emphasis is given to understanding data modelling and design approaches, and the emerging opportunities afforded by big data, social media, data analytics and unstructured data. Both commercial and open-source database management tools are focused upon.
Content
- Database relations, tables, records, keys, filters, queries, parameters, forms, indexes
- Data formats, manipulation, and exchange tools
- Transactions and ACID
- Entity-relationship diagrams and modelling
- SQL
- Data warehousing, big data and data normalisation
- Data analytics, business intelligence, visualisations and functions
- Semi-structured and unstructured data storage
- Applications and examples of data and databases in organisations
View further information on this unit.