Question: There is a need to develop a software for tracking library loan records. Library barrowers may barrow library items once they have registered to the

There is a need to develop a software for tracking library loan records. Library barrowers may barrow library items once they have registered to the system by providing their name. address and phone number. After registration the borrower will receive a library card that contains the card number and card expiration date. Aside from books each borrower may borrow, magazines, compact disc and audio tapes. A library must manage each copies of library item based on the following data: Author. title and replacement cost which is general for all library items, ISBN for books, issue date for magazines, series number for compact disc and tack number for audio. For example. a library may have live copies of a book about Java programming with different ISBN. Each library item is being categorized according to their type that contains, standard check-out period, maximum number of renewals and line per day overdue and type name. For example. algorithm book's maybe checked-out for a month. while for programming books may only be checked-out for two weeks. General Science books‘ can be renewed once: 32991;} with pending request may not be renewed based on the request date. The system also records the check-out information that contains the check-out date and fine paid by the customer and the item that was checked-out that contains the due date item fine and return date, during the check-out period borrowers may renew their the borrowed books.

Step by Step Solution

3.51 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The question is incomplete because it does not clearly specify wh... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!