INFO20003 Summary Notes

Description

These notes contain a summary of the critical concepts, a more in depth notes section which further elaborates on the dot pointed summary and includes examples as well as a glossary of important terms for each weeks content. The main topics covered are: - An Introduction to Database Systems - The Database Development Lifecycle - ER Modelling - Relational Modelling (Using MySQL Workbench) - Relational Algebra - SQL - Storage and Indexing' - Query Processing - Query Optimization - Normalisation - Transactions - Database Adminstration - Data Warehousing - Dsitributed Databases - NoSQL Databases