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
- Understand the features of relational databases
- Be able to design, create and populate a relational database
- Be able to test a relational database
Assessments
-
October 23rd
Assessment 1: Database Design
-
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
|