Access Database System Redesign
$100-500 USD
Paid on delivery
A redesigned database structure, based on relational design principles (see schematic), including the placing of transaction data on a single transaction table. Currently, numerous tables in the system appear to contain transaction data eg. Interest calculations.
*? Code re-write as required to utilise the new database structure, ensuring existingn functionality is retained. The code re-write task should adhere to standard good design principles including:
*? structured, modular design
*? consistent variable/field/table column naming conventions (Hungarian notation preferred)
*? Meaningful, quality comments ??" in English.
*? In particular, great care is required with all interest calculations. Normal use of the new system should provide results that match those on the attached spreadsheet's expected results.
*? Repayments for any amount may occur at any time during the life of the loan, and must be processed and reported correctly.
*? The functionality of the system is adequate and does not require redesign, apart from minor changes that are the result of other work done (see next point)
## Deliverables
Please see the x2 attached documents in the zip file for further instructions and details. We will be following the brief completely.
Project ID: #2876987