Assessment

Assessment

1. Prescribed criteria

   • You must be able to CREATE, READ, UPDATE and DELETE records from your database
   • Your results must be displayed in a Flask Web Application
   • You must have a minimum of 5 records in your CRUD application
   • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements

2. Self-determined criteria

   • Modern UI

3. CRUD

   • Create
   • Read
   • Update
   • Delete

4. Changes I will make

   • Enhnace UI
   • Delete ID column
   • Add last name column
   • Add a way to get home from the read records section

5. Sample data

   • I have no clue what this means YET :(

6. Create table

   • SQL
     • First name
     • Last name
     • Email
     • CREATE TABLE records ( name TEXT NOT NULL, lastname TEXT NOT NULL, email TEXT NOT NULL, PRIMARY KEY (name, lastname) );

7. HTML/CSS

   • Font styles
   • Buttons
   • Colours
   • Text field