Difference between revisions of "MSymond1 Week 8"

From LMU BioDB 2024
Jump to navigation Jump to search
(added acknowledgments)
(added references)
 
(11 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
This assignment included using a data set from the Food and Drug Administration (FDA) that has all of its public records about all of its drugs and other information regarding them. First, the files were downloaded from the FDA website and uncompressed. The 11 tables were then imported into Microsoft Access and the parameters of them were implemented, including whether they were integers, text, required, or primary keys, and the maximum character count of each of the items. Then the relationships between the tables were defined. The FDA includes a picture of all of the relationships between the tables, so this is what was used for reference in making the relationships in Microsoft Access. Then queries were created to search for certain drugs of certain names or other parameters.
 
This assignment included using a data set from the Food and Drug Administration (FDA) that has all of its public records about all of its drugs and other information regarding them. First, the files were downloaded from the FDA website and uncompressed. The 11 tables were then imported into Microsoft Access and the parameters of them were implemented, including whether they were integers, text, required, or primary keys, and the maximum character count of each of the items. Then the relationships between the tables were defined. The FDA includes a picture of all of the relationships between the tables, so this is what was used for reference in making the relationships in Microsoft Access. Then queries were created to search for certain drugs of certain names or other parameters.
 
==Results==
 
==Results==
−
#These are the names of the drugs that are administered in the forms INJECTABLE,INTRAVENOUS, and SUBCUTANEOUS.
+
#These are the names of the drugs that are administered in the forms INJECTABLE,INTRAVENOUS, and SUBCUTANEOUS. [[File:Symonds_Week8_Question_1.xlsx]]
−
#These are the names of the drugs whose active ingredient is ATROPINE.
+
#These are the names of the drugs whose active ingredient is ATROPINE. [[File:Symonds_Week8_Question_2.xlsx]]
−
#These are the forms and dosages that the drug BENADRYL can be administered.  
+
#These are the forms and dosages that the drug BENADRYL can be administered. [[File:Symonds_Week8_Question_3.xlsx]]
−
#These are the names of the drugs that have names that end in ESTROL.
+
#These are the names of the drugs that have names that end in ESTROL. [[File:Symonds_Week8_Question_4.xlsx]]
 
#This question could not be completed because the column does not exist anymore.
 
#This question could not be completed because the column does not exist anymore.
 
#This question also could not be completed because this column also does not exist anymore.
 
#This question also could not be completed because this column also does not exist anymore.
−
#These are the names of the drugs that are sponsored by MERCK.
+
#These are the names of the drugs that are sponsored by MERCK. [[File:Symonds_Week8_Question_7.xlsx]]
−
#These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN.
+
#These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN. [[File:Symonds_Week8_Question_8.xlsx]]
 
#I do not believe I would be able to complete these questions if I did not have Microsoft Access and had to completely rely on the FDA website. For example, the search engine does not even allow to search by sponsor name. It also does not allow to search two active ingredients at once. Therefore, it would not be possible to do many of the queries that were required to obtain the information for these questions.
 
#I do not believe I would be able to complete these questions if I did not have Microsoft Access and had to completely rely on the FDA website. For example, the search engine does not even allow to search by sponsor name. It also does not allow to search two active ingredients at once. Therefore, it would not be possible to do many of the queries that were required to obtain the information for these questions.
 +
===Data and Files===
 +
*Master Database[[File:Symonds_MS_Access_Drug_Database.accdb.zip]]
 +
*FDA files [[File:Symonds_FDA_Files.zip]]
 +
 
==Conclusion==
 
==Conclusion==
 
The main findings from this assignment are that using databases made by certain programs such as Microsoft Access are very helpful in obtaining information that would not be possible otherwise. It does, however, come with many difficulties. It was noted that data in the real world is not often "clean" and it is not possible to put it directly into a database and expect it to work perfectly. There were many problems with this data set being very old in this assignment as well. Two of the questions could not even be answered anymore because of columns that no longer exist. There were also many issues in assigning primary keys to the data set. For the keys that the FDA listed on the website would often have several duplicates in the dataset, meaning it is unable to be a primary key. For all of these imperfections, using these databases did prove to be very helpful in the field.
 
The main findings from this assignment are that using databases made by certain programs such as Microsoft Access are very helpful in obtaining information that would not be possible otherwise. It does, however, come with many difficulties. It was noted that data in the real world is not often "clean" and it is not possible to put it directly into a database and expect it to work perfectly. There were many problems with this data set being very old in this assignment as well. Two of the questions could not even be answered anymore because of columns that no longer exist. There were also many issues in assigning primary keys to the data set. For the keys that the FDA listed on the website would often have several duplicates in the dataset, meaning it is unable to be a primary key. For all of these imperfections, using these databases did prove to be very helpful in the field.
 
==Acknowledgments==
 
==Acknowledgments==
−
My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the FDA website [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm]
+
My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website]. Except for what is noted above, this individual journal entry was completed by me and not copied from another source. [[User:Msymond1|Msymond1]] ([[User talk:Msymond1|talk]]) 19:55, 13 March 2024 (PDT)
 +
