Assignment front sheet – ATHE

Qualification Unit number and title

ATHE L5 Extended Diploma in Computing Unit 5.2 Database Design and

(240 Credit) Development

Learner name Learner No Assessor name

Ms. Renuka Nyayadhish

Date issued Hand in deadline Submitted on

First Submission 27/02/2025 16/04/2025

Re-Submission 30/04/2025 12/05/2025

Note: students must get feedback within 15 days. Students have 10 working days to resubmit

1 of 1, Building a complete functional Database System

Assignment No. & title

In this assessment you will have opportunities to provide evidence against the following criteria.
Indicate the page numbers where the evidence can be found.

Eviden
Criteria To achieve the criteria the evidence Task ce/
Los referenc must show that the learner is able to: no. Page
e No.
LO2- Plan the design of a complex relational
2.1 Task1 Report
Be able to database in response to a client brief
design a Design a complex relational database in
relational 2.2 response to a client brief Task1 Report
database in line
with a client Normalise data to 3rd normal form
2.3 Task 1 Report
brief
Construct a complex database to meet a Databa
3.1 design brief Task 2
se
Implement database design features to meet Databa
LO3- Be able to
design brief se+
implement a 3.2 Task 2
database design GUI
Test the database to ensure it meets a client
3.3 brief Task 3 Report

Critically evaluate design documentation Report

LO4- Be able to 4.1 identifying improvements where appropriate Task 4
review the
process of Review the database implementation process Task 4 Report
design and to establish lessons learned
implementation 4.2
of a database
Evaluate the role of databases within Task 4 Report
1.1 organisations
LO1-
Understand Critically evaluate the database design Task 4 Report
1.2 process for a complex database
database
management Explain techniques that can be used to Task 4 Report
systems 1.3 connect databases to other applications
Recommend a database management system Report
1.4 to design a complex database Task 4
Learner declaration

I certify that the work submitted for this assignment is my own. I have clearly referenced any sources
used in the work. I understand that false declaration is a form of malpractice.

Learner signature: Date:

Assignment brief

Qualification ATHE L5 Extended Diploma in Computing (240 Credit)

Unit number and title Unit 5.2 Database Design and Development

Assessor name

Date issued Hand in Submitted on

deadline
First Submission 27/02/2025 16/04/2025

Re-Submission 30/04/2025 12/05/2025

Note: students must get feedback within 15 days. Students have 10 working days to resubmit

1 of 1, Building a complete functional Database System

Assignment No. & Title

Scenario
You have been appointed as a database developer for Zest Books. The company has recently
set up a new business in Al Nahda, Sharjah. They want to expand their business by providing an
online presence. The manager also wishes to manage the related data from any place. The
manager has asked you to design and build an advanced relational database that will allow the
manager to record details of:
 the books
 customers
 staff
 orders
 payments
 suppliers

Task 1 –
Using the information you have been provided with and some additional external research,
1.a) Plan and produce a design for a complex relational database based on a response to the
client brief.
This provides evidence for LO2- [2.1]

1.b) Normalise the data to 3rd normal form.

This provides evidence for LO2- [2.3]

1.c) Produce design documentation in response to the client brief ensuring this shows the design of
the tables, indexes and constraints, SQL queries, forms, macro and security measures.
This provides evidence for LO2- [2.2]

This provides evidence for LO2- [2.1, 2.2, 2.3]

Task 2 –
Your designs have been approved by the manager of Zest Books.
2.a) Implement the database using the designs you have created in Task 1.
Ensure that your database includes all the features you designed in activity one.
This provides evidence for LO3- [3.1]

2.b) Implement a suitable graphical user interface.

This provides evidence for LO3- [3.2]

This provides evidence for LO3- [3.1, 3.2]

Task 3 –
Now that the database has been implemented it needs to be tested.
3.a) Explain the different testing methods that could be used to test the database and
3.b) Produce a test plan which identifies the tests to be carried out. This should include testing of
extreme data and error handling.
3.c) Use the test plan and carry out the tests. Produce screen shot evidence to show the tests that
have been carried out and explain any errors that need to be resolved.
Amend the database based on the testing.
This provides evidence for LO3 - [3.3]

Task 4 –
Now that the database has been designed, implemented and tested, reflect on the process.
Produce a report which:
4.a) Critically evaluates the design process and documentation that was produced for Zest Books
database identifying improvements with the design documentation where appropriate.
This provides evidence for LO4- [4.1] and LO1- [1.2]

4.b) Reviews the database implementation process and explain what was successful and what you
would do differently if you were to do this again.
This provides evidence for LO4- [4.2]

4.c) Evaluates the role of databases within Zest Books. Compare this with how larger
organisations use databases.
This provides evidence for LO1- [1.1]

4.d) Explains how Zest Books can connect the database to other applications that it may use
within the business.
This provides evidence for LO1- [1.3]

4.e) Recommends to Zest Books a database management system they can use to maintain the
database you have created.
This provides evidence for LO1- [1.4]

This provides evidence for LO4- [4.1, 4.2] and LO1- [1.1, 1.2, 1.3, 1.4]

Suggested Evidence

Task No Assessment Criteria Suggested Evidence

