Create a website with database for a book loan system.
1) Consists of admin and member pages. Admin is able to see all members info and book loans and add new admins and members. Members are able to update personal info and change password.
2) The ability to register a new member with login functions.
3) Daily email and sms reminder to be sent to the member 3 days before the loan due date
4)Each member is only allowed to borrow a max of 3 books and can only renew the loan of each book once.
5) Loan duration is a standard 4 weeks and members are able to view their loan history and book information
6) All data and tables is to be stored in microsoft sql server 2008 R2.
7)Also admins must have the ability to maintain the book database and update loans and return of books .
8) visual studio 2010 and c# programming must be used, not VB