Term 4 Assignment

Term 4 Assignment

1. Prescribed Critera

   • 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 o E.g. A font or background colour

2. User Persona

   • About
     • Jordan
     • 17
     • High School
     • London, UK
   • Goals
     • Trying to find the best American Music as he only listens to UK music currently.
     • Interested to learn more
   • Needs
     • Wants a clean minimalistic UI so he can easily access the top US music tracks
   • Frustations
     • There are currently no minimalistic websites with easy to access data

3. CRUD

   • Create
     • Create Records about music
   • Read
     • Read Music Databse
   • Update
     • Update records each month
   • Delete
     • Delete records not needed

4. Self-Determined Critera

   • Make a clean minimalistic UI while still having elements of CSS styling in it

5. Changes made

   • Neutral Colour tones in the background and text
   • Add informative text boxes around website
   • Change database headings
   • Make a Create, Read, Update and Delete function

6. Programs Used

   • Notepad
   • Thonny
   • SQLite 3

7. Sample Data

   • Song Name
     • My Eyes
   • Artist
     • Travis Scott
   • Album
     • Utopia
   • Streams
     • 542 000 000
   • Year Released
     • 2023

8. Application Pages

   • Home Page
   • Create Page
   • Read Page
   • Update Page