Ckaplan Week 8 - Revision history

Ckapla12: citing FDA

2024-03-14T04:28:03Z

citing FDA

Ckapla12 at 04:26, 14 March 2024

2024-03-14T04:26:03Z

Ckapla12: final acknowledgments and references

2024-03-14T04:24:35Z

final acknowledgments and references

Ckapla12: Conclusion summary

2024-03-14T04:17:34Z

Conclusion summary

Ckapla12: results

2024-03-14T04:16:14Z

results

Ckapla12 at 04:13, 14 March 2024

2024-03-14T04:13:32Z

Ckapla12: writing procedure

2024-03-14T04:13:24Z

writing procedure

Ckapla12: file

2024-03-14T04:08:48Z

file

Ckapla12: creating methods

2024-03-14T04:02:42Z

creating methods

Ckapla12: /* 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...

2024-03-14T02:50:43Z

/* 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...

@@ Line 139: / Line 139: @@
 https://edu.gcfglobal.org/en/access2016/designing-a-simple-query/1/
 https://support.microsoft.com/en-us/office/create-edit-or-delete-a-relationship-dfa453a7-0b6d-4c34-a128-fdebc7e686af#:~:text=On%20the%20Database%20Tools%20tab,Relationships%20document%20tab%2C%20click%20Close.
 ==Acknowledgments==

@@ Line 141: / Line 141: @@
 ==Acknowledgments==
-Dr. Dionisio helped in class. On 3/12/23 Dr. Dahlquist assisted me over Zoom, along with my classmates. [[Hivanson]] helped me zip my file to upload. [[Nstojanovic]] helped me in class with my queries.
+Dr. Dionisio helped in class. On 3/12/23 Dr. Dahlquist assisted me over Zoom, along with my classmates.[[User:Hivanson| Hailey Ivanson]] helped me zip my file to upload. [[User:Nstojan1| Natalija Stojanovic]] helped me in class with my queries.
 Except for what is noted above, this individual journal entry was completed by me and not copied from another source.

← Older revision		Revision as of 04:24, 14 March 2024
Line 132:		Line 132:

	===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?)===
		+
		+	I would not have been able to answer these questions by just using the FDA website.
		+
		+	==References==
		+	[[Week 8]]
		+	https://edu.gcfglobal.org/en/access2016/designing-a-simple-query/1/
		+	https://support.microsoft.com/en-us/office/create-edit-or-delete-a-relationship-dfa453a7-0b6d-4c34-a128-fdebc7e686af#:~:text=On%20the%20Database%20Tools%20tab,Relationships%20document%20tab%2C%20click%20Close.
		+
		+	==Acknowledgments==
		+	Dr. Dionisio helped in class. On 3/12/23 Dr. Dahlquist assisted me over Zoom, along with my classmates. [[Hivanson]] helped me zip my file to upload. [[Nstojanovic]] helped me in class with my queries.
		+
		+	Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
		+	[[User:Ckapla12\|Ckapla12]] ([[User talk:Ckapla12\|talk]]) 21:24, 13 March 2024 (PDT)

	{{ckaplan}}		{{ckaplan}}

← Older revision		Revision as of 04:17, 14 March 2024
Line 29:		Line 29:

	*Conclusion:		*Conclusion:
		+	In conclusion, our work with Microsoft Access on the FDA drug dataset was successful. We were able to extract important information like drug names and manufacturers efficiently. Although this was a tough assignment, I learned a lot about how to use Access.

	===What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?===		===What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?===

← Older revision		Revision as of 04:16, 14 March 2024
Line 26:		Line 26:

	*Results:		*Results:
		+	Through creating the queries, the software located the information we needed regarding drug names, manufacturers, and other relevant attributes within the FDA drug dataset,teaching us the effectiveness of our database management and querying techniques in automating data retrieval for analysis.

	*Conclusion:		*Conclusion:

← Older revision		Revision as of 04:13, 14 March 2024
Line 1:		Line 1:
	[[File:Database Ckapla12.accdb.zip]]		[[File:Database Ckapla12.accdb.zip]]
−

	*Procedure:		*Procedure:

@@ Line 3: / Line 3: @@
 *Procedure:
 *Methods:
 Data Acquisition and Preparation:
 The drug dataset was acquired from the FDA website, consisting of 11 tables with diverse drug-related information. These files were downloaded and extracted.

← Older revision		Revision as of 04:08, 14 March 2024
Line 1:		Line 1:
−	~~-add file here~~	+	[[File:Database Ckapla12.accdb.zip]]
		+

	*Procedure:		*Procedure:

← Older revision		Revision as of 04:02, 14 March 2024
Line 4:		Line 4:

	*Methods:		*Methods:
		+	Methods
		+
		+	Data Acquisition and Preparation:
		+	The drug dataset was acquired from the FDA website, consisting of 11 tables with diverse drug-related information. These files were downloaded and extracted.
		+
		+	Database Design and Implementation:
		+	Microsoft Access was used for managing the database. The files were imported into Access, ensuring that the data structure was correctly interpreted by specifying the file format and field names.
		+	During the import, the FDA's data types were matched with appropriate
		+
		+	Access data types:
		+	Char -> Short Text (Character count set in design mode)
		+	Varchar -> Long Text
		+	Text -> Long Text
		+	Int -> Number (Size set in design mode)
		+	The FDA's "Required" attribute was translated to Access's "Required" property, with "Not Null" set as "Required = Yes" and "Null" set as "Required = No".
		+
		+	Table Relationships:
		+	Table relationships were established based on common field names and logical connections, referencing the visual representations provided by the FDA.
		+
		+	Query Development:
		+	Queries were created to search for specific drugs based on various criteria such as drug names.

	*Results:		*Results:

@@ Line 98: / Line 98: @@
 ===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.)===
-DrugName
-HYDRODIURIL
+I couldn't complete this column because the data was outdated and deleted.
 ===What are the names of the drug products that are sponsored (sponsorname column) by MERCK?===