CRUD application

CRUD application

1. CRUD functionality

   • Create
     • Delete
       • Delete existing record
         • Use to remove a user account
     • Create a new record
       • Added to SQL database
   • Read
     • Update
       • Change existing record
     • Read and retrieve all records
       • Creates a connection to the SQL database
         • Display data in table
   • Basic operations that can be performed on consistent data
     • Essential in any application that needs to manage date
   • SQL table
     • Thonny code
       • Flask
         • HTML
       • Connect to SQL
     • Database
     • Records
       • Name
         • Email
           • Id
             • Autoincrement
   • 4 major operations

2. HTML

   • CSS
     • Internal
       • Inline
         • External
           • Link tag
         • Style tag within element tag
       • Style tag
     • Used to format HTML
       • Colour
         • HEX
           • RGB
             • RGBA
         • Background colour
           • Text colour
             • Border colour
             • Font family
             • Bold/emphasised text
             • Italics
           • Light colours
             • Easy to read
   • Home
     • Create
       • Update
         • Delete
           • Read
   • Templates
   • Head tag
     • Body tag
       • Li
         • Ul and ol
           • P
             • H1-H6
               • Title
   • Images
     • Background images
       • Static folder
         • Jpg
           • Png

3. Task

   • Prescribed criteria
     • Be able to create, read, delete and update
       • Results must be displayed in a flask web application
         • Thonny code
           • HTML
             • SQL
               • Database
                 • Create table statement
       • Minimum 5 records
         • Name, subject, grade
           • User persona
             • User goal
               • Needs and expectations
       • Apply CSS styling
         • Colour
           • Images
             • Layout
     • Requirements
       • Justification
         • Evaluation
           • User survey
   • Self-determined criteria
     • Web page layout
       • Clear and easy to read

4. Web development

   • Essential basic web operations
     • Real world CRUD applications
       • Contact management systems
         • Used to manage website content
           • CRUD operations used to add edit and delete content
       • E commerce
         • Uses CRUD to manage products, orders and customer data
       • Social media platforms
         • CRUD allows users to create, read, update and delete their profiles, post and comments
       • Inventory management systems
         • Uses CRUD to manage products, stock levels and sales data
       • Customer relationship management
         • CRUD manages customer data