Monash

Semester 1, 2016


FIT1004 - Data Management - Revision Notes

19 pages

2,716 words

$29.00

1

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