Task 1 2.1, 2.2, 2.3 The learner must develop the database design documentation
for an advanced relational database for Zest Books. The
learner will need to review the client brief and the information
provided and decide on the tables to be designed and they
will normalise the data to 3 rd normal form. The design
documentation should include ERDs, DFDs and data
dictionaries. The learner should ensure that data dictionaries
include relationships, attributes, keys, data types. The ERD
will show the normalisation and relationships to be created
when the database is implemented.
The learner will need to consider the forms, queries; reports
and macros to be created to make the system user friendly
and these should be designed before the database is
implemented. The learner should consider house style in their
design. The design should also identify the security features
to be implemented when the design is created.

Task 2 3.1, 3.2 The learner will create a complex database, based on the
design documentation for Zest Books, created in activity one.
The database needs to include advanced features including
database links and a graphical user interface and advanced
SQL queries.
The learner should submit the database for assessment. This
could be supported with screen shots to explain the features
used during the implementation process.

Task 3 3.3 The learner will create a test plan which identifies the test to
be carried out. This will cover error handling and extreme
data.
The learner will use the test plan to test the database. They
will produce screen shots to show the tests that have been
carried out and they will explain any errors that have been
identified during the testing process. They will amend their
database based on the testing and they will evidence this in
their reflection.

Task 4 4.1, 4.2 The learner will produce a reflection report based on the
 design, implementation and testing of the database. They will
1.1, 1.2, 1.3, 1.4 bring together evidence from tasks one, two and three and
explain how their implemented database meets the client
brief.
The learner will produce a critical evaluation of the design
documentation they have created; however, they will also
evaluate the database design process and identify areas for
improvement following their evaluation.
The learner will evaluate the role of databases in
organisations. They will firstly evaluate the role of the
database for Zest Books but they will then use wider reading
and research to identify how larger organisations use
databases and compare their findings.
The learner will explain how Zest Books can connect their
database to other applications that they may use within their
business. They must use examples from other businesses to
support their explanation.
The learner will research database management systems and
based on their research they will recommend a database
management system that would be suitable for Zest Books to
use to maintain their database.

Sources of information

Books
1. Beighley, L. (2007) Head First SQL: Your Brain on SQL--A Learner's Guide. " O'Reilly Media,
Inc.".
2. Churcher, C. (2012) Beginning database design: From novice to professional. Apress.
3. Connolly, T.M. and Begg, C.E. (2015) Database systems: a practical approach to design,
implementation, and management. 6th ed. Pearson Education.
4. Elmasri, R. and Navathe, S.B. (2011) Database systems. 6th ed. Boston, MA: Pearson
Education.
5. Fleming, C.C. and Von Halle, B., (1989) Handbook of relational database design.
6. Howe, D., (2001) Data analysis for database design. Butterworth-Heinemann.
7. Silberschatz, A., Korth, H.F. and Sudarshan, S. (2011) Database system concepts. 6th ed. New
York: McGraw-Hill.

Weblinks
8. Db-book.com. (2020). Database System Concepts - 7th edition. [online] Available at:
https://www.db-book.com/db7/ [Accessed 20 Feb. 2020].
9. Sqa.org.uk. (2020). Normalisation Example. [online] Available at: http://www.sqa.org.uk/e-
learning/MDBS01CD/page_26.htm [Accessed 20 Feb. 2020].
10. Support.microsoft.com. (2020) Description of the database normalization basics
11. [online] Available at: https://support.microsoft.com/en-us/kb/283878 [Accessed 20 Feb.
2020].
12. YouTube. (2020). Normalisation Demonstration. [online] Available at:
https://www.youtube.com/watch?v=fg7r3DgS3rA [Accessed 20 Feb. 2020].
13. YouTube. (2020). Tutorial on: Data Dictionary, Schema, Primary and Foreign Keys, Data
Validation. [online] Available at: https://www.youtube.com/watch?v=Pv8nEkFysBc [Accessed
20 Feb. 2020].

Guidelines for Submission of Assignments

- Submit softcopy of assignment report, in Turnitin Moodle link.

- Submit soft copy of assignment front sheet along with signed declaration and software
solution in normal submission link as a zipped folder with your name as folder name.
- Please note assignment must be submitted on or before deadline date.
ASSESSMENT RECORD SHEET
ATHE L5 Extended Diploma in Computing Learner
Programme Learner name
(240 Credit) No:

Unit no. & title Unit 5.2 Database Design and Development Assessor name Ms. Renuka Nyayadhish

1 of 1, Building a complete functional

Assignment No. & title Database System Target learning aims LO1, LO2, LO3, LO4

1st Submission Issue Date 27/02/2022 1st Submission Due date 16/04/2022

Resubmission Issue Date 30/04/2022 Resubmission Due Date 12/05/2022

Resubmission
Date Resubmission
authorisation (Name)
authorised by LIV**
by Lead Internal Verifier*

Criteria Criteria
Target achieved? 1st Submission tutor comment achieved? Resubmission tutor comment
Task
criteri (Yes / No) (Yes / No)
No
a
1st Submission Resubmission

1.a 2.1

1.b 2.3

1.c 2.2

2.a 3.1

2.b 3.2

3 3.3

4.a 4.1

4.a 1.2
 4.b 4.2

4.c 1.1

4.d 1.3

4.e 1.4

General comments (tutor) – Please comment on the quality of student work, report structure and referencing.

I certify that the evidence submitted for this assignment is the learner’s own. The learner has clearly referenced any sources
Assessor declaration
used in the work. I understand that false declaration is a form of malpractice.

Assessor signature Date

Learner comments

Learner signature Date