✔ Complete H1 Summary Notes ✔ INFO20003: Database Systems

Description

This note set covers the full subject of INFO20003 – Database Systems for the 2021 Semester 1 Curriculum, including all covered concepts. The content of these notes were derived from lecture notes, lecture recordings, workshop/tutorial content and examples. These notes include: - Easy to read code and clear examples in correct SQL syntax and font of all concepts - Multiple diagrams, tables and highlighted equations that are all clearly set out - Comprehensible diagrams and examples for concepts - Summary tables that compare concepts taught, including advantages and disadvantages - Clear separation and format of concepts into topics and sections - A hyperlinked bookmarked table of contents where you can easily navigate throughout the document if opened with a PDF reader software The main topics covered include (but are not limited to): - Database Modelling (development lifecycle, ER models etc.) - Relational Algebra and SQL including DML, DDL and DCL Commands - Storage, Indexing and Query Processing including necessary formulas - Normalisation and transactions - Database Admin and NoSQL (backup, dimensional modelling, distributed databases etc.) These notes helped me obtain an H1 in INFO20003: Database Systems. They are perfect for both cramming and continuous study throughout the subject. The topics are covered in mostly the same order as they are covered in lectures, and is succinct and compact. All information included is relevant and important for the exam.