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:


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.

Beceriler: HTML, MySQL, PHP

Daha fazlasını görün: borrow book system php mysql, web page language, web interaction design, web design interaction, web design books, web ce, web based language, web algorithms, uml algorithm, the five r, text algorithms, molina, list of books by author, lead selection, john wiley and sons, john wiley, john stevens, john hill, introduction to web page design, introduction of algorithms, introduction of algorithm, introduction algorithms, incorrect from address, html 5 edition+, how to make sequence

İşveren Hakkında:
( 0 değerlendirme ) United Kingdom

Proje NO: #4426566

13 freelancers are bidding on average £186 for this job


IT Engineer with 13 years of experience (2000 - 2013), I have enough skills to complete this project. Please check inside my profile page - here at [url removed, login to view] - what my former Employers have said about me. I a Daha fazlası

in 5 gün içinde350£ GBP
(237 Değerlendirme)

Hi, We have a dedicated team with 7 years of experience on PHP/MySQL, Ajax, Jquery, HTML, CSS, Javascript, Java/J2EE. Also having much experience on framework and CMS like 1) CakePHP 2) CodeIgniter 3) Zendframew Daha fazlası

in 7 gün içinde250£ GBP
(127 Değerlendirme)

Ready to [url removed, login to view] have done the same in our school management software

in 10 gün içinde262£ GBP
(15 Değerlendirme)

Bidding on this project As requested..

in 3 gün içinde59£ GBP
(271 Değerlendirme)

Hello We have gone through your requirements ,we can help you .Please check PM for further details .

in 7 gün içinde226£ GBP
(44 Değerlendirme)

Hello, Greetings!! iPhone/iPad/Android/php expert ready to start immediately, Please check PM for detail information. Thanks

in 10 gün içinde262£ GBP
(5 Değerlendirme)

We may start the project. Highly trained coder with company, so if requested an invoice will be emailed.

in 14 gün içinde250£ GBP
(10 Değerlendirme)

hi, i can do this for you in 24hours

in 0 gün içinde60£ GBP
(27 Değerlendirme)

Hi , Ready To Work.

in 20 gün içinde210£ GBP
(5 Değerlendirme)

Hi Pls check PM for the demo details on web library system. Thanks Ken

in 30 gün içinde206£ GBP
(15 Değerlendirme)

Hi, I'm software engineer with good experience in php, sql, javascript. I can help you and finish your task perfectly as you want, so don't hesitate to contact with me ..thank you...

in 3 gün içinde165£ GBP
(0 Değerlendirme)

Reliable and Quality work provider. Understood all your requirements. Just have a look at PM. Regards, Faisal

in 3 gün içinde59£ GBP
(0 Değerlendirme)

Hi. hope you choose me. I have experienced in create this kind of system

in 3 gün içinde55£ GBP
(0 Değerlendirme)