CASE ONE The Counselors Group (CG), a renowned Counseling service in Ghana manages their clients meetings based only on appointment. To book an appointment, the clients are required to place phone calls to the facility to reserve a slot to see an available Counselor. Upon receiving a call for appointment, the secretary based on the information provided by the client, must identify the appropriate/particular Counselor, his/her schedule and available slots, before proposing an available date and time to the client. With such a cumbersome process of operation, secretaries easily lose track of appointment, creating clashes and greatly inconveniencing clients and Counselor alike. Management realizing these operational challenges have started looking at ways to aid the effective management of these appointment. At the last management meeting, management took a firm decision to acquire a database system to improve their record keeping processes. Also, CG over the years has invested into Microsoft technologies and as such would like this system developed using Visual Basic .Net, with a Microsoft DBMS such as Access OR MS SQL server. Finally, it was decided that the connection string as well as other connection object must be coded manually (Hard coded). Thus, a Connection Wizard should NOT be used to create the connection to the database since it may restrict control over the program. The structure of the database is shown on figure 1. Use this case to answer the following questions. Page 2 of 6 CLIENT_TB earch Tables APPOINTMENT_TB 2 CLIENT_TB COUNSELOR_TB COUNSELOR_TB Y D_ID FirstName LastName DateOfBirth Gender Contact Number Department Email Arrival Departure Speciality APPOINTMENT_TB * Appointment_ID P.ID D_ID DateOfAppointment Time Details FirstName LastName DateOfBirth Age Gender Address Email Nationality Enrolled Date Figure 1. The structure of the CG database Question One (35 Marks] a. Create a class for the CLIENT_TB in case one and create member variables for any four(4) properties. [5 Marks) b. Create a property procedure to write values into and read values from TWO of the member variables created in (a) above. Be mindful to implements all necessary validations. [4 Marks] c. Create a property procedure to ONLY write values into one of the member variables created in (a) above. Be mindful to implements all necessary validations. [2 Marks] d. Create a property procedure to ONLY Read values from one of the member variables created in (a) above. Be mindful to implements all necessary validations. [2 Marks) e. Create a Method to calculate the number of years a person has been a Client with the Company using the enrolled date as the date the person became a client of the company. (5 Marks/ f. In the Click Event of a button that lies on Forml, create an instance of the Class created in (a) and assign values to the properties created in (b) and (c) using TextBoxes that are on Forml. [4 Marks] g. Using a Textbox control on forml, display the values assigned to the properties in (e) as well as the number of years in (e). [4 Marks) h. Create a constructor that will assign initial values to each property in (b), (c) and (d). (5 Marks] a Derived Class from the class in (a) Class. i. Create [4 Marks) CASE ONE The Counselors Group (CG), a renowned Counseling service in Ghana manages their clients meetings based only on appointment. To book an appointment, the clients are required to place phone calls to the facility to reserve a slot to see an available Counselor. Upon receiving a call for appointment, the secretary based on the information provided by the client, must identify the appropriate/particular Counselor, his/her schedule and available slots, before proposing an available date and time to the client. With such a cumbersome process of operation, secretaries easily lose track of appointment, creating clashes and greatly inconveniencing clients and Counselor alike. Management realizing these operational challenges have started looking at ways to aid the effective management of these appointment. At the last management meeting, management took a firm decision to acquire a database system to improve their record keeping processes. Also, CG over the years has invested into Microsoft technologies and as such would like this system developed using Visual Basic .Net, with a Microsoft DBMS such as Access OR MS SQL server. Finally, it was decided that the connection string as well as other connection object must be coded manually (Hard coded). Thus, a Connection Wizard should NOT be used to create the connection to the database since it may restrict control over the program. The structure of the database is shown on figure 1. Use this case to answer the following questions. Page 2 of 6 CLIENT_TB earch Tables APPOINTMENT_TB 2 CLIENT_TB COUNSELOR_TB COUNSELOR_TB Y D_ID FirstName LastName DateOfBirth Gender Contact Number Department Email Arrival Departure Speciality APPOINTMENT_TB * Appointment_ID P.ID D_ID DateOfAppointment Time Details FirstName LastName DateOfBirth Age Gender Address Email Nationality Enrolled Date Figure 1. The structure of the CG database Question One (35 Marks] a. Create a class for the CLIENT_TB in case one and create member variables for any four(4) properties. [5 Marks) b. Create a property procedure to write values into and read values from TWO of the member variables created in (a) above. Be mindful to implements all necessary validations. [4 Marks] c. Create a property procedure to ONLY write values into one of the member variables created in (a) above. Be mindful to implements all necessary validations. [2 Marks] d. Create a property procedure to ONLY Read values from one of the member variables created in (a) above. Be mindful to implements all necessary validations. [2 Marks) e. Create a Method to calculate the number of years a person has been a Client with the Company using the enrolled date as the date the person became a client of the company. (5 Marks/ f. In the Click Event of a button that lies on Forml, create an instance of the Class created in (a) and assign values to the properties created in (b) and (c) using TextBoxes that are on Forml. [4 Marks] g. Using a Textbox control on forml, display the values assigned to the properties in (e) as well as the number of years in (e). [4 Marks) h. Create a constructor that will assign initial values to each property in (b), (c) and (d). (5 Marks] a Derived Class from the class in (a) Class. i. Create [4 Marks)