doreen2002 / movielendingapp Goto Github PK

A program in python menu driven that connects to sqlite database that and has the following option 1. Lend movie: this options will allow the user to issue out a movie to a client and record the details and set status to ‘Pending’ 2. View Pending Lending: If someone selects this option the program should show all lending records that are still pending 3. View Canceled Transactions: If someone selects this option the program should show all lending records that have been canceled. If there is none, the program shows a NO TRANSACTIONS message 4. View Returned Transactions: If someone selects this option the program should show all lending records that are have been returned. If there is none, the program shows a NO TRANSACTIONS message 5. Return a movie: on this option, the programs selects a list of all pending transactions, the user selects one to return, then the program update the selected transaction to RETURNED 6. Cancel Transaction: on this option, the programs selects a list of all pending transactions, the user selects one to cancel, then the program update the selected transaction to CANCELED 7. View Summary: on this option the program shows the number of transactions pending, canceled and returned. 8. View earning: Given that for each movie lending transaction returned, a K25.54 is earned. The program must on this option compute the amount earned and display it on the screen.