Database Project

Assessment

You are going to make a simple database application using Python and SQL in Visual Studio Code over four weeks. You will be using github for version control and to show incremental development.

This application can be your own design or a design can be given to you by your teacher. Please note that databases should NOT be more than 3 tables. A single table is acceptable as long as the design is correct and you may have to compromise to ensure the database does not become too complex.

Please ensure you have a sound grasp of SQL and Python before attempting this assessment. You must have completed all the relevant coursework before beginning this assessment as your teacher is NOT allowed to give you significant help beyond basic feedback during the assessment period. 

All the information you will need is in the task shown below. This is also going to be where you will record your progress and testing.  

The rest of this webpage supports the completion of your assessment.

Complete the "Before Development" Section of your development log.

This is a simple definition of what you are making and who you are making it for. It includes a simple set of requirements (what it needs to do) and specifications (how exactly it is going to do that). 

Refer back to the sections on Database Learning for making your ERD and remember to keep it simple!

Here is some tips for getting started with development. Following a good process will help you immensly going forward and hopefully you'll be able to create something that you can be proud of.

Steps:

1. Create an empty folder for all your code and open it up in VSCode

2. Publish the empty folder to github!

3. Create your database using sqlite studio inside this folder and add some sample data to it

4. Begin writing the Python code to interface with the data, one part/function at a time 

5. Test! 

   • Test the sql queries in sqlite studio

   • Test the function or code block in Python with different inputs

   • Record the testing in your Development Log

   • Commit to github with a descriptive commit

6. Refine your application based on your testing (ie add more functions, fix or extent broken ones, add more data etc)

7. Repeat steps 4 to 7 until you run out of time.

When time is running out (as decided by your teacher) make sure you have completed the testing tables and your github repository is up to date with your local copy.

You may wish to look through the marking schedule shown at the end of the Development Log to ensure you have not missed anything obvious (like code comments) then hand in your application for assessment against AS92004: Create a computer program

Congratulations, your well on your way to being a computer programmer!