[H1] Database Systems Complete Notes

Description

This notes contains all lecture and tutorial topics from week 1 to week 12. It is a full summary of the course, with examples illustrated. Topics include: * Database introduction * Conceptual design * ER modelling, relationship explanation * SQL with a lot of practice questions and explanation * Logical design * Physical design, with numerous diagrams illustrated * Enhanced ER modelling * Transactions * Normalisations, different NF * Data Warehousing * Relational Algebra such as projection, difference, union, cartesian product * Database Administrtation * Query Optimization, including indexing, cost calculation, joining * NoSQL and star diagram * Ethical issues I used this note to achieve H1 in the subject and it is definitely useful for exam preparation. DB course structure doesn't change a lot in recent years so this ought to be a good reference book :)