At first I wasn't familiar with how the data was formatted in application.txt so I wasn't sure what variables to include in the tables, but after looking at the top of the text document, I found out the variables are: ApplNo, ApplType, SponsorApplicant, MostRecentLabelAvailableFlag, CurrentPatentFlag, ActionType, Chemical_Type, Ther_Potential, and Orphan_Code.  It appears the data types are: int primary key, varchar, varchar, boolean, boolean, varchar, int, varchar, and varchar respectively.  So with this information it is now pretty easy to make a table for application, see questions below.  Next I needed to figure out the variables for product.txt.  Opening the file it is easy to see the names for each column: ApplNo, ProductNo, Form, Dosage, ProductMktStatus, TECode, ReferenceDrug, drugname, activeingred.  Based on the values of data in each individual column I would say that the data types are: int, int, varchar, varchar, varchar, varchar, int, varchar, and varchar respectively.  Again, from this info it is easy to make a table for product.txt.

At first I wasn't familiar with how the data was formatted in application.txt so I wasn't sure what variables to include in the tables, but after looking at the top of the text document, I found out the variables are: ApplNo, ApplType, SponsorApplicant, MostRecentLabelAvailableFlag, CurrentPatentFlag, ActionType, Chemical_Type, Ther_Potential, and Orphan_Code.  It appears the data types are: int primary key, varchar, varchar, boolean, boolean, varchar, int, varchar, and varchar respectively.  So with this information it is now pretty easy to make a table for application, see questions below.  Next I needed to figure out the variables for product.txt.  Opening the file it is easy to see the names for each column: ApplNo, ProductNo, Form, Dosage, ProductMktStatus, TECode, ReferenceDrug, drugname, activeingred.  Based on the values of data in each individual column I would say that the data types are: int, int, varchar, varchar, varchar, varchar, int, varchar, and varchar respectively.  Again, from this info it is easy to make a table for product.txt.