Assignment front sheet
Criteria To achieve the criteria the evidence must show that Page
Task no. Evidence
reference the student is able to: no
Design
P2 design a relational database for a specified user need Task 1 documentation
P3 create and populate a database Task 2 Database
create features in data entry forms to ensure validity and integrity Task 2
P4 Entry forms
of data
Task 3 At least 3
P5 perform queries using multiple tables and multiple criteria
Queries
Task 2
M2 import data from an external source Imported data
Learner name Assessor Name
Omit Ali Nas Akhter
Date issued Hand in deadline Submitted on
15/03/2021 02/04/2021
Resubmission (out) (if applicable) Resubmission (in) Lead IV authorisation
NZG
Qualification Unit number and title
Level 3 BTEC National Subsidiary Diploma in IT Unit 18 – Database design
Assignment title 18.2 Designing, creating and populating a relational database
Assignment brief
Scenario
The next part of your teaching practice is to provide an example of a working relational database. You will
have to provide several examples of evidence showing the processes from design to populating your
database.
For the purpose of this assignment you can choose either
an example database of a travel company arranging everything from Grand Prix tickets to
hotel bookings for a motor racing F1 fan
OR an example database for a local gymnasium/health club with membership details and records of
all activities/facilities used
You will have to provide data to be used in a mail merge letter to send to either the motor racing
fan or the member of the health club.
Task 1 – P2
Considering the information you provided for the game in Assignment 18.1 decide what
entities you intend to implement and normalise for your chosen database example. You
are expected to need five related entities.
Document the relationships, table structures, fields and properties.
Check with your tutor and get this signed off before proceeding to the next task. Modify
as necessary and implement your design.
Task 2
Using the information provided, design and implement suitable data entry forms for the
capturing of the information incorporating features to ensure the validity and integrity of
data.
You must include at least three of the following techniques within the set of data entry
forms:
o Validation routine
o Verification routine
o Input masking
o Check for completeness
o Visual prompts
o Data consistency
o Check for data redundancy
, Drop-down/combo boxes. P3, P4
Enter sufficient data into the system. At least some of the data should be imported
from an external source that will be provided for you. M2
Task 3-P5
Devise at least 3 queries that respond to the requirements identified using multiple tables and
multiple criteria.
Sources of information: Blackboard (BTEC IT Level 3/Course Materials), Teacher hand-outs,
BTEC National Information Technology Level 3 Course Manual, Internet Resources, YouTube Videos.
Learner & Assessor feedback and declaration
Gradin Achieved?
Assessor Feedback
g Yes/No
criteri
P2
P3
P4
P5
M2
Learner feedback
Learner declaration
I certify that the work submitted for this assignment is my own and research sources are fully
acknowledged
OR by submitting on Turnitin you agree to the above statement.
Learner signature: Date:
Assessor declaration
I certify that the evidence submitted for this assignment is the learner’s own. The learner has
clearly referenced any sources used in the work. I understand that false declaration is a form of
malpractice OR where the assignment is being submitted on Turnitin you agree to the above
statement.
Assessor signature: Date:
This brief has been verified as being fit for purpose
Assessor
Signature MJK Date 26/08/2020
Internal
Verifier
Signature Naz Gul Date 26/08/2020
, To import data, first click on external data then new data source and
click on excel.
Criteria To achieve the criteria the evidence must show that Page
Task no. Evidence
reference the student is able to: no
Design
P2 design a relational database for a specified user need Task 1 documentation
P3 create and populate a database Task 2 Database
create features in data entry forms to ensure validity and integrity Task 2
P4 Entry forms
of data
Task 3 At least 3
P5 perform queries using multiple tables and multiple criteria
Queries
Task 2
M2 import data from an external source Imported data
Learner name Assessor Name
Omit Ali Nas Akhter
Date issued Hand in deadline Submitted on
15/03/2021 02/04/2021
Resubmission (out) (if applicable) Resubmission (in) Lead IV authorisation
NZG
Qualification Unit number and title
Level 3 BTEC National Subsidiary Diploma in IT Unit 18 – Database design
Assignment title 18.2 Designing, creating and populating a relational database
Assignment brief
Scenario
The next part of your teaching practice is to provide an example of a working relational database. You will
have to provide several examples of evidence showing the processes from design to populating your
database.
For the purpose of this assignment you can choose either
an example database of a travel company arranging everything from Grand Prix tickets to
hotel bookings for a motor racing F1 fan
OR an example database for a local gymnasium/health club with membership details and records of
all activities/facilities used
You will have to provide data to be used in a mail merge letter to send to either the motor racing
fan or the member of the health club.
Task 1 – P2
Considering the information you provided for the game in Assignment 18.1 decide what
entities you intend to implement and normalise for your chosen database example. You
are expected to need five related entities.
Document the relationships, table structures, fields and properties.
Check with your tutor and get this signed off before proceeding to the next task. Modify
as necessary and implement your design.
Task 2
Using the information provided, design and implement suitable data entry forms for the
capturing of the information incorporating features to ensure the validity and integrity of
data.
You must include at least three of the following techniques within the set of data entry
forms:
o Validation routine
o Verification routine
o Input masking
o Check for completeness
o Visual prompts
o Data consistency
o Check for data redundancy
, Drop-down/combo boxes. P3, P4
Enter sufficient data into the system. At least some of the data should be imported
from an external source that will be provided for you. M2
Task 3-P5
Devise at least 3 queries that respond to the requirements identified using multiple tables and
multiple criteria.
Sources of information: Blackboard (BTEC IT Level 3/Course Materials), Teacher hand-outs,
BTEC National Information Technology Level 3 Course Manual, Internet Resources, YouTube Videos.
Learner & Assessor feedback and declaration
Gradin Achieved?
Assessor Feedback
g Yes/No
criteri
P2
P3
P4
P5
M2
Learner feedback
Learner declaration
I certify that the work submitted for this assignment is my own and research sources are fully
acknowledged
OR by submitting on Turnitin you agree to the above statement.
Learner signature: Date:
Assessor declaration
I certify that the evidence submitted for this assignment is the learner’s own. The learner has
clearly referenced any sources used in the work. I understand that false declaration is a form of
malpractice OR where the assignment is being submitted on Turnitin you agree to the above
statement.
Assessor signature: Date:
This brief has been verified as being fit for purpose
Assessor
Signature MJK Date 26/08/2020
Internal
Verifier
Signature Naz Gul Date 26/08/2020
, To import data, first click on external data then new data source and
click on excel.
