The database will consolidate the Mineral Profits data currently stored in various Excel spreadsheets. The tables in the database should be designed so that it maintains the relationships specified in the spreadsheets.
? A data input interface will be developed so that Administrators of the database can easily update or add new data.
? At the beginning of each year, the Data of the previous year should be archived and a set of tables created for the new year.? The new tables should have categories (and sub-categories) based on the data of the previous year.
? Regular backups of the database are a priority and should be taken into consideration when designing the system.
PLATFORM - MS EXCEL or Web based
Please see attachment