Nstojan1 Week 8 - Revision history

Nstojan1-new: /* Methods */ added file

2024-03-14T21:13:00Z

‎Methods: added file

2024-03-14T21:10:21Z

‎Methods: added database

2024-03-14T20:57:06Z

‎Methods: edit syntax

2024-03-14T20:54:18Z

‎Methods: added name

2024-03-14T20:53:34Z

‎Methods: added file

2024-03-14T04:32:59Z

‎Methods: edited methods

2024-03-14T04:24:38Z

added scientific conclusion

2024-03-14T04:15:54Z

‎Purpose: edited purpose

2024-03-14T04:14:23Z

‎Methods: edited methods

2024-03-14T04:08:17Z

‎Questions: added number

@@ Line 7: / Line 7: @@
 *Download Files can be found here: [[File:Datfda20240312.zip | Downloaded Zip Files]]
-*Database:
+*Database: [[File:Database_Natalija.zip]]
 ==Results==

← Older revision		Revision as of 21:10, 14 March 2024
Line 6:		Line 6:

	*Download Files can be found here: [[File:Datfda20240312.zip \| Downloaded Zip Files]]		*Download Files can be found here: [[File:Datfda20240312.zip \| Downloaded Zip Files]]
		+
		+	*Database:

	==Results==		==Results==

@@ Line 5: / Line 5: @@
 *Firstly I began by downloading all the files from the FDA database 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'. When importing the files, I made sure that the fields matched up correctly with the schema. I then created queries and used the SLQ function to find certain information. To do this I went to the 'create ' tab and clicked 'query design' a window then popped up with a list of my tables and I selected the 'Products' table and then'Ok'. I then clicked 'SLQ' entered the information to find specific drug products and clicked 'Run' to get a result.
-*Download Files can be found here: [[File:Datfda20240312.zip|Dowlnoaded Zip Files]]
+*Download Files can be found here: [[File:Datfda20240312.zip | Downloaded Zip Files]]
 ==Results==

@@ Line 5: / Line 5: @@
 *Firstly I began by downloading all the files from the FDA database 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'. When importing the files, I made sure that the fields matched up correctly with the schema. I then created queries and used the SLQ function to find certain information. To do this I went to the 'create ' tab and clicked 'query design' a window then popped up with a list of my tables and I selected the 'Products' table and then'Ok'. I then clicked 'SLQ' entered the information to find specific drug products and clicked 'Run' to get a result.
-*Download Files can be found here: [[File:Datfda20240312.zip]]
+*Download Files can be found here: [[File:Datfda20240312.zip|Dowlnoaded Zip Files]]
 ==Results==

@@ Line 4: / Line 4: @@
 ==Methods==
 *Firstly I began by downloading all the files from the FDA database 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'. When importing the files, I made sure that the fields matched up correctly with the schema. I then created queries and used the SLQ function to find certain information. To do this I went to the 'create ' tab and clicked 'query design' a window then popped up with a list of my tables and I selected the 'Products' table and then'Ok'. I then clicked 'SLQ' entered the information to find specific drug products and clicked 'Run' to get a result.
 ==Results==

← Older revision		Revision as of 04:24, 14 March 2024
Line 23:		Line 23:
	#*Query 6		#*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?)
		+
		+	==Scientific Conclusion==
		+	My main findings for this project was how to use queries as a search function with the help of SLQ to find the different drugs products, sponsors and drugs with certain active ingredients. The purpose was fulfilled for most of the questions since I got an answer, however, for two of the questions, the content wasn't in the database. Another main finding other than creating queries and using SLQ was building relationships between tables and learning how to relate them when writing the SLQ.

@@ Line 1: / Line 1: @@
 ==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
+*The purpose of this assignment is to learn now to enter data sets into Access and practice creating queries similar to find certain information from the tables imported from the FDA database.
 ==Methods==

@@ Line 3: / Line 3: @@
 ==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'.
+*Firstly I began by downloading all the files from the FDA database 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'. When importing the files, I made sure that the fields matched up correctly with the schema. However, there were instances where the FDA database listed certain fields as keys but since they contained duplicate information, Access presented me with an error and didn't allow them to be primary keys. Lastly, I created relationships with the imported tables to match the FDA database table.
 ==Results==

@@ Line 5: / Line 5: @@
 *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==
+==Results==
 #*What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
 #*Query 1
@@ Line 22: / Line 22: @@
 #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?)