CST363.3 Module 3

What is 3rd Normal form and why its Important:

3rd Normal form is used in databases in order to improve data integrity, and remove redundancy by making any non-key col values depend solely on primary keys of the tables. They also minimize any errors or issues that may come up through inserting, updating or deleting data from a table.

What is an SQL view:

A view is a virtual table, which can be called upon through querying with its provided variable table name. It is similar to a table in that you can call upon it through querying, however any update of the data either to the direct table or the view table will have persistence issues in that the view will not be able to automatically pull the updated table and vice-versa.