Record database

Record database

1. Self Determined Criteria

   • Create an easy to access and safe database for the purpose of storing employee records
     • Implementing CRUD
     • Error handling
       • Advisory with user inputs

2. Prescribed Criteria

   • CREATE, READ, UPDATE and DELETE records from database
     • Create function
     • Read function
     • Update function
     • Delete function
   • Results displayed in a Flask Web Application
     • Installment of Flask
     • Management of HTML forms with Flask
   • Minimum of 5 records in CRUD application
     • Document and store initial records
     • Display 5 records at all times
   • Apply CSS styling to the CRUD application that aligns with user persona’s requirements
     • User Persona
       • Business Owner
       • 27 years old

3. CRUD

   • Create
     • Add new records
   • Read
     • View records
   • Update
     • Edit records
     • Change data
   • Delete
     • Remove records from database

4. Changes

   • Employee Database
   • SQLite
     • New columns
       • Occupation
       • Age
       • Phone number
   • Python
     • New inputs sections
     • New exports from SQLite
   • CSS
     • User friendly design
     • Easy for navigation
   • HTML
     • Connection to Python

5. Sample Data

   • SQLite
     • Commands
       • Create table
         • CREATE TABLE ___ (
       • Save database
         • .save __.db
       • Data Type
         • CHAR
         • VARCHAR
         • INTEGER
       • PRIMARY KEY
   • Notepad++
     • HTML
       • Commands
         • Define text
           • <head>
           • <title>
           • <body>
           • <h1> to <h6>
           • <p>
         • Define document type
           • <!DOCTYPE>
             • <html>
         • Hyperlink
           • <a>
   • Python