Difference between revisions of "MSymond1 Week 8"
(→Acknowledgments: added link) |
(→Acknowledgments: changed label) |
||
| Line 16: | Line 16: | ||
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 | + | 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] |
{{Template:MSymond1}} | {{Template:MSymond1}} | ||
Revision as of 11:22, 13 March 2024
Contents
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
- These are the names of the drugs that are administered in the forms INJECTABLE,INTRAVENOUS, and SUBCUTANEOUS.
- These are the names of the drugs whose active ingredient is ATROPINE.
- These are the forms and dosages that the drug BENADRYL can be administered.
- These are the names of the drugs that have names that end in ESTROL.
- 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.
- These are the names of the drugs that are sponsored by MERCK.
- These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN.
- 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.
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
User Page
Assignment Pages
Individual Journal Pages
- MSymond1 Week 1
- MSymond1 Week 2
- MSymond1 KMill104 Week 3
- NeMO_Week4
- MSymond1 Week 5
- MSymond1 Week 6
- MSymond1 Week 8
- MSymond1 Week 9
- MSymond1 Week 10
- MSymond1 Week 12
- MSymond1 Week 13
- MSymond1 Week 15
