DESIGN, CREATE, AND
EVALUATE A DATA
MODEL
H.E.GUNAWARDENA
BTEC INTERNATIONAL LEVEL 03
, STUDENT ASSESSMENT SUBMISSION AND
DECLARATION
When submitting evidence for assessment, each student must sign a declaration confirming that the
work is their own.
Student name: Assessor name:
Hirunie Elisha Gunawardena Ms. K.R.C. Koswatte
Issue date: Submission date: Submitted on:
2024-03-13 2024-05-20 2024-05-19
Programme:
BTEC Level 03 International Diploma
Unit: Data Modelling
Assignment number and title: Design, create and evaluate a data model. (2)
Plagiarism
Plagiarism is a particular form of cheating. Plagiarism must be avoided at all costs and students who
break the rules, however innocently, may be penalised. It is your responsibility to ensure that you
understand correct referencing practices. As a university level student, you are expected to use
appropriate references throughout and keep carefully detailed notes of all your sources of materials
for material you have used in your work, including any material downloaded from the Internet. Please
consult the relevant unit lecturer or your course tutor if you need any further advice.
Student Declaration
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the
consequences of plagiarism. I understand that making a false declaration is a form of malpractice.
Student signature: H.E.Gunawardena Date: 19/05/2024
1|Page
,2|Page
, Table of Contents
PRODUCE DESIGNS FOR A DATA MODEL WHICH MEET CLIENT REQUIREMENTS .. 9
1. Identified Client Requirements................................................................................................ 9
2. Producing designs for the data model ................................................................................... 10
3. Producing Work Sheet Structure Diagrams......................................................................... 21
a. Layout Diagram .................................................................................................................... 21
b. Presentation Diagrams .......................................................................................................... 25
c. Navigation Diagram .............................................................................................................. 27
d. Data Entry and Validation..................................................................................................... 31
e. Processing ............................................................................................................................. 32
4. Test Plan .................................................................................................................................. 38
REVIEW THE DESIGNS WITH OTHERS TO IDENTIFY AND INFORM
IMPROVEMENTS. ............................................................................................................................ 41
1. Review the data model ............................................................................................................ 41
2. Refine the data model ............................................................................................................. 42
DEVELOP A DATA MODEL TO MEET CLIENT REQUIREMENTS ..................................... 48
REVIEW THE EXTENT TO WHICH THE DATA MODEL MEETS CLIENT
REQUIREMENTS .............................................................................................................................. 60
Reviewing Client Requirement: 1 ..................................................................................................... 60
Reviewing Client Requirement: 2 ..................................................................................................... 61
Reviewing Client Requirement: 3 ..................................................................................................... 62
Reviewing Client Requirement: 4 ..................................................................................................... 63
Reviewing Client Requirement: 5 ..................................................................................................... 64
JUSTIFY DECISIONS MADE, SHOWING HOW THE DESIGN WILL FULFIL ITS
PURPOSE AND CLIENT REQUIREMENTS. ............................................................................... 65
Design Decision 1: Implementation of drop-down lists for user selections ..................................... 65
Design Decision 2: Incorporating Data Validation Rules for Accuracy ........................................... 66
Design Decision 3: Application of Conditional Formatting ............................................................. 67
Design Decision 4: Inserting of charts and graphs ........................................................................... 68
Design Decision 5: Implementing Goal Seek for Target Analysis ................................................... 69
OPTIMIZE THE DATA MODEL TO MEET CLIENT REQUIREMENTS ............................... 70
EVALUATE THE DESIGN AND OPTIMISED DATA MODEL AGAINST CLIENT
REQUIREMENTS .............................................................................................................................. 73
DEMONSTRATE INDIVIDUAL RESPONSIBILITY, CREATIVITY, AND EFFECTIVE
SELF-MANAGEMENT IN THE DESIGN, DEVELOPMENT, AND REVIEW OF A DATA
MODEL. .............................................................................................................................................. 77
1. Planning and recording ............................................................................................................. 77
2. Reviewing and Responding to feedback ................................................................................... 78
3|Page
EVALUATE A DATA
MODEL
H.E.GUNAWARDENA
BTEC INTERNATIONAL LEVEL 03
, STUDENT ASSESSMENT SUBMISSION AND
DECLARATION
When submitting evidence for assessment, each student must sign a declaration confirming that the
work is their own.
Student name: Assessor name:
Hirunie Elisha Gunawardena Ms. K.R.C. Koswatte
Issue date: Submission date: Submitted on:
2024-03-13 2024-05-20 2024-05-19
Programme:
BTEC Level 03 International Diploma
Unit: Data Modelling
Assignment number and title: Design, create and evaluate a data model. (2)
Plagiarism
Plagiarism is a particular form of cheating. Plagiarism must be avoided at all costs and students who
break the rules, however innocently, may be penalised. It is your responsibility to ensure that you
understand correct referencing practices. As a university level student, you are expected to use
appropriate references throughout and keep carefully detailed notes of all your sources of materials
for material you have used in your work, including any material downloaded from the Internet. Please
consult the relevant unit lecturer or your course tutor if you need any further advice.
Student Declaration
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the
consequences of plagiarism. I understand that making a false declaration is a form of malpractice.
Student signature: H.E.Gunawardena Date: 19/05/2024
1|Page
,2|Page
, Table of Contents
PRODUCE DESIGNS FOR A DATA MODEL WHICH MEET CLIENT REQUIREMENTS .. 9
1. Identified Client Requirements................................................................................................ 9
2. Producing designs for the data model ................................................................................... 10
3. Producing Work Sheet Structure Diagrams......................................................................... 21
a. Layout Diagram .................................................................................................................... 21
b. Presentation Diagrams .......................................................................................................... 25
c. Navigation Diagram .............................................................................................................. 27
d. Data Entry and Validation..................................................................................................... 31
e. Processing ............................................................................................................................. 32
4. Test Plan .................................................................................................................................. 38
REVIEW THE DESIGNS WITH OTHERS TO IDENTIFY AND INFORM
IMPROVEMENTS. ............................................................................................................................ 41
1. Review the data model ............................................................................................................ 41
2. Refine the data model ............................................................................................................. 42
DEVELOP A DATA MODEL TO MEET CLIENT REQUIREMENTS ..................................... 48
REVIEW THE EXTENT TO WHICH THE DATA MODEL MEETS CLIENT
REQUIREMENTS .............................................................................................................................. 60
Reviewing Client Requirement: 1 ..................................................................................................... 60
Reviewing Client Requirement: 2 ..................................................................................................... 61
Reviewing Client Requirement: 3 ..................................................................................................... 62
Reviewing Client Requirement: 4 ..................................................................................................... 63
Reviewing Client Requirement: 5 ..................................................................................................... 64
JUSTIFY DECISIONS MADE, SHOWING HOW THE DESIGN WILL FULFIL ITS
PURPOSE AND CLIENT REQUIREMENTS. ............................................................................... 65
Design Decision 1: Implementation of drop-down lists for user selections ..................................... 65
Design Decision 2: Incorporating Data Validation Rules for Accuracy ........................................... 66
Design Decision 3: Application of Conditional Formatting ............................................................. 67
Design Decision 4: Inserting of charts and graphs ........................................................................... 68
Design Decision 5: Implementing Goal Seek for Target Analysis ................................................... 69
OPTIMIZE THE DATA MODEL TO MEET CLIENT REQUIREMENTS ............................... 70
EVALUATE THE DESIGN AND OPTIMISED DATA MODEL AGAINST CLIENT
REQUIREMENTS .............................................................................................................................. 73
DEMONSTRATE INDIVIDUAL RESPONSIBILITY, CREATIVITY, AND EFFECTIVE
SELF-MANAGEMENT IN THE DESIGN, DEVELOPMENT, AND REVIEW OF A DATA
MODEL. .............................................................................................................................................. 77
1. Planning and recording ............................................................................................................. 77
2. Reviewing and Responding to feedback ................................................................................... 78
3|Page
