https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?action=history&feed=atom&title=Week_6 Week 6 - Revision history 2026-04-04T10:28:37Z Revision history for this page on the wiki MediaWiki 1.20.3 https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?title=Week_6&diff=2134&oldid=prev Dondi: Finally! 2013-09-26T05:30:20Z <p>Finally!</p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 05:30, 26 September 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">{{Under Construction}}</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#039;&#039;&#039;This journal entry is due on Friday, October 4, at midnight PDT.&#039;&#039;&#039; &#039;&#039;(Thursday night/Friday morning)&#039;&#039;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#039;&#039;&#039;This journal entry is due on Friday, October 4, at midnight PDT.&#039;&#039;&#039; &#039;&#039;(Thursday night/Friday morning)&#039;&#039;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> </table> Dondi https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?title=Week_6&diff=2133&oldid=prev Dondi: /* Movies from Text File to Tables */ Small wording clarification. 2013-09-26T05:29:57Z <p>‎<span dir="auto"><span class="autocomment">Movies from Text File to Tables: </span> Small wording clarification.</span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 05:29, 26 September 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 37:</td> <td colspan="2" class="diff-lineno">Line 37:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>#* State your query in plain English (like the queries above).</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>#* State your query in plain English (like the queries above).</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>#* Provide the SQL query &quot;translation&quot; of your plain English query.</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>#* Provide the SQL query &quot;translation&quot; of your plain English query.</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>#* <del class="diffchange diffchange-inline">Copy/paste </del>the answer to your query, according to the sample movie database.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>#* <ins class="diffchange diffchange-inline">Supply </ins>the answer to your query, according to the sample movie database.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{{Shared Journal Instructions|week=6}}</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{{Shared Journal Instructions|week=6}}</div></td></tr> </table> Dondi https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?title=Week_6&diff=2132&oldid=prev Dondi: /* Movies from Text File to Tables */ Clarify “too long.” 2013-09-26T05:26:51Z <p>‎<span dir="auto"><span class="autocomment">Movies from Text File to Tables: </span> Clarify “too long.”</span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 05:26, 26 September 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 24:</td> <td colspan="2" class="diff-lineno">Line 24:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Follow the instructions in the [[PostgreSQL Tutorial]] to load up your own copy of the sample movie database.&#160; To get &quot;warmed up,&quot; complete the tutorial so that you get some query practice before working on the questions below.&#160; Note that the &#039;&#039;member&#039;&#039; and &#039;&#039;rating&#039;&#039; tables were deliberately kept small so that it would be possible to check your work by hand.</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Follow the instructions in the [[PostgreSQL Tutorial]] to load up your own copy of the sample movie database.&#160; To get &quot;warmed up,&quot; complete the tutorial so that you get some query practice before working on the questions below.&#160; Note that the &#039;&#039;member&#039;&#039; and &#039;&#039;rating&#039;&#039; tables were deliberately kept small so that it would be possible to check your work by hand.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Provide &#039;&#039;&#039;both&#039;&#039;&#039; the answer and the SQL query used to determine that answer.&#160; If the entire answer is too long, supply the first 10 records of that answer:</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Provide &#039;&#039;&#039;both&#039;&#039;&#039; the answer and the SQL query used to determine that answer.&#160; If the entire answer is too long <ins class="diffchange diffchange-inline">(say, 50 or more records)</ins>, supply the first 10 records of that answer:</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies were released before 1915?</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies were released before 1915?</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies from the 1980s had 4-digit numbers in their titles?</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies from the 1980s had 4-digit numbers in their titles?</div></td></tr> </table> Dondi https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?title=Week_6&diff=2124&oldid=prev Dondi: /* Movies from Text File to Tables */ Note about answer length. 2013-09-26T05:01:37Z <p>‎<span dir="auto"><span class="autocomment">Movies from Text File to Tables: </span> Note about answer length.</span></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 05:01, 26 September 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 24:</td> <td colspan="2" class="diff-lineno">Line 24:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Follow the instructions in the [[PostgreSQL Tutorial]] to load up your own copy of the sample movie database.&#160; To get &quot;warmed up,&quot; complete the tutorial so that you get some query practice before working on the questions below.&#160; Note that the &#039;&#039;member&#039;&#039; and &#039;&#039;rating&#039;&#039; tables were deliberately kept small so that it would be possible to check your work by hand.</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Follow the instructions in the [[PostgreSQL Tutorial]] to load up your own copy of the sample movie database.&#160; To get &quot;warmed up,&quot; complete the tutorial so that you get some query practice before working on the questions below.&#160; Note that the &#039;&#039;member&#039;&#039; and &#039;&#039;rating&#039;&#039; tables were deliberately kept small so that it would be possible to check your work by hand.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Provide &#039;&#039;&#039;both&#039;&#039;&#039; the answer and the SQL query used to determine that answer:</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Provide &#039;&#039;&#039;both&#039;&#039;&#039; the answer and the SQL query used to determine <ins class="diffchange diffchange-inline">that answer.&#160; If the entire answer is too long, supply the first 10 records of </ins>that answer:</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies were released before 1915?</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies were released before 1915?</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies from the 1980s had 4-digit numbers in their titles?</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div># What movies from the 1980s had 4-digit numbers in their titles?</div></td></tr> </table> Dondi  
{{Shared Journal Instructions|week=6}}
 
{{Shared Journal Instructions|week=6}}
   −
=== Reflect ===
+
=== Reflect on ''Stranger Visions'' ===
   Unexpected non-MediaWiki exception encountered, of type "Error"
Error: Call to undefined function each() in /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php:374
Stack trace:
#0 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(480): _DiffEngine->_diag()
#1 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(291): _DiffEngine->_compareseq()
#2 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(175): _DiffEngine->diff_local()
#3 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(653): _DiffEngine->diff()
#4 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(820): Diff->__construct()
#5 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(1240): MappedDiff->__construct()
#6 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(1458): WordLevelDiff->__construct()
#7 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(952): TableDiffFormatter->_changed()
#8 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(924): DiffFormatter->_block()
#9 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(765): DiffFormatter->format()
#10 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(655): DifferenceEngine->generateDiffBody()
#11 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(593): DifferenceEngine->getDiffBody()
#12 /apps/xmlpipedb/biodb/fall2013/includes/FeedUtils.php(147): DifferenceEngine->getDiff()
#13 /apps/xmlpipedb/biodb/fall2013/includes/actions/HistoryAction.php(303): FeedUtils::formatDiffRow()
#14 /apps/xmlpipedb/biodb/fall2013/includes/actions/HistoryAction.php(268): HistoryAction->feedItem()
#15 /apps/xmlpipedb/biodb/fall2013/includes/actions/HistoryAction.php(121): HistoryAction->feed()
#16 /apps/xmlpipedb/biodb/fall2013/includes/Action.php(541): HistoryAction->onView()
#17 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(427): FormlessAction->show()
#18 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(304): MediaWiki->performAction()
#19 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(536): MediaWiki->performRequest()
#20 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(446): MediaWiki->main()
#21 /apps/xmlpipedb/biodb/fall2013/index.php(59): MediaWiki->run()
#22 {main}