There are multiple ways of "solving" this lab which you can tailor to your interests a bit. Select only one of the options.
Apply normalization based on critique and feedback. Try to ensure that your data is not duplicated if queried and is logical when joining information across tables.
There are 4 options for how to submit evidence of this lab.
Identify “normal forms” of data in your database. Look for 2 different N levels in your data and explain them. Write up the difference between these two normalized forms and why they make sense for your data model. (written portion)
Do a screencast pointing to these forms, explaining which form each is. Do an ALTER / add a table to change the “normal form” of data that you identify as needing cleaned up.
Article to read to learn more about normal forms and ALTER statements
Research SQL injection approaches. Find three common methods of attack and write up ways of mitigating these in application design. (written portion)
Try your hand at modifying the provided scripts (see links on website) in order to “wire up” a form to your back end and point to things to watch for in SQL Injection
Do a screencast walking through injection attempts and demonstrating a potential one with the script provided
Create a flowchart of how a web application connects from the user input, to front end code, to server handling data, to querying database, and end with returning a response. (written portion)
Try your hand at modifying the provided scripts (see links on website) in order to “wire up” a form to your back end to visualize two tables and do an insert of new data
Do a screencast explaining the diagram, then showing code in action
Create a mini application in the framework of your choosing that renders data from a back end and interfaces with a database system in some way. Write up your experience making a hello-world with that framework (written portion)
Do a screencast pointing out the relationship between front end and back end code. Also provide your experience working with this framework.
Create a blog post, embed your screencast at bottom
In post mention the option you selected
Submit link to post in #lab5-sql-to-web channel on Slack
This is due by Sunday at 11:59pm
Accurately conveys the concept in the written form based on the option selected (4pts)
Demonstration of technique in video form that option makes sense when visualized (4pts)
Evaluation is contextual based on which option you pick.
If it said show 2 normalized forms, show them.
If modifying code, ask for help as necessary