Unit 18 Database Design Assignment Brief 2015

Learner’s Comments ( What went well, What could you improve)

Assessor’s name:

Assessor’s signature:

Date:

Learner’s Declaration:
I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.

Signed: ........................................................................................... Date: ................................

Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback (dated)

LO1

Understand the features of relational databases
P1

Explain the features of a relational database

P2
Design a relational database for a specified user need

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

LO2

Be able to design, create and populate a relational database.
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

M2
Import data from an external source

M3
Export data to an external source

M4
Implement an automated function

Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback

LO3

Be able to test a relational database
P7

Test a relational database

D2
Evaluate a database against the specified user need

Unit 18 - Database Design -