Difference between revisions of "Ckaplan Week 8"
Jump to navigation
Jump to search
(steps) |
|||
| Line 1: | Line 1: | ||
| + | -add file here | ||
| + | |||
*Procedure: | *Procedure: | ||
Revision as of 18:33, 13 March 2024
-add file here
- Procedure:
- Methods:
- Results:
- Conclusion:
Contents
- 1 What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
- 2 What are the names of the drug products whose active ingredient (activeingredient) is ATROPINE?
- 3 In what forms and strengths can the drug product named BENADRYL be administered?
- 4 Which drug products have a name ending in ESTROL?
- 5 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.)
- 6 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.)
- 7 What are the names of the drug products that are sponsored (sponsorname column) by MERCK?
- 8 Which sponsorname companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
- 9 Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
- 10 Assignment Pages
- 11 Individual Journal Entry Pages
- 12 Shared Journal Entry Pages
What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
What are the names of the drug products whose active ingredient (activeingredient) is ATROPINE?
In what forms and strengths can the drug product named BENADRYL be administered?
Which drug products have a name ending in ESTROL?
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 that are sponsored (sponsorname column) by MERCK?
Which sponsorname companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
Assignment Pages
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
Individual Journal Entry Pages
- ckaplan Week 1
- ckaplan Week 2
- SIR2 Week 3
- AgeAnnoMO Week 4
- ckaplan Week 5
- ckaplan Week 6
- ckaplan Week 8
- ckaplan Week 9
- ckaplan Week 10
- ckaplan Week 11
- ckaplan Week 12
- ckaplan Week 13
- ckaplan Week 14
- ckaplan Week 15
