You are going to make four scripts. The first will be named FarmandRanch.sql and will work from your tables in the previ

[answerhappygod]

You are going to make four scripts. The first will benamed FarmandRanch.sql and will work from your tables in theprevious homework. Look carefully at the data in the Excel file andrevise your data types to fit. AgencyID is an identity column. If acolumn of text data is uniformly one size then use CHAR instead ofVARCHAR. Create the proper Excel statement to make your insertstatements. Watch for NULL values, text with apostrophes, and Exceldates. You can do all these with just SUBSTITUTE and sometimes IF.This script must have your USE statement for your database,followed by your DROP statement, CREATE statements, then INSERTstatements.