Develop a stand alone system with connection to a database using Visual Studio in java.

The scenario of the system is as follows:

You have a company that deals with wedding. Your client needs to keep abreast of the invitees to a wedding. As it is the school holidays, there are many weddings and so does the invitations. Your clients need you to keep track of the invitations, therefore you need to develop and administer the

invitees. You need to prepare a system done through a stand alone system on the invitations. The system should be able to do the following:

$$ add invitees and place them to a table of ten per table

$$ update information about the invitees including changing the table placement

$-$ the update can be done individually or in bulk $($multiple update$)$

$$ uninvite an invitee or in bulk $($multiple deletions$)$

$$ view all all invitees together with which table he$/$she is allocated to

$$ search an invitee by name $($in full or in part$)$ to which table he$/$she is allocated to

$$ search a table to know who are the invitees allocated to that table

The coding should include the techniques including:

$$ using data validation to ensure data integrity

$$ break up the codes in both as subprocedures and functions

$$ use comments in your codes where necessary