CRUD Application

CRUD Application

1. Prescribed Criteria

   • You must be able to CREATE, READ, UPDATE and DELETE records from your database
     • You must be able to create and add records to your database
     • You must be able to read records from your database
     • You must be able to update records from your database
     • You must be able to delete records from your database
     • You must create a database
   • Your results must be displayed in a Flask Web Application
     • Flask Web Application must lead user to the home page
     • User must be able to click a hyperlink to the home page
     • Update, delete and create buttons must be clearly displayed on the web pages
   • You must have a minimum of 5 records in your CRUD application
     • You must have a CRUD application
     • You must store records in your CRUD application
     • You must store at minimum 5 records
     • Records are to be store in SQLite3
     • Records will be displayed
   • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements
     • Layouts, colours, display, styling and more is to be used through the use of CSS
     • The CSS styling must align with your user persona’s requirements
     • CSS styling must be applied to your CRUD application
     • The Flask Web Application must be able to connect the web pages together

2. Self-Determined Criteria

   • The title of the home page must be labelled ‘Rudra Tiwari’s Subscriber Page’ in bold
     • A home page must be created
     • A title on the home page must be created
     • The title of the home page must be labelled
     • The title of the home page must display ‘Rudra Tiwari’s Subscriber Page’
     • The title of the home page must be in bold

3. Changes

   • HTML
     • Using different text sizes, styles, and fonts that relate the the theme of the user persona
   • CSS
     • Change background colours, layouts, text colours and more
   • SQL
     • None
   • Python
     • None

4. CRUD

   • Create
     • Adds new data and records to a database
   • Read
     • Function to view and read records/data from a database
   • Update
     • A function to edit records/data from a database
   • Delete
     • A function to remove records/data from a database

5. Sample Data

   • Name
   • Email
   • ID