Digital Solutions

Unit 2: Application and data solutions


Topics:
Topic 1: Data-driven problems and solution requirements
Topic 2: Data and programming techniques
Topic 3: Prototype data solutions
TLAPS:
This TLAPS is under constant reviewUnit 2 TLAPS | pdf | docx | rtf

Coursework by week:
weekcourseworkchallenges
1 Complete using SQLite:
Reasons to use SQLite
SQLite Installation
SELECT FROM
WHERE
AND OR NOT
>, < & LIKE
ORDERING
DISTINCT & IN
LIMITS
Complete the exercises at the bottom of each page for each skill.
2 Complete using SQLite:
SUM & AVG
MIN & MAX
COUNT & ALIAS
GROUP BY & HAVING
ARITHMETIC OPERATIONS
SUBQUERIES
Complete the exercises at the bottom of each page for each skill.
3 Complete using Python console:
Connecting to SQLite
Displaying data
Interacting with data
Inserting records
Creating, updating & deleting
Recreate each skill learnt this week on Alchemy database (download from SQLite homepage)
4 Complete using Python & Flask:
Flask and SQLite: Skills
Ensure you understand:
• fetchone() vs fetchall()
• execute() vs executemany()
• commit() vs rollback() vs close()
• column[index] (default) vs column["field"] through db.row_factory = sqlite3.Row
All examples use a pizza orders context. Enhance both the interface & functionality for this context.
5 Practise using Python & Flask:
Flask and SQLite: Examples
Potential improvements:
• Authenticator - signup, session, manage users
• Blog - complete rework
• Self-determined analysis & improvements
Practise enhancing the functionality and UX as described using learnt techniques.
6 CSV to SQLite extension
Data Flow Diagrams
Create data flow diagram for:
• school
• your part-time employment
7 table JOIN table
Normalization
Foreign keys (practise by adding to past info sys)
Case study: High score tables.
Investigate Console Trader high score table

Utilise Python / Flask / JavaScript / SQLite to generate a chance game that integrates high score table.
8-10 Start FA2 Project - digital solution.

Week 10 first checkpoint, submit:
  • exploration of solutions
  • identification of algorithms
  • data flow diagram
  • user interface sketches
 
11-13 Week 13 (T3 W8) draft due  
14-15 Week 15 (T3 W10) final submission  
Assessment:
FA2 Project - digital solution | pdf | docx | rtf

lfs.zip set up to be used with Python / Flask / Jinja2 / HTML+CSS+JS

FA2_digital_solution_scaffold.docx ... there is also a video that accompanies this