Reading
- Database Normalization Explained in Simple English - ::: https://www.essentialsql.com/get-ready-to-learn-sql-database-normalization-explained-in-simple-english/
The forms are progressive, meaning that to qualify for 3rd normal form a table must first satisfy the rules for 2nd normal form, and 2nd normal form must adhere to those for 1st normal form. Before we discuss the various forms and rules in detail, let’s summarize the various forms:
- First Normal Form – The information is stored in a relational table with each column containing atomic values. There are no repeating groups of columns.
- first normal form
- Second Normal Form – The table is in first normal form and all the columns depend on the table’s primary key.
- second normal form
- Third Normal Form – the table is in second normal form and all of its columns are not transitively dependent on the primary key
- third normal form
-
- database normalization
Project Ideas
What ideas do you have for projects? What would your model be that you can control and update the view with? What API(s) could you use to make this a reality?
Take a look at this repo for inspiration about APIs you could use.
For those of you who were in 201, be sure to look back at the project discussion assignment from that course and see if there is anything from there that was not done that could be carried forward as an idea for this class.