<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?action=history&amp;feed=atom&amp;title=Troque_Week_6</id>
		<title>Troque Week 6 - Revision history</title>
		<link rel="self" type="application/atom+xml" href="https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?action=history&amp;feed=atom&amp;title=Troque_Week_6"/>
		<link rel="alternate" type="text/html" href="https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Troque_Week_6&amp;action=history"/>
		<updated>2026-04-04T05:56:29Z</updated>
		<subtitle>Revision history for this page on the wiki</subtitle>
		<generator>MediaWiki 1.25.1</generator>

	<entry>
		<id>https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Troque_Week_6&amp;diff=2582&amp;oldid=prev</id>
		<title>Troque: /* Questions to answer */ Added some line breaks</title>
		<link rel="alternate" type="text/html" href="https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Troque_Week_6&amp;diff=2582&amp;oldid=prev"/>
				<updated>2015-10-15T05:43:57Z</updated>
		
		<summary type="html">&lt;p&gt;‎&lt;span dir=&quot;auto&quot;&gt;&lt;span class=&quot;autocomment&quot;&gt;Questions to answer: &lt;/span&gt; Added some line breaks&lt;/span&gt;&lt;/p&gt;
&lt;table class=&#039;diff diff-contentalign-left&#039;&gt;
				&lt;col class=&#039;diff-marker&#039; /&gt;
				&lt;col class=&#039;diff-content&#039; /&gt;
				&lt;col class=&#039;diff-marker&#039; /&gt;
				&lt;col class=&#039;diff-content&#039; /&gt;
				&lt;tr style=&#039;vertical-align: top;&#039;&gt;
				&lt;td colspan=&#039;2&#039; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&#039;2&#039; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Revision as of 05:43, 15 October 2015&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;L179&quot; &gt;Line 179:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 179:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &amp;#039;&amp;#039;&amp;#039;What are the names of the drug products that are administered in the &amp;#039;&amp;#039;form&amp;#039;&amp;#039; &amp;lt;code&amp;gt;INJECTABLE;INTRAVENOUS, SUBCUTANEOUS&amp;lt;/code&amp;gt;?&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &amp;#039;&amp;#039;&amp;#039;What are the names of the drug products that are administered in the &amp;#039;&amp;#039;form&amp;#039;&amp;#039; &amp;lt;code&amp;gt;INJECTABLE;INTRAVENOUS, SUBCUTANEOUS&amp;lt;/code&amp;gt;?&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) The drugs are &amp;lt;code&amp;gt;&amp;quot;LOVENOX&amp;quot;, &amp;quot;VELCADE&amp;quot;, &amp;quot;VIDAZA&amp;quot;, &amp;quot;ENOXAPARIN SODIUM&amp;quot;, &amp;quot;ACTEMRA&amp;quot;, and &amp;quot;AZACITIDINE&amp;quot;&amp;lt;/code&amp;gt;. &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) The drugs are &amp;lt;code&amp;gt;&amp;quot;LOVENOX&amp;quot;, &amp;quot;VELCADE&amp;quot;, &amp;quot;VIDAZA&amp;quot;, &amp;quot;ENOXAPARIN SODIUM&amp;quot;, &amp;quot;ACTEMRA&amp;quot;, and &amp;quot;AZACITIDINE&amp;quot;&amp;lt;/code&amp;gt;. &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;−&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(b) &amp;lt;code&amp;gt;select drugname from product where form = &amp;#039;INJECTABLE;INTRAVENOUS, SUBCUTANEOUS&amp;#039;;&amp;lt;/code&amp;gt;. &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(b) &amp;lt;code&amp;gt;select drugname from product where form = &amp;#039;INJECTABLE;INTRAVENOUS, SUBCUTANEOUS&amp;#039;;&amp;lt;/code&amp;gt;. &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;&amp;lt;br&amp;gt;&lt;/ins&gt;&amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &amp;#039;&amp;#039;&amp;#039;What are the names of the drug products whose active ingredient (&amp;#039;&amp;#039;activeingred&amp;#039;&amp;#039;) is &amp;lt;code&amp;gt;ATROPINE&amp;lt;/code&amp;gt;?&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &amp;#039;&amp;#039;&amp;#039;What are the names of the drug products whose active ingredient (&amp;#039;&amp;#039;activeingred&amp;#039;&amp;#039;) is &amp;lt;code&amp;gt;ATROPINE&amp;lt;/code&amp;gt;?&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) There were only two, ATROPEN and ATROPINE with the active ingredient &amp;lt;code&amp;gt;ATROPINE&amp;lt;/code&amp;gt;. Note: There were 4 instances of ATROPEN in the database. &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) There were only two, ATROPEN and ATROPINE with the active ingredient &amp;lt;code&amp;gt;ATROPINE&amp;lt;/code&amp;gt;. Note: There were 4 instances of ATROPEN in the database. &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;L213&quot; &gt;Line 213:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 213:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) &amp;quot;DIETHYLSTILBESTROL&amp;quot; (11 instances), &amp;quot;STILBESTROL&amp;quot; (12 instances), and &amp;quot;DIENESTROL&amp;quot; (1 instance). &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) &amp;quot;DIETHYLSTILBESTROL&amp;quot; (11 instances), &amp;quot;STILBESTROL&amp;quot; (12 instances), and &amp;quot;DIENESTROL&amp;quot; (1 instance). &amp;lt;br&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(b) &amp;lt;code&amp;gt;select drugname from product where drugname ~ &amp;#039;ESTROL$&amp;#039;;&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(b) &amp;lt;code&amp;gt;select drugname from product where drugname ~ &amp;#039;ESTROL$&amp;#039;;&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &amp;#039;&amp;#039;&amp;#039;Produce a table listing all of the known values for the &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; column in the &amp;#039;&amp;#039;application&amp;#039;&amp;#039; table and how many &amp;#039;&amp;#039;application&amp;#039;&amp;#039; records there are of each. (&amp;#039;&amp;#039;Side note:&amp;#039;&amp;#039; The &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; codes are explained in the &amp;#039;&amp;#039;ReviewClass_Lookup.txt&amp;#039;&amp;#039; file, in case you’re interested.)&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &amp;#039;&amp;#039;&amp;#039;Produce a table listing all of the known values for the &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; column in the &amp;#039;&amp;#039;application&amp;#039;&amp;#039; table and how many &amp;#039;&amp;#039;application&amp;#039;&amp;#039; records there are of each. (&amp;#039;&amp;#039;Side note:&amp;#039;&amp;#039; The &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; codes are explained in the &amp;#039;&amp;#039;ReviewClass_Lookup.txt&amp;#039;&amp;#039; file, in case you’re interested.)&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) &amp;#160;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(a) &amp;#160;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Troque</name></author>	</entry>

