all the requirements are inside attached file.application is currently running without an error. all the database tables are done in microsoft sql and web interfaces are done in visual studio. Here is what needs to be done.1. make changes according as described inside attached file. I have included pics + detailed explanation.2. tables in database need to be remade so they can be in BCNF. I included sample.All work must be done according to direction and final version should run without an error. Incomplete or non working application won’t be accepted.