Database Development

Database Development

1. Task

   • Scaffolding Document
     • Prescribed Criteria
       • 1
         • Description
           • You must use 4 different data types in your table
       • 2
         • Description
           • You must have 1 column that uses Hashing to securely store that information
       • 3
         • Description
           • You must have 1 column that uses Caesar Cipher to store secret information
       • 4
         • Description
           • Your database must have at least 20 records
     • Self-Determined Criteria
       • Description
     • Mind Map
       • Description
         • Create a mind map showing your ideas – Refer to Qlearn for template
     • User Persona
       • Description
         • In a target audience analysis, we look at a group of people that might suit a product/service. E.g. 18 to 45 year olds, like gaming, have a high amount of disposable income. To then form a User Persona, we take/create an individual out of that wider audience and focus specifically on them and try and solve a problem they are experiencing.
     • Data Dictionary
       • Description
         • Develop a data dictionary that includes all columns required, data types and data length
     • SQL and Code used
       • Description
         • Symbolise the SQL and Code used in your project include code comments and annotations
     • Algorithm for Caesar Cipher
       • Description
         • Develop an Algorithm for the Caesar Cipher
     • Desk Check
       • Description
         • Desk check your algorithm to ensure accuracy and reliability
     • User Survey
       • Description
         • Create a user survey, you need to turn your Prescribed Criteria and Requirements into questions to ask two other people to see if you have met the user problem.
     • Evaluation
       • Description
         • Evaluate components and solution against the prescribed and self-determined criteria. Use the evaluation template below.
     • References
       • Description
         • Acknowledge all sources and the references must follow the format in the Mansfield Citation Guide. Acknowledged all sources with citations.
   • Create a database.
     • Securely store data
       • Caesar Cipher
       • Hashing

2. Softwares Used

   • SQLite3
     • Description
       • SQLite3 is used to create and manage databases for reasons such as securing private/sensitive information
     • Programming Language
       • C/C++
   • Thonny
     • Description
       • Thonny is a free, open-source application for Python designed specifically for beginners
     • Programming Language
       • Python