Database Redesign

[Grimcheese]

The database used for storing of sensor readings is to be redesigned and re-implemented. The redesign will follow standard database design principals in order to allow for better use of the data and more flexibility for future changes.

Rough outline of process:

• Identify entities and their attributes
• Map relationships between entities
• Create preliminary database schema from Entity Relationship Diagram
• Ensure schema is normalised to 2NF
• Implement in MySQL

Following the redesign of the database the python and sql code will need to be updated to reflect the changes. This will include changes to the test data generator scripts and the Database python module. This will affect the API which will need to be updated along with documentation.

[Grimcheese]

Documentation updated with new database schema - able to implement in python now