Week 6 - Revision history

Dondi: Remove Under Construction message.

2015-10-06T07:49:08Z

Remove Under Construction message.

Dondi: /* Shared Journal Assignment */ Shared journal questions.

2015-10-06T07:48:40Z

‎Shared Journal Assignment: Shared journal questions.

Dondi: /* Individual Journal Assignment */ Rearrange outline.

2015-10-06T07:31:49Z

‎Individual Journal Assignment: Rearrange outline.

Dondi: /* Questions to Answer */ Question refinements.

2015-10-06T07:26:25Z

‎Questions to Answer: Question refinements.

← Older revision		Revision as of 07:49, 6 October 2015
Line 1:		Line 1:
	'''This journal entry is due on Tuesday, October 13, at midnight PDT.''' ''(Monday night/Tuesday morning)''		'''This journal entry is due on Tuesday, October 13, at midnight PDT.''' ''(Monday night/Tuesday morning)''
−
−	~~{{ Under Construction }}~~

	== Overview ==		== Overview ==

@@ Line 122: / Line 122: @@
 * Sign your portion of the journal with the standard wiki signature shortcut (<code><nowiki>~~~~</nowiki></code>).
 * Add the "Journal Entry" and "Shared" categories to the end of the wiki page (if someone has not already done so).
 [[Category:Assignment]]

@@ Line 47: / Line 47: @@
 # Answer the questions below.
-=== Direct Download/Unzipping Commands ===
+==== Direct Download/Unzipping Commands ====
 To mirror the procedures performed with the ''movie_titles.txt'' file, this section shows you how to (a) download and process the FDA files on the ''my.cs.lmu.edu'' server via PuTTY/<code>ssh</code> then (b) make your processed files available to the Seaver 120 workstations via the built-in ''my.cs.lmu.edu'' server. To do so, we introduce some additional commands that you may use verbatim at the ''my.cs.lmu.edu'' command line.
@@ Line 85: / Line 85: @@
 Again, note that these latter steps exactly mirror the tutorial for the ''movie_titles.txt'' file, so please refer to [[PostgreSQL_Tutorial|that wiki page]] for additional details.
-=== Supplementary Information ===
+==== Supplementary Information ====
 Just as with [[Week 4]], real-world data have their share of variations and exceptions. For these files:
@@ Line 111: / Line 111: @@
 # Produce a table listing all of the known values for the ''therapeutic_potential'' column in the ''application'' table and how many ''application'' records there are of each. (''Side note:'' The ''therapeutic_potential'' codes are explained in the ''ReviewClass_Lookup.txt'' file, in case you’re interested.)
 # Produce a table listing all of the known values for the ''chemical_type'' column in the ''application'' table and how many ''application'' records there are of each. (''Side note:'' The ''chemical_type'' codes are explained in the ''ChemTypeLookup.txt'' file, in case you’re interested.)
-# What are the names of the drug products are sponsored (''sponsor applicant'' column) by <code>MERCK</code>?
+# What are the names of the drug products that are sponsored (''sponsor applicant'' column) by <code>MERCK</code>?
 # Which ''sponsor applicant'' companies have the text <code>LABS</code> in their names and have products whose active ingredients (''activeingred'') include ''both'' <code>ASPIRIN</code> and <code>CAFFEINE</code>?

← Older revision		Revision as of 07:26, 6 October 2015
Line 98:		Line 98:

	=== Questions to Answer ===		=== Questions to Answer ===
		+
		+	# Provide the DDL (<code>create table</code>) statements that you used for your ''application'' and ''product'' tables.
		+	# Provide the <code>sed</code> command sequences that you used to convert the raw text files into sequences of SQL <code>insert</code> statements.
		+	# Using the command line, how can you determine the number of records in each file? Provide the command.
		+	# Using SQL, how can you determine the number of records in the table corresponding to the file? Provide the SQL <code>select</code> statement.
		+	# In your database, are these numbers the same or different? Explain why you think so.
		+	#: ''For the remaining questions, supply (a) the answer to the question and (b) the SQL statement that you used to answer the question.''
		+	# What are the names of the drug products that are administered in the ''form'' <code>INJECTABLE;INTRAVENOUS, SUBCUTANEOUS</code>?
		+	# What are the names of the drug products whose active ingredient (''activeingred'') is <code>ATROPINE</code>?
		+	# In what ''form''s and ''dosage''s can the drug product named <code>BENADRYL</code> be administered?
		+	# Which drug products have a name ''ending'' in <code>ESTROL</code>?
		+	# Produce a table listing all of the known values for the ''therapeutic_potential'' column in the ''application'' table and how many ''application'' records there are of each. (''Side note:'' The ''therapeutic_potential'' codes are explained in the ''ReviewClass_Lookup.txt'' file, in case you’re interested.)
		+	# Produce a table listing all of the known values for the ''chemical_type'' column in the ''application'' table and how many ''application'' records there are of each. (''Side note:'' The ''chemical_type'' codes are explained in the ''ChemTypeLookup.txt'' file, in case you’re interested.)
		+	# What are the names of the drug products are sponsored (''sponsor applicant'' column) by <code>MERCK</code>?
		+	# Which ''sponsor applicant'' companies have the text <code>LABS</code> in their names and have products whose active ingredients (''activeingred'') include ''both'' <code>ASPIRIN</code> and <code>CAFFEINE</code>?

	== Shared Journal Assignment ==		== Shared Journal Assignment ==