Assessment

Assessment

1. CRUD

   • Create
     • The ability to create new records and add them to the system
   • Read
     • The ability to read data
   • Update
     • The ability to modify existing data
   • delete
     • the ability to delete existing data
   • real world applications
     • Social media
     • websites
     • Online stores
   • 4 essential operations for creating and manage a database

2. WEB development

3. Database knowledge

   • SQL
     • SQLite3
     • .open
     • .mode table
     • .schema
     • Data types
       • integer
       • VARCHER
       • date
       • Time
       • INT primary key
     • Create table
     • SELECT * FROM

4. HTML

   • Templates
   • <title>
   • <head>
   • <body>
   • <h1>
   • Ul

5. CSS

   • <style>
   • Color:
   • font-colour/size
   • text-shadow
   • Margin
   • Text-decoration
   • Background-color
   • Li {

6. Python

   • Flask
   • Import SQLite3
   • Conn
   • @app. Route
   • Def

7. coding environment

   • thonny
     • Colour coded
     • testing zone
     • developing zone
     • Python
   • SQLite3
     • Notes
     • tables
       • Column
       • records
       • databases
       • SQL/sequel

8. task

   • Scaffold
     • evaluation
     • Modification
     • User survey
     • screen captures
     • Code used
     • algorithm
     • User persona
       • Easy, organised, neat
       • CRUD
       • Organise passowords and usernames
       • visually appealing
       • fustrations
         • forgetting passwords and usernames
         • too many different accounts
   • Self-determined criteria
     • Easy to read, and neatly formatted
       • Headings are simple and precise
       • Simple easy to read font
       • Data should have colours that are easy to read
       • Easy to tell what the function of every button is
   • Prescribed criteria
     • You must be able to CREATE, READ, UPDATE and DELETE records from your database
       • Must have a webpage for read, update, create
       • Must have create button
       • Must use have read button
       • Must have update and delete button
     • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements
       • Use font colours and borders
       • Should have different colours
       • Should have background colours
       • Colours must match user requirement (pastel colours)
       • Colours palette should be consistent
     • Your results must be displayed in a Flask Web Application
       • Must connect thonny to webpage
       • Must have templates folder with web pages
       • Data will not be shown after when data is deleted
       • Edited data will show accurately on the read page
     • You must have a minimum of 5 records in your CRUD application
       • All 5 records will be different and show different accounts
       • Records will have information under all categories
       • Must have at least 5 records in read page
       • Must have at least 5 records in SQL database
       • Records will be correctly formatted