Timber Ltd. specializes in manufacturing wooden furniture for the past 20 years. Timber Ltd. have been using a spreadsheet application as a file system to record customer details, orders, products and supplier details. Numerous errors have resulted especially when new items are added, deleted or updated. Timber Ltd. is considering seeking the services of a database designer to solve their current file problems.

QUESTION 1 Timber Ltd. have been using an excel spreadsheet to record their company details. List and explain in detail any FIVE (5) issues with using excel as a database.

QUESTION 2 Timber Ltd. is seeking the services of a database programmer as a solution to the problems they are experiencing with the current method of data capturing and retrieving information. In your capacity as a database programmer, explain the concept of a database to management of Timber Ltd. and highlight the components of a database.