CST 363 Week 3

 

WELCOME TO WEEK 3

Learning Journal: 

1. Someone described 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 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. 

- 3rd normal form is a way or organizing data in the database that avoids repeating information. There are two rules that are important: each piece of data should be stored in one place, and the information that does not relate to the main data should be separated. 

- It is important because it prevents mistakes in the data and makes the database more efficient. It is also easier to do changes on the database if it is needed. 

2. What is an SQL View? 

- An SQL view is a virtual table that provides a specific view of the data. For instance, admin can see information that user can't. It also provides control access to sensitive information within the database. It is also important to note that there are no changes to the underlying database design.