CST 363 Weekly Journal #3

1. Someone described the normalization rule as  "a non-key column depends on the key, the whole key, and nothing but the key, so help me Codd."  Key refers to a primary or other candidate key of a table.  If the key has multiple columns, then "whole key" means all columns together and not just some part of the key.  Explain in your words what 3rd normal form is and why it is important.

- The 3rd normal form is a type of structure so the database can make sure of the removal of any dependencies within a table. For example, it is important for a non-key attribute in a table must depend only on the primary key and can't depend on other non-key attributes. Furthermore, non-key attributes must depend on the primary keys.

2. What is an SQL view.  How is it similar to a table? In what ways is it different?

-An SQL view is a virtual table created from the result of a stored query. It is just like a regular table, however it cannot store data by itself.