sql asp.net C#

Project Description: Your first task is to migrate this database dump into your ASP .NET solution. (You may choose either an online or offline migration approach.) It also implies that you should consider verifying the validity of data entries. The third step is to allocate eligible employees into appropriate membership classes according to the business logic. Then, you should create a membership database consisting of at least the following fields: • MembershipId (integer, primary key, not null) – a new entry that you have to generate. • FirstName (string, not null) – contents copied from the salary database. • LastName (string, not null) – contents copied from the salary database. • MembershipClass (string, not null) – one of the three possible values “gold”, “silver” or “regular”. • VerificationCode (string, not null) – a new entry that stores information which can be used to validate employee’s date-of-birth and salary. (Note: Your database should not store date-of-birth, salary and gender information of any employee in plain text.) To manage the membership, you will need to create an ASP .NET website with one web form. On this web form (e.g. “[login to view URL]”), there should be at least the following controls: • SQL database controls for displaying membership information including MembershipId, names, and MembershipClass and so on. • “TextBox” controls for updating member’s MembershipId, names, and MembershipClass and so on. • “Label” controls to indicate error messages. • A CSS component. • And a few “Button” controls to enable “add member”, “remove member”, “update member” and “search member” functionalities. In the C# file associated with the form (e.g., “[login to view URL]”), you should write a piece of C# code to implement the following actions: 1. Implement “add member”, “remove member” and “update member” functionalities to membership database. 2. Implement “search member” functionalities according to given MembershipId, FirstName and LastName. 3. Implement a “verify member” functionality which validates a given member’s MembershipClass based on his/her salary and age by comparing to a corresponding verification code. Additionally, in order to demonstrate the correctness of your implementation of the business rule, you should include a salary histogram of all your members, an age histogram of all members, and a list of the members who: • Earn average salary of gold class. • Earn the highest salary of silver class. • Earn the lowest salary of regular class. Here is all the files you need for the project. Thanks [login to view URL] Skills required: ASP, SQL, Website Design