All the requirements are mentioned in the attached files.

if you have any question please let me know