Design a software using MS Access at back end and vb.net at front end on Flat allotment management system.
1. Create database using proper relationship in table for normalisation the database.
2. There should be at least the biodata of all applicant with full information of applicant Enter minimum 15 data entry in data base
3. Validations in front end
a. Data can be enter against customer bank account no. only
b. Every applicant should allotted a unique ID which will not editable.
c. Proper navigation with add delete edit and find a person by name, bank account no. or applicant ID.
d. If any person have less than Rs. 200000 in his bank account he cannot apply for flats.
e. In first draw 25% applicant will allotted randomly . after allotment these applicant’s can not participate in any draw
f. Age bar for application is between 20 to 55 years.
g. The applicant who allotted flats in first draw should be shown in main form separately in data grid.
h. Use list box to find any person with his ID.
i. Data entry text box should have proper validation. Like in name field no any numeric value should be accepted
4. Queries:
a. How many persons allotted flats during first draw.
b. How many persons rejected their loan form due to non-availability of fund in bank account
5. Reports:
a. Report of all persons applied for flats of age between 25 to 35 years
b. Report of all persons whose bank balance is more than 5 lakh.