Access Database System Redesign

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.