CRUD Web Application

CRUD Web Application

1. Prescribed Criteria

   • You must be able to CREATE, READ, UPDATE and DELETE records from your database
     • The web application is connected to the database
     • The web pages must use Thonny to open
     • You can change the displayed information in the web application
   • Your results must be displayed in a Flask Web Application
     • Flask is installed in Thonny
     • The wed application must show all added information
     • Flask is used to build the web pages
   • You must have a minimum of 5 records in your CRUD application
     • All the columns in the table must be filled in
     • There are 6 different records for each user
     • There should be at least 5 client’s records in the table
   • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements
     • The background colours are changed in the web application
     • The fonts are changed in the web application
     • Images are added to the web pages

2. Self Determined Criteria

   • You must add multiple colours in the web application
     • The style of the colour must match the overall style in the web pages
     • At least 3 different colours (exclude different shades of a colour)
     • Add colourful images
   • You must include some kind of animation for the colours that were used in the web application
     • The animation should make the web pages more ‘fun’ to watch and use with
     • The colours are changing in the animation
     • At least two colour/movement animations.

3. CRUD

   • create
     • The function to create a new data in the web page.
   • read
     • The function to read and retrieve data from the web page.
   • update
     • The function to updata or change the stored data in the web page.
   • delete
     • The function to deleate the stored data in the web page.

4. Changes you will make

   • More columns in the table to store more data for each person.
     • A column to store the requirements of the designs
     • A column to store due date of the design
     • A column to state if the project/requirements is/are finished or not (complete/incomplete)
     • A column to store the phone number of the client
   • The colours of the web pages
     • Background
     • Colour of the words
     • Add images
   • Fonts that matches the style of the web page

5. Sample data

   • client's name, email, phone number, requirements, due date, complete/incomplete
     • Kimberley Jensen, kimberley561@email.com, 0456378492, change colour and texture of the leaflet's background, 2024/11/19, incomplete