Difference between revisions of "Nstojan1 Week 8"
Jump to navigation
Jump to search
Nstojan1-new (talk | contribs) (→Questions: added numbers and sub bullets) |
Nstojan1-new (talk | contribs) (→Questions: answered questions) |
||
| Line 10: | Line 10: | ||
#What are the names of the drug products whose active ingredient (activeingred) is ATROPINE? | #What are the names of the drug products whose active ingredient (activeingred) is ATROPINE? | ||
#*Query 2 | #*Query 2 | ||
| − | In what forms and dosages can the drug product named BENADRYL be administered? | + | #In what forms and dosages can the drug product named BENADRYL be administered? |
| − | Which drug products have a name ending in ESTROL? | + | #*Query 3 |
| − | 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.) | + | #Which drug products have a name ending in ESTROL? |
| − | 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.) | + | #*Query 4 |
| + | #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.) | ||
| + | #*No content was found when searching the database. | ||
| + | #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.) | ||
| + | #*No content was found when searching the database. | ||
What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK? | What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK? | ||
| − | Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE? | + | #*Query 5 |
| + | #Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE? | ||
| + | #*Query 6 | ||
Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?) | Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?) | ||
Revision as of 20:06, 13 March 2024
Purpose
- The purpose of this assignment is to learn now to enter data sets into Access and practice creating queries similar to the FDA Drug Database
Methods
- Firstly I began by downloading all the files and unzipping them. I then opened the 'new database' in Access and then went to 'external databases' to add the tables that were downloaded from the FDA Drug Database. Once on the 'external database' I selected 'form file' and then 'text file'.
Questions
- What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
- Query 1
- What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
- Query 2
- In what forms and dosages can the drug product named BENADRYL be administered?
- Query 3
- Which drug products have a name ending in ESTROL?
- Query 4
- 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.)
- No content was found when searching the database.
- 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.)
- No content was found when searching the database.
What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
- Query 5
- Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
- Query 6
Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
