Happiness can be found even in the darkest of times, if one only remembers to turn on the light.
Dumbledore
This week has been stressful, I’ve been really behind on life, school and work. Hopefully this week I can get caught up and ahead.
- Someone described normalization of a DB design as “a column depends on the key, the whole key, and nothing but the key, so help me Codd.” Explain in your words what 3rd normal form is and why it is important.
A table is only in 3rd normal form when all the table data relates to the primary key. It’s important because it maintains data integrity.
2. If an index will speed up data retrieval, why is it not a good idea to index every column?
It is not a good idea to index every column because it is costly to update/delete/insert data that is indexed.
3. What is an SQL view and why is it useful ?
A view is the result of a SQL query that is saved so that it can be accessed again easily.
That’s all for now. Will post more next week!
jeanniecodes 