31253: IT - Database Programming - University Of Technology Sydney - The Smartcard Financial Settlement System - Computer Science Assessment Answer

Subject Code: 31253

Computer Science Assessment Answer

Assignment Task: 31253 The Smartcard Financial Settlement System Introduction For the Assignment for Database Programming and Administration, you are required to write a Financial Settlement System (FSS) for a Smartcard Transaction Centre. The Deliverables for the Assignment are structured in a way to enable you to achieve a mark that is related to the amount of work that you will contribute to and the level of knowledge that you have attained. The detailed marking structure can be found at the rear of the document. Overview For some time now there has been a trial deployment of a Smartcard System in various locations throughout the country. A number of different types of Smartcard terminals have been deployed at selected sites. The types of terminals include Parking Meters, Payphones, various Vending machines and ticketing machines at selected railway stations. A number of Smartcard enabled terminals have also been placed in selected retail outlets like Newsagents and University canteens enabling the holders of the Smart cards to pay for their purchases using these cards. The term electronic cash is often used when talking about Smartcard transactions; however, the electronic cash needs to be converted to real cash so that the merchants, accepting the cards as payment, can be reimbursed. During the trial phase, the merchants were reimbursed manually, once a week. The settlement amount calculations have been done by the staff in our IT department and the merchants were sent a cheque for the amount of the settlement. During the initial trial phase, the merchants were not charged a fee on the Smartcard transactions. The Smartcard System is moving into the next phase of deployment. The number of merchants will be increased and there is a requirement to automate the Settlement process. The payment to the Merchants will be done via direct credit into their nominated bank accounts and is to be done daily. Each month the merchants will be charged a fee for the use of the Smartcard. The fee to be charged will be a percentage of the total transactions for the month. The actual amount is yet to be negotiated and it will be uniform for every transaction. The fee collection will be done via direct debit from the merchant bank account. The merchant will also be sent a statement showing the money banked and the fees charged for the month. NOTE: that the Monthly Settlement is not part of the Assignment. It is here only to help in understanding the system. Your task is to write the application for the Smartcard Financial Settlement System. You are required to only create the daily settlement system and associated report. The application is to run in the Oracle Database and is to be written using the PL*Sql language.

This Computer Science Assessment has been solved by our Computer Science experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.