CST363 Module 3

 

  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.  If the key has multiple columns, then "whole key" means  all columns together and not some of the columns.  Explain in your words what 3rd normal form is and why it is important.
    
The 3rd normal form generally defines that tables should have a single 'key' that determines the rest of the non-key data -- there shouldn't be any partial dependencies in the table where two different keys determine multiple sets of data. 3rd normal form is important because it helps reduce data redundancy and it improves data integrity on top of making tables easier to create, maintain, and access.

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

SQL views are virtual tables that instead of holding data like a regular table, it keeps track of select statements that access data from pre-existing tables. Views can be created from either a single table or from a combination of multiple. Views are similar to tables as queries can be used to grab data from them but they are different in the way listed above where they don't actually store any of their own data, and that they cannot be updated after creation.

Comments

Post a Comment

Popular posts from this blog

CST489 / 499 Week 10

  5pt: What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall. This week I was able to complete the objects for our applications logs. 5pt: What is your plan for next week? I plan to finish the controllers to add, remove, update, and view these logs. I will also look into tackling a systems test for logging in. 5pt: What challenges, if any, are you currently facing in project development? Do you need instructor assistance? We aren't facing any extra challenges.
Read more

CST489 / CST499 Week 12

  5pt: What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall. We have the front end completely secured due to needing to have it ready for a public facing domain. Our user pages are also making headway into a final stage. 5pt: What is your plan for next week? We plan to continue work on the front end for our user pages while also getting our application running on AWS in some form. 5pt: What challenges, if any, are you currently facing in project development? Do you need instructor assistance? N/A
Read more

CST489 / 499 Week 16

  For this week, please spend time browsing through your two years of journals and reflect on your overall experience and growth in the program. Some thoughts on future plans would be great, also.   This program has been an interesting two years, we've gone over so much material and yet I know I have so much more to learn just due to the nature of this field. I hope to continue to grow as I have these past 2 years and into a position where I can leverage my new skills.
Read more