Visual programming project

The Sports Club at Hebron University would like to create an office program that will help it manage members$$ subscriptions and financial payments for subscriptions. The club provides the following services:

$$A swimming pool for $500$ shekels per year

$$Fitness gym for $500$ shekels per year

$$Sauna room for $300$ shekels per year

$$Steam room for $300$ shekels per year

$$Massage room for $500$ shekels per year

Through this application, the club wishes to carry out the following operations:

$1.$ Managing personal data of employees in the club $($add$/$edit$/$delete$/$review an employee file$)$

$2.$ Managing the personal data of customers participating in the club $($add$/$edit$/$delete$/$review a customer file$)$

$3.$ Managing customer subscriptions includes $($creating a new subscription, canceling a subscription$),$ as the club operates on an annual subscription policy $($that is$,$ the subscription period for the customer is one year, renewable by creating a new subscription for the customer$),$ and the total value of the subscription is the sum of the sum of the amounts of services that he desires. The customer obtains it during a specific subscription $($where the subscription may include all or some services$)$

$4.$ Managing financial payments from customers $($recording a payment for a customer subscription$),$ where the customer is required to pay the total subscription installment all at once.

$5.$ Managing financial payments to the customer $($recording the return of an amount to the customer$)$ in the event that the customer wishes to cancel his subscription before the end of the subscription $($a portion of the total installment value is returned, determined by the person who records this process$)$

$6.$ View a report of all active subscriptions $($not expired yet$).$

$7.$ Display a report on subscriptions for which no financial payment from the customer has been recorded yet.

$8.$ Display a report on the number of subscriptions created during a specific year and the total premiums for these subscriptions.

Based on the description of the system above, derive the necessary tables for the system and then do the following:

$1.$ Create the necessary database via SQL server.

$2.$ Create an elaborate desktop application linked to the database you built to provide all of the above functions.

$3.$ Submit a zip file containing the database files.

$$Project implementation steps that are recommended to be followed:

$$Analyze and design the necessary database based on the system description above.

$$Designing the necessary screens for each of the above required processes with the best specifications, while writing codes to control user inputs on data entry forms.

$$Building the database via SQL server.

$$Writing the necessary codes to link various system operations to the database system.