Data Analysis and Design

LO 1 Understand data models and Database technology

1.1 Provide evidence to support an understanding of different data models. Compare and contrast different data model structures and examine their contribution to database development

1.2 Examine case material that focuses on developments such as data mining and data warehousing

1.3 Analyse the different approaches to database design

LO 2 Design a relational database to meet user requirements

2.1 Apply data analysis and design techniques to develop a fully relational database with minimum of six tables
   
2.2 Verify that a design meets user requirements and provide justification of the database design

2.3 Use a range of database tools and techniques to demonstrate a more advanced level of understanding and application       

LO 3 Use manipulation and query tools and techniques

3.1 Incorporate a query language/languages into the database design
 
3.2 Use a range of visual tools to enhance the database design

3.3 Demonstrate the extraction of meaningful data through the use of query tools

LO 4 Implement and test database design

4.1 Provide documentation to support the database implementation

4.2 Demonstrate ways in which the database has considered the areas of verification and validation

4.3 Evaluate a range of testing techniques and apply one to your own database design.