CITS1402 Summary Final Exam Cheat Sheet Complete Notes

Description

This is a cheat sheet made for the final examination of CITS1402. A4 two pages back-to-back. I used this and it helped me a lot during the exam, and I hope it helps you too! It covers: Week 2: Video 05, 06, 07: RDBMS, Normalization, JOIN Week 3: Video 08, 09, 10: DDL, SELECT, Types Week 4: Video 11, 12, 13: Operators, Relational Algebra, Summary Functions Week 5: Video 14, 15, 16: GROUP BY, ERD I, HAVING Week 6: Video 17, 18, 19: Subqueries, ERD II, Subqueries II Week 7: Video 20, 21, 22: Relational Algebra II, Functional dependencies, NULL Week 8: Video 23, 24, 25: Data Integrity, Entity-Relationship Diagrams III, Data Manipulation Language Week 9: Video 27, 28, 29: Views, Views II, Triggers Week 10: Video 30, 31: Indexes, Relationships Week 11: Video 32, 33: Functional Dependencies II, Boyce-Codd Normal Form Week 12: Video 34, 35: Transactions, Mongo DB