{"id":179,"date":"2016-06-16T10:12:14","date_gmt":"2016-06-16T14:12:14","guid":{"rendered":"http:\/\/folvera.commons.gc.cuny.edu\/?p=179"},"modified":"2021-09-16T14:58:25","modified_gmt":"2021-09-16T18:58:25","slug":"database-administration-fundamentals-day-7-2","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=179","title":{"rendered":"Database Administration Fundamentals (WS16SQL1006) \u2013 Day 7"},"content":{"rendered":"<p>We had another quiz (#3) reviewing most of the material that we have covered in the past three and a half weeks. In the quiz, I offered you two options &#8212; creating a new database where you would put the three new tables (<a title=\"Class Notes for WS16SQL1006 - Day 7a (2016\/06\/15)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/06\/WS16SQL1006_20160615.pdf\">quiz #3a<\/a>) or creating a schema in the same database to include these new tables (<a title=\"Class Notes for WS16SQL1006 - Day 7b (2016\/06\/15)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/06\/WS16SQL1006_20160615b.pdf\">quiz #3b<\/a>). Most of you decided to create a new database.<\/p>\n<p>Download the XLS files to recreate databases\u00a0<a title=\"AP.xls\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/06\/AP.xls\">AP<\/a> and <a title=\"AP_Employees.xls\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/06\/AP_Employees.xls\">AP_Employees<\/a> (latter used in quiz #3) as well as the class notes for day 7 (<a title=\"Class Notes for WS16SQL1006 - Day 7a (2016\/06\/15)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/06\/WS16SQL1006_20160615.pdf\">quiz #3a<\/a> &amp; <a title=\"Class Notes for WS16SQL1006 - Day 7b (2016\/06\/15)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/06\/WS16SQL1006_20160615b.pdf\">quiz #3b<\/a>).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We had another quiz (#3) reviewing most of the material that we have covered in the past three and a half weeks. In the quiz, I offered you two options &#8212; creating a new database where you would put the three new tables (quiz #3a) or creating a schema in the same database to include [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[6,3,1,17,2],"tags":[],"class_list":["post-179","post","type-post","status-publish","format-standard","hentry","category-ws16sql1006","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=179"}],"version-history":[{"count":6,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":250,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions\/250"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}