Kmill104 Week 8

Purpose

The purpose of this week's assignment was to learn how data sets are organized and how relationships are defined between them, as well as how to download data and set up these relationships on our own database. It also gave us practice using queries in Microsoft Access and following the SQL format.

Results

1. What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
   • LOVENOX, VELCADE, APIDRA, ENOXOPARIN SODIUM, ACTEMRA, BORTEZOMIB, WEZLANA
     • SELECT DrugName FROM Products WHERE form ='INJECTABLE;INTRAVENOUS, SUBCUTANEOUS';
2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
   • ATROPEN, ATROPINE, ATROPINE (AUTOINJECTOR)
     • SELECT DrugName FROM Products WHERE ActiveIngredient ='ATROPINE';
3. In what forms and dosages can the drug product named BENADRYL be administered?
   • Form: Capsule;Oral and Strength: 50MG
   • Form: Elixir;Oral and Strength: 12.5MG/5ML
   • Form: Capsule;Oral and Strength: 25 MG
   • Form: Injectable;Injection and Strength: 10MG/ML
   • Form: Injectable;Injection and Strength: 50 MG/ML
     • SELECT Form, Strength FROM Products WHERE DrugName = 'BENADRYL';
4. Which drug products have a name ending in ESTROL?
   • DIETHYLSTILBESTROL, STILBESTROL
     • SELECT DrugName FROM Products WHERE DrugName LIKE '*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.)
   • Not possible, no therapeutic_potential column
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.)
   • Not possible, no chemical_type column
7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
   • • SELECT Products.DrugName FROM Products LEFT JOIN Applications ON Products.ApplNo = Applications.ApplNo WHERE (((Applications.[SponsorName])='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?
   • Watson Labs, Nostrum Labs Inc, Dr Reddys Labs SA
     • SELECT SponsorName, ActiveIngredient FROM Applications RIGHT JOIN Products ON Applications.ApplNo = Products.ApplNo WHERE ActiveIngredient LIKE '*ASPIRIN*CAFFEINE*' AND SponsorName LIKE '*LABS*';
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?)