INF10002 Database Analysis and Design Report

Introduction

This report summarises what I learnt in INF10002 Database Analysis and Design. It includes a self-assessment against the criteria described in the unit outline, a justification of the pieces included, details of the coverage of the unit’s intended learning outcomes, and a reflection on my learning.

Coverage of the Intended Learning Outcomes

This section outlines how the pieces I have included demonstrate the depth of my understanding in relation to each of the unit’s intended learning outcomes.

Reflections on Access and PowerBI

ILO 1:

Define and explain fundamental data and database concepts including tables, relations, keys, queries, transactions, and structured, semi-structured, unstructured data

The following pieces demonstrate my ability in relation to this ILO:

• Task 1,2 demonstrate ….
• Test 1: questions … demonstrate …
• …

ILO 2:

Create, store, retrieve, exploit, and visualise data using modern database tools, functions, and techniques

• Task 1,2 demonstrate ….
• Test 1: questions … demonstrate …
• …

ILO 3:

Understand and apply conventional data modelling techniques to solve practical database design problems.…

• Task 1,2 demonstrate ….
• Test 1: questions … demonstrate …
• …

 Reflections on SQL and ERDs

ILO 1:

Define and explain fundamental data and database concepts including tables, relations, keys, queries, transactions, and structured, semi-structured, unstructured data

ILO 2:

Create, store, retrieve, exploit, and visualise data using modern database tools, functions, and techniques

• Task 3,4 demonstrate ….
• Test 2: questions … demonstrate …

ILO 3:

Understand and apply conventional data modelling techniques to solve practical database design problems.…

• Task 3,4 demonstrate ….
• Test 2: questions … demonstrate …

Normalisations, Transactions, JSON

ILO 4:

Explain the impact of big data and modern data analytics tools in the design, use, and management of database systems. …

• Task 4,5 demonstrate ….