<tr><td colspan="2" class="diff-lineno" id="L175" ><!--LINE 175--></td>
<td colspan="2" class="diff-lineno"><!--LINE 175--></td></tr>
<tr><td class='diff-marker'>&#160;</td><td class='diff-context'><div>* &#039;&#039;&#039;In your database, are these numbers the same or different? Explain why you think so.</div></td><td class='diff-marker'>&#160;</td><td class='diff-context'><div>* &#039;&#039;&#039;In your database, are these numbers the same or different? Explain why you think so.</div></td></tr>
<tr><td class='diff-marker'>&#160;</td><td class='diff-context'><div>The numbers are actually the same since what &lt;code&gt;wc&lt;/code&gt; gives is actually all the records plus the header. Since the SQL table &#039;&#039;technically&#039;&#039; gives the records + the 1 row of labels that it generated for its environment, the header matches up with the first line of the files.&#039;&#039;&#039;</div></td><td class='diff-marker'>&#160;</td><td class='diff-context'><div>The numbers are actually the same since what &lt;code&gt;wc&lt;/code&gt; gives is actually all the records plus the header. Since the SQL table &#039;&#039;technically&#039;&#039; gives the records + the 1 row of labels that it generated for its environment, the header matches up with the first line of the files.&#039;&#039;&#039;</div></td></tr>
<tr><td class='diff-marker'>−</td><td class='diff-deletedline'><div>&lt;br&gt;</div></td><td class='diff-marker'>+</td><td class='diff-addedline'><div><ins class="diffchange diffchange-inline">&lt;br&gt;</ins>&lt;br&gt;</div></td></tr>
<tr><td class='diff-marker'>&#160;</td><td class='diff-context'><div>*: &#039;&#039;For the remaining questions, supply (a) the answer to the question and (b) the SQL statement that you used to answer the question.&#039;&#039;</div></td><td class='diff-marker'>&#160;</td><td class='diff-context'><div>*: &#039;&#039;For the remaining questions, supply (a) the answer to the question and (b) the SQL statement that you used to answer the question.&#039;&#039;</div></td></tr>
<tr><td class='diff-marker'>−</td><td class='diff-deletedline'><div><del class="diffchange">&lt;br&gt;</del></div></td><td colspan="2">&#160;</td></tr>
<tr><td class='diff-marker'>&#160;</td><td class='diff-context'><div>* &#039;&#039;&#039;What are the names of the drug products that are administered in the &#039;&#039;form&#039;&#039; &lt;code&gt;INJECTABLE;INTRAVENOUS, SUBCUTANEOUS&lt;/code&gt;?&#039;&#039;&#039;</div></td><td class='diff-marker'>&#160;</td><td class='diff-context'><div>* &#039;&#039;&#039;What are the names of the drug products that are administered in the &#039;&#039;form&#039;&#039; &lt;code&gt;INJECTABLE;INTRAVENOUS, SUBCUTANEOUS&lt;/code&gt;?&#039;&#039;&#039;</div></td></tr>
Exception encountered, of type &quot;Error&quot;<br />
[dfc0e606] /biodb/fall2015/index.php?action=history&amp;feed=atom&amp;title=Troque_Week_6   Error from line 434 of /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php: Call to undefined function each()<br />
Backtrace:<br />
#0 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(544): DiffEngine-&gt;diag()<br />
#1 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(344): DiffEngine-&gt;compareSeq()<br />
#2 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(227): DiffEngine-&gt;diffLocal()<br />
#3 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(721): DiffEngine-&gt;diff()<br />
#4 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(859): Diff-&gt;__construct()<br />
#5 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(980): MappedDiff-&gt;__construct()<br />
#6 /apps/xmlpipedb/biodb/fall2015/includes/diff/TableDiffFormatter.php(194): WordLevelDiff-&gt;__construct()<br />
#7 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(140): TableDiffFormatter-&gt;changed()<br />
#8 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(82): DiffFormatter-&gt;block()<br />
#9 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(888): DiffFormatter-&gt;format()<br />
#10 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(802): DifferenceEngine-&gt;generateTextDiffBody()<br />
#11 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(733): DifferenceEngine-&gt;generateContentDiffBody()<br />
#12 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(662): DifferenceEngine-&gt;getDiffBody()<br />
#13 /apps/xmlpipedb/biodb/fall2015/includes/FeedUtils.php(155): DifferenceEngine-&gt;getDiff()<br />
#14 /apps/xmlpipedb/biodb/fall2015/includes/actions/HistoryAction.php(325): FeedUtils::formatDiffRow()<br />
#15 /apps/xmlpipedb/biodb/fall2015/includes/actions/HistoryAction.php(290): HistoryAction-&gt;feedItem()<br />
#16 /apps/xmlpipedb/biodb/fall2015/includes/actions/HistoryAction.php(130): HistoryAction-&gt;feed()<br />
#17 /apps/xmlpipedb/biodb/fall2015/includes/actions/FormlessAction.php(43): HistoryAction-&gt;onView()<br />
#18 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(395): FormlessAction-&gt;show()<br />
#19 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(273): MediaWiki-&gt;performAction()<br />
#20 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(566): MediaWiki-&gt;performRequest()<br />
#21 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(414): MediaWiki-&gt;main()<br />
#22 /apps/xmlpipedb/biodb/fall2015/index.php(44): MediaWiki-&gt;run()<br />
#23 {main}<br />

