skill required == HTML, PHP, and MySQL
the system should be accessible and usable via the URL (a webserver)
The five tutors Alice, Bob, Segun, Bunmi and Ronke, want to make some of their books available to other people in their school.
The books are the following:
AUTHORS BOOK TITLES
Alice Ian Sommerville. Software Engineering (7th Edn) Addison Wesley (2004)
Alice G Booch, J Rumbaugh, and I Jacobson. The Unified Modelling Language User Guide. Addison Wesley, 1999.
Alice Algorithm Design, Michael T. Goodrich and Roberto Tamassia (John Wiley & Sons, Inc. 2002).
Bob Perdita Stevens with Rob Pooley: Using UML: Software Engineering with Objects and Components. Addison-Wesley (1999).
Bob Introduction to ALGORITHMS, TH Cormen, CE Leiserson, and RL Rivest, MIT Press/McGraw-Hill, 1989.
Segun Introduction to ALGORITHMS, TH Cormen, CE Leiserson, and RL Rivest, MIT Press/McGraw-Hill, 1989.
Segun R. Elmasri, and S.B. Navathe: Fundamentals of Database Systems. (Addison-Wesley most recent edition)
Segun H. Garcia-Molina, J. D. Ullman, and J. Widom: Database Systems: The Complete Book (Prentice Hall most recent edition)
and so on...
The total of books titles in above is twelve and authors are five
NOTE=> Bob and Segun offer same book in which case there are two copies of the book.
To keep track to whom a book has been borrowed/loaned, a web-based borrowing system is to be used. The system should allow a user to
• select the name of one of the 5 authors via a drop-down/pop-up list or selection menu
• select the book title of a book in the possession of that author via a separate drop-down/pop-up list or selection menu
• enter the name of the person who borrows the book via a text field
• enter the e-mail address of the person who borrows the book via another text field
Ideally, the user of the system is able to enter all this data via a single web page (not a sequence of two or more pages).
Also, the menus are populated with data from the mysql database.
On submission of this data, the user should be shown a confirmation whether the borrowing transaction has been successful or unsuccessful. A borrowing transaction should be successful if the selected author is still in the possession of the selected book, that is, the book has not already been loaned by the author to someone else.
A borrowing transaction must be unsuccessful if someone else has already borrowed the selected book from the selected author and it should then be possible to select a different book from the same or or one of the other authors (when doing so your system would ideally be programmed in such a way that there is no need to enter name and e-mail address again)
The system would ideally also help the user by only showing authors that still have books that can be borrowed and only titles of books that can still be borrowed.
To keep track of the books that are still available and books that have been borrowed, underlying the borrowing system must be a MySQL database storing for each author and each book title whether it is available or has been borrowed and for any borrowed book the name and e-mail address of the person who has borrowed it.
Additional requirements and comments:
• A user can borrow more than one book either of the same authors or different as long as book is availabe.
• There is the possibility that two users nearly simultaneously try to borrow the same book.
Depending on how you implement the interaction with the database, this could lead to a situation in which your system determines for both users that the book is still available and then records for both users that he/she has borrowed that book, with only the information on one of the users remaining in the database but both users receiving a confirmation that their borrowing transaction has been successful. This is obviously an incorrect behaviour by the library system and needs to be avoided.
The amount I am willing to pay is between £20 and £60.
13 freelancers are bidding on average £186 for this job