==References==
 +
*Access SQL: basic concepts, vocabulary, and syntax—Microsoft Support. (n.d.). Retrieved March 13, 2024, from https://support.microsoft.com/en-us/office/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671?ui=en-us&rs=en-us&ad=us
 +
*Drugs@FDA Data Files. (n.d.). FDA; FDA. Retrieved March 13, 2024, from https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files
 +
*Drugs@FDA: FDA-Approved Drugs. (n.d.). Retrieved March 13, 2024, from https://www.accessdata.fda.gov/scripts/cder/daf/index.cfm
 +
*Ford, P. (2015, June 11). What Is Code? Bloomberg. https://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/
 +
*LMU BioDB 2024. (2024). Week 8. Retrieved March 13, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_8
 
{{Template:MSymond1}}
 
{{Template:MSymond1}}

Latest revision as of 22:39, 13 March 2024

Purpose

The purpose of this assignment was to use Microsoft Access to gain experience with creating databases and creating queries in them. In this assignment, a dataset was used from the FDA, which was intended to give insight on how databases tend to be in the real world for all their imperfections.

Methods

This assignment included using a data set from the Food and Drug Administration (FDA) that has all of its public records about all of its drugs and other information regarding them. First, the files were downloaded from the FDA website and uncompressed. The 11 tables were then imported into Microsoft Access and the parameters of them were implemented, including whether they were integers, text, required, or primary keys, and the maximum character count of each of the items. Then the relationships between the tables were defined. The FDA includes a picture of all of the relationships between the tables, so this is what was used for reference in making the relationships in Microsoft Access. Then queries were created to search for certain drugs of certain names or other parameters.

Results

  1. These are the names of the drugs that are administered in the forms INJECTABLE,INTRAVENOUS, and SUBCUTANEOUS. File:Symonds Week8 Question 1.xlsx
  2. These are the names of the drugs whose active ingredient is ATROPINE. File:Symonds Week8 Question 2.xlsx
  3. These are the forms and dosages that the drug BENADRYL can be administered. File:Symonds Week8 Question 3.xlsx
  4. These are the names of the drugs that have names that end in ESTROL. File:Symonds Week8 Question 4.xlsx
  5. This question could not be completed because the column does not exist anymore.
  6. This question also could not be completed because this column also does not exist anymore.
  7. These are the names of the drugs that are sponsored by MERCK. File:Symonds Week8 Question 7.xlsx
  8. These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN. File:Symonds Week8 Question 8.xlsx
  9. I do not believe I would be able to complete these questions if I did not have Microsoft Access and had to completely rely on the FDA website. For example, the search engine does not even allow to search by sponsor name. It also does not allow to search two active ingredients at once. Therefore, it would not be possible to do many of the queries that were required to obtain the information for these questions.

Data and Files

Conclusion

The main findings from this assignment are that using databases made by certain programs such as Microsoft Access are very helpful in obtaining information that would not be possible otherwise. It does, however, come with many difficulties. It was noted that data in the real world is not often "clean" and it is not possible to put it directly into a database and expect it to work perfectly. There were many problems with this data set being very old in this assignment as well. Two of the questions could not even be answered anymore because of columns that no longer exist. There were also many issues in assigning primary keys to the data set. For the keys that the FDA listed on the website would often have several duplicates in the dataset, meaning it is unable to be a primary key. For all of these imperfections, using these databases did prove to be very helpful in the field.

Acknowledgments

My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the FDA Website. Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Msymond1 (talk) 19:55, 13 March 2024 (PDT)

References

User Page

Assignment Pages

Individual Journal Pages

Class Journal Pages

Retrieved from "https://xmlpipedb.lmucs.org/biodb/spring2024/index.php?title=MSymond1_Week_8&oldid=2221"