Use C# and Microsoft SQL server to design a library system which allows the following >>>>
the system should allow members to borrow books. penalty charge is R5 per day. the loan depends on the status of a member: member ranks platinum 15days gold 10 days and silver 5 days. members can make reservations when the book in question is not available. when the book is availble member will be informed through FIFO concept ie the system be able to send emails to members informing them that the book which they reserved is now available. members who owe the library can not borrow a book, make a reservation nor deregister from the system. minimum basic operations : issue out a book , return a book to the library, issue charges on overdue books, notify users when the reserved book is available, promote members if not yet reached the executive membership and if the have hired books 30 times or more and they do not have penalties, modify the charge rate for penalties, carry out back up and recovery procedures, implement database mirroring, register members, register book copies, register book details, register borrowed details.
minimum reports required : list of members with overdue books, list of members who have borrowed books ten timess or more, serch a book based on ISBN, book tittle or bookcopy id. the more operations that you implent the more marks i get ..... its an assignment
Đã trao cho:
17 freelancer đang chào giá trung bình $179 cho công việc này
Hi, This is a great opportunity for me and I would be much obliged to receive this offer from you. Kindly check private message for more details. Regards, R. Krishna Prasadh