Define a data warehouse. 

 2. Describe the differences between a database and a data warehouse. 

 3. List four different databases that can be used to build a data warehouse. What are the features of each? 

 

 4. Describe the purpose of a database design document. 

 5. Describe the strategy that you would use to confirm the database design of a data warehouse. Mention the sequence you would follow. 

 6. List the documents that might inform the database design 

 7. Describe potential clients for a data warehouse. 

 

 8. Describe the relationship between the organisation's knowledge management strategy and a data warehouse.

 

 9. Describe the relationship between the organisation's security plan and the data warehouse. Mention common security threats. 

 

 10. Describe the benefits to an organisation of a well managed data warehouse 

 11. Describe at least four information gathering methods that could be used to ensure that the data warehouse will meet the needs of users.

 12. Describe the communication skills required to liaise effectively with users and technical staff.

 13. Summarise the principles of effective user interface design.

 14. Describe the term 'big data' and state how it relates to data warehousing.