BTEC Level 2 Unit 10 Task 3 Database Development Assignment Brief

Published: 23 May, 2025
Category Assignement Subject Computer Science
University - Module Title BTEC Level 2 Unit 10 Task 3 Database Development

Vocational Scenario

A pet sitting business with five employees and about 200 clients currently uses a combination of paper and spreadsheet systems to store and manage the information about patients and appointments.

However, a planned reorganisation of the pet services will mean an increased number of clients and the owner, Paris, has decided to upgrade the system.

Paris has decided not to replace all their systems at the same time. She wants to focus initially on a new and improved appointment system. This will allow time for staff to become confident in using new systems and software in an area of their work that has a limited risk to patient safety.

As an IT employee of the local pet sitting service, you have been asked to develop the new appointment system.

Task 3 – Develop and Test the Relational Database

It’s now time to develop the appointment system.

You will refine the database solution, using automated tools and techniques, to improve productivity, accuracy, and the presentation of output data, considering relevant user feedback.

Your fine database must be supported with feedback gathered from others, which you will use to improve the database and test any additional functionality, repairing any faults.

The relational database must demonstrate awareness of the purpose of the database, user requirements and accuracy by including the following:

  • Customised data-entry forms
  • Queries and output data reports
  • Onscreen guidance

You are further required to provide evidence of testing the functionality and additional features of the database, and to ensure it fits its intended purpose. Record any repairs made by making comments on the designs and test plans about any issues discovered and how they were resolved. Changes to the database should be documented; for example, different versions from stages of development could be used to evidence this.

Arrange a meeting with your tutor to demonstrate your database solution. You should discuss the functionality and usability of the relational database and record this feedback as part of the testing process. Use the discussion to review your designs and improve productivity, accuracy and the presentation of output data.

Need plagiarism-free Answers for your college/ university Assignments

Order Non-Plagiarised Assignment

Checklist of evidence required

  • Original database.
  • An annotated and reviewed database (after testing).
  • Data-entry forms with clear labelling.
  • Queries.
  • Reports.
  • Sorted data.
  • Testing the table and data with screenshots.
  • Feedback from others.
  • Witness statement.
  • Digital copy of the database.

Criteria Covered by This Task:

Unit/Criteria reference To achieve the criteria you must show that you are able to:
2C.D2 Refine the database solution using automated tools and techniques to improve productivity, accuracy and the presentation of output data, taking account of user feedback
2C.M4 Gather feedback from others and use it to improve the database and test any additional functionality, repairing any faults.
2C.M3 Develop the database demonstrating awareness of users’ requirements and accuracy. To include:

 

  • Customised data entry-forms
  • Queries and output data reports
  • Onscreen navigation and guidance
2C.P5 Test the functionality and purpose of the relational database for functionality, repairing and faults.
2C.P4 Develop a relational database with realistic data set, which includes:

 

  • Two tables
  • Sort records
  • Data-entry forms

Sources of information to support you with this Assignment

Books

Allman, E., Jarvis, A., Kaye, A. and McGill, R. (2012) BTEC First in Information and Creative Technology Student Book, Pearson Education Ltd, 978 1 44690 187 8
Textbook designed for this qualification with a strong vocational focus.

Churcher, C. (2007) Beginning Database Design, Springer, 978 1 59059 769 9
Good coverage of basic design issues.

Stephen, M. (2006) Databases with Access: Learning Made Simple, Routledge, 978 0 75068 186 5. An old version of Microsoft Access is employed. However, key tools and techniques are compatible. Useful for building practical skills and competence in software.

Other assessment materials are attached to this Assignment Brief

N/A

Notes to Assessor and Technician

Scenarios and details of the website to be developed can be adjusted to suit local needs. You may be able to get local employers, charities etc. to provide a case study of a website they would like to be developed.

FOR 2012 L1/2 FIRSTS ONLY: If you have not achieved the Level 2 criteria, your work will be assessed to determine if the following Level 1 criteria have been met.

To achieve the criteria, you must show that you are able to: Unit Criterion reference
Develop a database with a realistic data set with guidance, including:

 

  • A single table structure
  • A data-entry form
10 1C.4
Test the functionality of the database and repair any faults with guidance 10 1C.5

Take our academic assistance & get 100% plagiarism-free papers

Buy Today, Contact Us

 

Are you trying to find someone who can help with my BTEC Level 2 Unit 10 Task 3 Database Development? Well! You're in the right place, our podium Workingment, provides Computer Science Assignment Help. Our well-researched and talented professors can also provide you with odd assignments. Suppose you're judging whether to Write My Assignment with our professors. No doubt! Our team can help with your assignment. We also provide Free Sample assignments for your guidance. Get in touch right now!

Workingment Unique Features

Hire Assignment Helper Today!


Latest Free Samples for University Students

RBP020L063H Leadership and Change Management Assignment Sample

Category: Assignment

Subject: Management

University: University of Roehampton

Module Title: RBP020L063H Leadership and Change Management

View Free Samples

HRMM080 Ethical and Responsible Leadership AS2 Reflective Portfolio Sample

Category: Assignment

Subject: Management

University: University of Northampton

Module Title: HRMM080 Ethical and Responsible Leadership

View Free Samples

ACAD1346 The child’s live Experience Developing Confidence Learners Assignment Sample

Category: Assignment

Subject: Education

University: University of Greenwich (UOG)

Module Title: ACAD1346 The child’s live Experience Developing Confidence Learners

View Free Samples

NUR7011 Developing Healthcare Leaders Assignment Sample | BPP

Category: Assignment

Subject: Nursing

University: BPP University

Module Title: NUR7011 Developing Healthcare Leaders

View Free Samples

Project Management, Leadership and Skills: Planning & Control Portfolio Example

Category: Assignment

Subject: Management

University: University of Salford Manchester

Module Title: Project Management, Leadership and Skills: Planning & Control

View Free Samples
Online Assignment Help in UK