CRUD

CRUD

1. Terms

   • Read
   • Update
   • Delete
   • Generate
   • Create
     • Data entry
     • Validation
     • Storage systems
   • Modify

2. History

   • Popularised by James Martin in his book How To Manage The database environment

3. SQL terms

   • Insert
   • Select
   • Update
   • Delete

4. About

   • User persona
     • Name
     • Education
     • Goals
     • Occupation
     • Needs and expectations
     • Frustrations
     • Summary

5. Criteria

   • Prescribed
     • 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
   • Self determined
     • Develop a cancel and confirm system for the delete function of the CRUD flask app

6. Other variations

   • BREAD
   • DAVE
   • CRAP
   • CRUDL
   • ABCD

7. Changes I will make

   • Make the website red, blue white and black
   • Make a column that says price
   • Make buttons bigger and easier to click
   • Add cancel and confirm buttons after delete is pressed

8. Sample data

   • Name
     • Bob
   • Email
     • Bob@bob.com.au
   • Purchase amount
     • $24