Assignment #4 Requirements – Contact Info with DatabaseStep 1: Use the following. (5 points)Purpose: Store Contac

[answerhappygod]

Assignment #4 Requirements – Contact Info with DatabaseStep 1: Use the following. (5 points)Purpose: Store Contact Info within DatabaseInput: Enter Contact Info (GroupBox) Type (ComboBox), ContactID, FirstName, MiddleName, LastName, Telephone, Extension, Email Address (TextBox)Process: File/Open (Button) open database and retrieve records, display one record at a time. Edit/Add (Button) to add the Contact to the database. Search allows enter Contact ID, open Display Info if found or MessageBox if not.Output: Display Contact Info (GroupBox) ContactID, FirstName, MiddleName, LastName, Type, Telephone, Extension, Email Address (Label)Step 2: Create forms, controls and dialogs, using naming standards. (5 points) Step 3: Design the following using .NET and SQL server. (5 points)a. The solution should contain separate projects for Presentation, Business andData logic:b. The Contact database should be built with Contact table that contains thenecessary fields and data types, Contact ID is the primary key. Step 4: Code DisplayContactInfo Form logic using VB.NET syntax. (5 points)a. The Contact Info will be initially empty, but on Open will display the first Contact record from the Contact table.b. The Open Button on click should instantiate data object in the data layer, which will open the database using ADO.NET and TableAdapter, then set screen values based on the Datasource.c. The Next Record should display the next data record.d. The Previous Record should display the previous data record.e. The Exit Button on click will close the database and end the application. Step 5: Code EnterContactInfo Form logic using VB.NETsyntax. (5 points)a. The Contact Info will be initially empty, except ComboBox, which should be loaded with specified values.b. The user should be able to enter all data values based on data types.c. Save Button on Click should add all values to the Contact, then clear the values from TextBoxes.d. Clear Button on Click should clear all values from the TextBoxes.e. Close Button on Click should close/hide form without saving data. Step 6: Testing should ensure data saved and retrieved from database. (5 points)The program should not abnormally terminate. The exceptions, including those related to database should be handled. Testing should ensure that the save button click events handle when data populated or not.