FIA3 - Data Exchange

Data Structure

Data Specifications

Data Interface

Input Requirements

Output Requirements

Fields

Integers

Floats

Strings

Small Unit Installation Postcode

SGU Rated Output In kW Total

Return of User's Query

User Authentication Data

Solar Information

Solar Information

Required Datastructures

Relational Database

Required Dataset

File Formats

SQL

CSV

User Credentials

Solar Information

Data Sanitisation

Cleaning

Restructuring

Filtering

Normalisation

SQL

Encryption / SQL Injection

Requirements

Prescribed Requirements

Self-Determined Requirements

Allow for the editing of multiple fields by Administrators at once

Ensure SQL Injection isn’t possible through filters

Allow implementation for external identity providers

Allow an Administrator to update the database: view, search, add update, and delete records

Restrict Login Attempts to 3

Data to be imported into the database from pre-existing CSV documents

Database to be named accordingly: i.e as provided: CER.db

Allow Students to filter the database on:

Anyone postcode/suburb

Any single Year or Data Range

Installation, and or Output (Kwh)

Data Exchange Methods

Python API

Components of Data Exchange Systems

Frontend and Backend Interaction

Sending and Requesting Data

Elements of Data Exchange Security

SQL Injection Mitigation