Using the provided script for Golf-A-Thon in dbSQL1 in SQL Server Create a program to select a golfer and an event(year) on separate forms. The program should have a main form with buttons or a menu so the user can Manage Golfers or Manage Events. The golfer form will populate a combo box with the Last Name of the golfers and the Event form will populate the Year for an event. Once a golfer is selected from the list, provide the remaining data for the golfer record in text boxes on the form. The user should also be able to update all of the golfer information on this form. On the events form nothing needs to occur other than selecting an Event from the combo box. make the program using Visual Studio.

IS NOT NULL DROP TABLET IF OBJECT_ID TagffecExetxeacs ) IF OBJECT_ID IGRAfeceveotysacs IF OBJECT IDC_Teventyears' ) IF OBJECT_IDC Testfers' ) IS NOT NULL DROP TABLE IS NOT NULL DROP TABLE CREATE TABLE TEXSatyears. intEventyearID INTEGER NOT NULL intEventyear INTEGER NOT NULL CONSTRAINT TEXEntYears.PK PRIMARY KEY ( inteventeearts ) CREATE TABLE TGOLFCs. intGolferID INTEGER NOT NULL stcfirstName VARCHAR(50) NOT NULL ustcLastName VARCHAR(50) NOT NULL stcstreetAddress VARCHAR(50) NOT NULL stcsity VARCHAR(50) NOT NULL stcstate VARCHAR(50) NOT NULL stcZIR VARCHAR(50) NOT NULL stcpboneNumber VARCHAR(50) NOT NULL strEmail VARCHAR(50) NOT NULL intshirtsizeID INTEGER NOT NULL intGender ID INTEGER NOT NULL CONSTRAINT JGolfecs...K. PRIMARY KEY ( intGolfecin ) CREATE TABLE JGolfecEventyears intGolfecEventyearID INTEGER NOT NULL intGolf CID INTEGER NOT NULL intEventyearID INTEGER NOT NULL CONSTRAINT JGAfecEventyears. HQ UNIQUE (intsolferir, intexentYeacIR. ) CONSTRAINT JGolfecEventyears. RK PRIMARY KEY ( intGolfecEventxeacin) IS NOT NULL DROP TABLET IF OBJECT_ID TagffecExetxeacs ) IF OBJECT_ID IGRAfeceveotysacs IF OBJECT IDC_Teventyears' ) IF OBJECT_IDC Testfers' ) IS NOT NULL DROP TABLE IS NOT NULL DROP TABLE CREATE TABLE TEXSatyears. intEventyearID INTEGER NOT NULL intEventyear INTEGER NOT NULL CONSTRAINT TEXEntYears.PK PRIMARY KEY ( inteventeearts ) CREATE TABLE TGOLFCs. intGolferID INTEGER NOT NULL stcfirstName VARCHAR(50) NOT NULL ustcLastName VARCHAR(50) NOT NULL stcstreetAddress VARCHAR(50) NOT NULL stcsity VARCHAR(50) NOT NULL stcstate VARCHAR(50) NOT NULL stcZIR VARCHAR(50) NOT NULL stcpboneNumber VARCHAR(50) NOT NULL strEmail VARCHAR(50) NOT NULL intshirtsizeID INTEGER NOT NULL intGender ID INTEGER NOT NULL CONSTRAINT JGolfecs...K. PRIMARY KEY ( intGolfecin ) CREATE TABLE JGolfecEventyears intGolfecEventyearID INTEGER NOT NULL intGolf CID INTEGER NOT NULL intEventyearID INTEGER NOT NULL CONSTRAINT JGAfecEventyears. HQ UNIQUE (intsolferir, intexentYeacIR. ) CONSTRAINT JGolfecEventyears. RK PRIMARY KEY ( intGolfecEventxeacin)