Difference between revisions of "Knguye66 Week 4"

From LMU BioDB 2019
Jump to navigation Jump to search
(Add references section)
(add bullet points)
Line 1: Line 1:
 
== The FDA Drug Database ==
 
== The FDA Drug Database ==
The purpose: what was the purpose of your investigations?
+
* The purpose: what was the purpose of your investigations?
Your methods: what did you actually do? Give a step by step account for Tasks 1-4 listed above.
+
* Your methods: what did you actually do? Give a step by step account for Tasks 1-4 listed above. There should be enough detail provided so that you or another person could re-do it based solely on your notebook. You may copy protocol instructions on your page and modify them as to what you actually did, as long as you provide appropriate attribution. Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc.
There should be enough detail provided so that you or another person could re-do it based solely on your notebook.
+
* Your results: the answers to the questions below, plus any other results you gathered. Usually it makes sense to embed your answers to the questions/results in the "methods" in the order in which you obtained them.
You may copy protocol instructions on your page and modify them as to what you actually did, as long as you provide appropriate attribution.
+
* A scientific conclusion: what was your main finding for today's project? Did you fulfill the purpose? Why or why not?
Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc.
 
Your results: the answers to the questions below, plus any other results you gathered.
 
Usually it makes sense to embed your answers to the questions/results in the "methods" in the order in which you obtained them.
 
A scientific conclusion: what was your main finding for today's project? Did you fulfill the purpose? Why or why not?
 
  
 
== Questions ==
 
== Questions ==

Revision as of 14:10, 24 September 2019

The FDA Drug Database

  • The purpose: what was the purpose of your investigations?
  • Your methods: what did you actually do? Give a step by step account for Tasks 1-4 listed above. There should be enough detail provided so that you or another person could re-do it based solely on your notebook. You may copy protocol instructions on your page and modify them as to what you actually did, as long as you provide appropriate attribution. Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc.
  • Your results: the answers to the questions below, plus any other results you gathered. Usually it makes sense to embed your answers to the questions/results in the "methods" in the order in which you obtained them.
  • A scientific conclusion: what was your main finding for today's project? Did you fulfill the purpose? Why or why not?

Questions

  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 (activeingred) is ATROPINE?
  3. In what forms and dosages 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 (sponsor applicant column) by MERCK?
  8. Which sponsor applicant 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?)

Data and Files

References

Acknowledgements