Extended National Diploma in IT

Overview - Unit 18: Database Design

This unit aims to enable learners to develop the skills and understanding required to design, (using CASE tools such as Visual Paradigm 14.1 ) develop and test (using Microsoft Access 2016 ) entity-relational databases

Unit Specification »

Learning Outcomes

  1. Understand the features of relational databases
  2. Be able to design, create and populate a relational database
  3. Be able to test a relational database

Assessments

  1. October 23rd Assessment 1: Database Design
  2. November 27th Assessment 2: Database Build &Test

Assessment Criteria

P1: explain the features of a relational database P2: design a relational database for a specified user need
P3: create and populate a database P4: create features in data entry forms to ensure validity and integrity of data
P5: perform queries using multiple tables and multiple criteria P6: include an advanced feature in a database design
P7: test a relational database

Grading Criteria

M1: explain referential integrity and the purpose of primary keys in building the relationships between tables D1: discuss how potential errors in the design and construction of a database can be avoided
M2: import data from an external source M3: export data to an external source
M4: implement an automated function D2: evaluate a database against the specified user need

Week Index