DigiTech Assignment Year 9 Term 4

DigiTech Assignment Year 9 Term 4

1. Prescribed Criteria

   • To be able to Create, read, update and delete from the website
   • To be able to read the results in a Flask web application
   • To have a minimum of 5 records in the CRUD Application
   • To decorate the CRUD Application in CSS aligning with the user persona

2. Self Determined Criteria

   • Ideas
     • Add more records
       • Way too simple, making names for each of the destroyed worlds would take too long
     • Make everything in comic sans
       • Already done before, not challenging enough, and it doesn't fit the user persona
     • Make a new webpage to the website
       • Not challenging enough, no idea what to put into the webpage
   • Chosen
     • To add a video of each of the worlds Mittens the Destroyer has destroyed in the table of records

3. Sample Data

   • Record 1
     • Hd 189733b
     • 68% Destroyed
     • 0 Survivors
     • 1.gif
   • Record 2
     • Wasp-12b
     • 73% Destroyed
     • 0 Survivors
     • 2.gif
   • Record 3
     • 55 Cancri E
     • 99 Survivors
     • 73% Destroyed
     • 3.gif
   • Record 4
     • TrES-2b
     • 79% Destryoed
     • 13 Survivors
     • 5.gif
   • Record 5
     • KELT-9b
     • 60% Destroyed
     • 23 Survivors
     • 5.gif

4. Changes you will make

   • Adding a new column to the SQL database consisting of a gif of each individual world being destroyed
     • Make a new individual column
     • Download each GIF and figure out a way to put it into the table why keeping the information in the SQL Database
   • Using CSS to decorate the website aligning with the user persona
     • Use Orbitron font throughout the page (Futuristic themed font)
     • Put cosmic themed background images in the CRUD Application
   • Adjusting the SQL database to align with the user persona
     • Change the columns from 'Name' and 'Email' to other, more suitable column names
     • To make an entirely new SQL database, in order to reset the autoincrementation
   • Adding different records into the database, to align with the user persona
     • Naming each of the universes destroyed
     • Percentage of universe destroyed
     • Amount of survivors
     • GIF of the world being destroed

5. CRUD

   • Create
     • Creates a record in the SQL database
   • Read
     • Allows the user to read the SQL database records
   • Update
     • Updates the SQL records, without need for deleting it and recreating it
   • Delete
     • Deletes the SQL record, leaving no trace of it