Question Two [40 Marks a. Using the Database structure in figure 1, create a database in Microsoft Access OR Microsoft SQL server and populate each table with at least fifteen (15) appropriate records. Then, you are required to design an appropriate user interface, connect it to the database, retrieve and display all CLIENT_TB records in a DataGridView control on the interface. [10 Marks/ b. Create functionalities for a user to be able to ADD new Records to the CLIENT_TB Table in the database, as well as Delete and Update Existing Records(using appropriate user interfaces). [10 Marks) c. Create a function in your program that will enable a user to search for a Client, and if the Client is found, the user can then select it to display details of the Client as well as the list of all the Appointments for that particular Client. [8 Marks/ d. Create a function in your program that will enable a user to book new appointment for Clients, by clicking on a button (Create Appointment) on the form in (c) above. Clicking on the button should open a new form with the Client ID already filled. Also, information on all Counselors must already be loaded in a Combobox on the new opened form for the user to choose from. Another button (Add), which is on the new form must be clicked, when the user has filled out the rest of the appointment field, to complete the process. [12 Marks/ Question Three [25 Marks] CG has decided to modify the software to make it possible for users to book and view their appointments online. Again it is decided that the ASP.NET should be the web programming language: a. Using the Database created in 2 (a), you are required to create a website/web App, design an appropriate webpage, connect it to the database, retrieve and display all Counselor records in a Grid View control on the Webpage. [12 Marks) b. Create a functionality in your web App that will enable a user to search for a Counselor, and if the Counselor is found, the user can then select it to display details of the Counselor as well as the list of all the Appointments for that counselor on a new webpage. [13 Marks/ Question Two [40 Marks a. Using the Database structure in figure 1, create a database in Microsoft Access OR Microsoft SQL server and populate each table with at least fifteen (15) appropriate records. Then, you are required to design an appropriate user interface, connect it to the database, retrieve and display all CLIENT_TB records in a DataGridView control on the interface. [10 Marks/ b. Create functionalities for a user to be able to ADD new Records to the CLIENT_TB Table in the database, as well as Delete and Update Existing Records(using appropriate user interfaces). [10 Marks) c. Create a function in your program that will enable a user to search for a Client, and if the Client is found, the user can then select it to display details of the Client as well as the list of all the Appointments for that particular Client. [8 Marks/ d. Create a function in your program that will enable a user to book new appointment for Clients, by clicking on a button (Create Appointment) on the form in (c) above. Clicking on the button should open a new form with the Client ID already filled. Also, information on all Counselors must already be loaded in a Combobox on the new opened form for the user to choose from. Another button (Add), which is on the new form must be clicked, when the user has filled out the rest of the appointment field, to complete the process. [12 Marks/ Question Three [25 Marks] CG has decided to modify the software to make it possible for users to book and view their appointments online. Again it is decided that the ASP.NET should be the web programming language: a. Using the Database created in 2 (a), you are required to create a website/web App, design an appropriate webpage, connect it to the database, retrieve and display all Counselor records in a Grid View control on the Webpage. [12 Marks) b. Create a functionality in your web App that will enable a user to search for a Counselor, and if the Counselor is found, the user can then select it to display details of the Counselor as well as the list of all the Appointments for that counselor on a new webpage. [13 Marks/