Btec

Business & Computing

Learner Name
Learner Registration No. Assessor Name
LEI13160876
Soory Abbassi
15/10/13
Hand-in Date
Submitted On
15/10/13
18/03/14

Qualification and Programme Number
Unit Number and Title
BTEC Extended Diploma In IT (QCF): Level 3
Unit 18: Database Design

Assignment Title
Assignment 1
No. 1 of 2
Whole or Part of Unit? Whole /Part
Grade for Whole Unit

Deadlines: If you do not meet the deadlines for handing in your assignments you may not have your work marked. This could result in you failing the course unless there are exceptional circumstances which must be explained to your tutor and agreed by the Curriculum Manager. Your work should be returned to you marked within 10 working days

Task or Assignment No. & Title
Criteria Targeted
Date Issued
Hand In Date
Resubmission Date(s) (if necessary)
Task 1
P1
15/10/13
22/10/13

Task 2
P2
9/10/13
12/11/13

Task 3
P3
19/11/13
10/12/13

Task 4
P4
17/12/13
24/12/13

Task 5
P5
07/01/14
14/01/14

Task 6
P6
21/01/14
28/01/14

Task 7
P7
04/02/14
11/02/14

Task 8
M2
18/02/14
25/02/14

Task 9
M3
04/03/14
11/03/14

Task 10
D1
11/03/14
18/03/14

Grading Criteria
Ref. No.
Grading Criteria
Assign. Or Task No.
Evidence/ Page No.
Feedback
Met?
Y/N
Assessor Sig./Date
P1
Explain the features of a relational database

1

P2
Design a relational database for a specified user need

2

P3
Create and populate a database

3

P4
Create features in data entry forms to ensure validity and integrity of data

4

P5
Perform queries using multiple tables and multiple criteria

5

P6
Include an advanced feature in a database

6

P7
Test a relational database.

7

M2
Import data from an external source

8

M3
Export data to an external source

9

D1
Discuss how potential errors in the design and