ASSIGNMENT 8
PORTFOLIO 2026
UNIQUE NO:
DUE DATE:
,CT3611 - ADVANCED GRAPHICAL USER INTERFACE
ASSESSMENT 8 PORTFOLIO 2026
OPTION 4: ACCOUNTING MANAGEMENT SYSTEM
1. Database design
The database will contain two tables:
Table 1: Departments
Field Data type Description
dept_name Short Text Name of department/team
expense_category Short Text Category of expense
transactions_per_month Number Number of monthly transactions
average_cost_per_transaction Currency/Double Average cost per transaction
Table 2: CorporateAccounts
Field Data type Description
expense_category Short Text Expense category
ledger_code Short Text General ledger code
tax_bracket Short Text Exempt, Standard or Capital
account_name Short Text Corporate account
total_invoices Number Total invoices processed
total_expenditure Currency/Double Historical expenditure
The common field between the two tables is expense_category.
2. Dummy data