This repo is a clone of https://github.com/miguelgrinberg/flasky
- Run the project and make a screenshot.
- Fill in your First name and your UofT email address, click submit (make a screenshot)
- Fill in your First name and Last name in the 1st field, and fill in your first name in the 2nd field, click submit. You will receive an error message (make a screenshot)
- Fill in your First name and Last name in the 1st field, and fill in your NON UofT email in the 2nd field, click submit. (make a screenshot)
SQL databases store data in tables that have fixed number of columns and variable number of rows. Each row has an unique ID called a primary key. Each row can also store foreign keys, which are primary keys for the role in another table. This allows multiple tables to be joined, and allows for updates in 1 table to propagate to another.
NoSQL databases do not support the storage of foreign keys. Instead, repeating data will be duplicated instead of linked. This allows for faster querying. Most NoSQL databases do not support joins, so if joins are needed, the functionality must be implemented by whichever application that needs to join data.