Higher Nationals in Computing & Systems Development

Overview - Unit 17: Database Design Concepts

To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as well as the practical skills to translate that understanding into the design and creation of complex databases

Unit Specification » Unit Questionnaire »

Learning Outcomes

  1. Understand databases and data management systems
  2. Understand database design techniques
  3. Be able to design, create and document databases

Assessments

  1. 9th Mar 2017 Assessment A17.1: Database Systems Final
  2. 30th Mar 2017 Assessment A17.2: Database Design Final

Assessment Criteria

  1. Understand databases and data management systems
    1. analyse the key issues and application of databases within organisational environments
    2. critically evaluate the features and advantages of database management systems
  2. Understand database design techniques
    1. analyse a database developmental methodology
    2. discuss entity-relationship modelling and normalisation
  3. Be able to design, create and document databases
    1. apply the database developmental cycle to a given data set
    2. design a fully functional database (containing at least four inter-relational tables) including user interface
    3. evaluate the effectiveness of the database solution and suggest methods of improvement
    4. provide supporting user and technical documentation

Lesson Index