==Questions to Answer==

==Questions to Answer==

===DDL (create table) statements===

===DDL (create table) statements===

* create table Applicationfile(ApplNo int, ApplType varchar, SponsorApplicant varchar, MostRecentLabelAvailableFlag boolean, CurrentPatentFlag boolean, ActionType varchar, Chemical_Type int, Ther_Potential varchar, Orphan_Code varchar)

* create table applicationfile(ApplNo int primary key, ApplType varchar, SponsorApplicant varchar, MostRecentLabelAvailableFlag boolean, CurrentPatentFlag boolean, ActionType varchar, Chemical_Type int, Ther_Potential varchar, Orphan_Code varchar)

* create table Productfile (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus varchar, TECode varchar, ReferenceDrug int, drugname varchar, activeingred varchar)

* create table Productfile (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus varchar, TECode varchar, ReferenceDrug int, drugname varchar, activeingred varchar)

===sed command sequences===

===sed command sequences===

#  Using the command line, how can you determine the number of records in each file? Provide the command.

#  Using the command line, how can you determine the number of records in each file? Provide the command.

#* For application:  

#* For application:  

wc application.txt

#**wc application.txt

#** Contains 19747 rows, so 19746 have data

#** Contains 19747 rows, so 19746 have data

#* For Product:  

#* For Product:  

wc product.txt

#**wc product.txt

#** Contains 32771 rows, so 32770 have data

#** Contains 32771 rows, so 32770 have data

#Using SQL, how can you determine the number of records in the table corresponding to the file? Provide the SQL select statement.

#Using SQL, how can you determine the number of records in the table corresponding to the file? Provide the SQL select statement.

#* For applicationfile:

#* For applicationfile:

select count (*) from applicationfile

#**select count (*) from applicationfile

#** Has 19746 entries (deleted first row of data)

#** Has 19746 entries (deleted first row of data)

#* For Productfile:

#* For Productfile:

select count (*) from Productfile

#**select count (*) from Productfile

#** Has 32770 entries (deleted first row of data)

#** Has 32770 entries (deleted first row of data)

# In your database, are these numbers the same or different? Explain why you think so.

# In your database, are these numbers the same or different? Explain why you think so.

# 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?

select drugname from Productfile where form = 'INJECTABLE;INTRAVENOUS, SUBCUTANEOUS'

#*select drugname from Productfile where form = 'INJECTABLE;INTRAVENOUS, SUBCUTANEOUS'

#* LOVENOX, VELCADE, VIDAZA, ENOXAPARIN SODIUM

#* LOVENOX, VELCADE, VIDAZA, ENOXAPARIN SODIUM

# What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?

# What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?

select drugname from Productfile where activeingred = 'ATROPINE'

#*select drugname from Productfile where activeingred = 'ATROPINE'

#* ATROPEN, ATROPINE

#* ATROPEN, ATROPINE

# In what forms and dosages can the drug product named BENADRYL be administered?

# In what forms and dosages can the drug product named BENADRYL be administered?