Unit introduction
In order to produce information to support many business processes as well as our social lives, relational databases are widely used to manage and process data. From the smallest in-house systems to stock control systems for large online retailers, databases are repositories of information that are a significant part of organisational operating requirements. You will examine the structure of data and its origins, and how an efficient data design follows through to an effective and useful database.
You will examine a given scenario and develop an effective design solution to produce a database system. You will then test your solution to ensure that it works correctly.
Finally, you will evaluate each stage of the development process and the effectiveness of your database solution. To complete the assessment tasks within this unit, you will need to draw on your learning from across your programme. The skills you gain in this unit support progression to IT-related higher education courses and to employment in a role that requires computing-related expertise.
Assessment outcomes
AO1 Demonstrate knowledge of database development terminology, standards, concepts and processes
AO2 Apply knowledge and understanding of database development terminology, standards, concepts and processes to create a software product to meet a client brief
AO3 Analyse information about database problems and data from test results to optimise the performance of a database solution
AO4 Evaluate evidence to make informed judgements about the success of a database’s design and performance
AO5 Be able to develop a database solution to meet a client brief with appropriate justification