{"id":109,"date":"2021-05-19T04:53:23","date_gmt":"2021-05-19T04:53:23","guid":{"rendered":"http:\/\/jonathanlimpus.com\/wordpress\/?p=109"},"modified":"2021-05-19T04:53:24","modified_gmt":"2021-05-19T04:53:24","slug":"cst-363-week-3-learning-journal","status":"publish","type":"post","link":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/2021\/05\/19\/cst-363-week-3-learning-journal\/","title":{"rendered":"CST 363 &#8211; Week 3 Learning Journal"},"content":{"rendered":"\n<h4><em>Someone described normalization of a DB design as &#8220;a column depends on the key, the whole key, and nothing but the key, so help me Codd.&#8221; Explain in your words what 3rd normal form is and why it is important.<\/em><\/h4>\n\n\n\n<p>The third normal form is a design pattern. It gives the guideline that databases&#8217; columns should rely on a key. This means that every part of the database should have some logical relation to the primary key. This is important as it helps databases stay organized and use less memory.<\/p>\n\n\n\n<h4><em>What is an SQL view and why is it useful?<\/em><\/h4>\n\n\n\n<p>An SQL view is a kind of &#8216;virtual table&#8217; in which you can create a kind of database within a query. These views can be used to add or remove data from a &#8216;real&#8217; table in order to perform specific operations on a table. A specific use for a view would be to remove a Social Security Number from a table for somebody to work with in order to protect sensitive data.<br> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Someone described normalization of a DB design as &#8220;a column depends on the key, the whole key, and nothing but the key, so help me Codd.&#8221; Explain in your words what 3rd normal form is and why it is important. The third normal form is a design pattern. It gives the guideline that databases&#8217; columns &#8230; <a title=\"CST 363 &#8211; Week 3 Learning Journal\" class=\"read-more\" href=\"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/2021\/05\/19\/cst-363-week-3-learning-journal\/\" aria-label=\"More on CST 363 &#8211; Week 3 Learning Journal\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,7],"tags":[],"_links":{"self":[{"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/109"}],"collection":[{"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":1,"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":110,"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/109\/revisions\/110"}],"wp:attachment":[{"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jonathanlimpus.com\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}