FIT1004 - Data Management - Revision Notes

Description

Summary of unit FIT1004. Examples of syntax and syntax templates to help students understand the content. Topics covered: - Introduction to Data Management - Relational Model - SQL Data Definition - SQL Query 1 - single and multiple tables retrieval - SQL Query 2 - aggregate function and group by clause - SQL Query 3 - subquery and Oracle function - Database Design 1 - Design Process and Conceptual Modeling - Database Design 2 - Logical Modelling - Database Design 3 - Normalisation - P1/SQL Triggers - Transaction Management and Database Maintenance - Current trends in database management