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