BTEC Level 2 Unit 10 Appointment System Database Assignment: Pet Sitting Service Case Study for Improving Client Management

University	Langley College
Subject	Unit 10: Database Development

Vocational Scenario

A pet sitting business with five employees and about 200 clients currently use 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 fined 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.

Checklist of evidence required

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

Are You Searching Answer of this Question? Request British Writers to Write a plagiarism Free Copy for You.

Chat Now

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 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 the software.

Websites

www.advanced-ict.info/databases/clash.html
Microsoft Access specific guidance on a particular issue related to appointment systems – double bookings.

www.gpuk.net/appointconfighelp.php3#running
Details about the operation of a real online appointments system. Useful for learners to appreciate the practical application.

www.wisegeek.com/what-are-the-advantages-of-electronic-medical-records.htm
A general background article that explores the advantages of computerising medical records using accessible language.

www.yourwebskills.com/dbrelationships.php
A very useful description of how relationships work in a health practice context.

Other assessment materials 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 develop.

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

1C.4

Test the functionality of the database and repair any faults with guidance

1C.5

Answer

Request Answer of this Assignment

Top Assignment Services

Get AI-Free Assignment Help Instantly

Recent Solved Questions

Unit 38 Law of Contract and Tort (M/617/0738) Assignment Brief 2026

Unit 38 Law of Contract and Tort Assignment Brief Qualification Pearson BTEC Level 5 Higher Nationals in Business Unit Number 38 Unit Title Law of...

Unit 30 Resource and Talent Planning Assignment Brief Qualification Pearson BTEC Level 5 Higher Nationals in Business Unit Number 30 Unit Title Resource and Talent...

Unit 34 Digital Marketing Assignment Brief Qualification Pearson BTEC Level 5 Higher Nationals in Business Unit Number 34 Unit Title Digital Marketing Unit code R/618/5121...

Unit 28 Launching a New Venture Assignment Brief Qualification Pearson BTEC Level 5 Higher Nationals in Business Unit Number 28 Unit Title Launching a New...

Unit 27 Identifying Entrepreneurial Opportunities Assignment Brief Qualification Pearson BTEC Level 5 Higher Nationals in Business Unit Number 27 Unit Title Identifying Entrepreneurial Opportunities Unit...

Unit 25 Global Business Environment Assignment Brief Qualification Pearson BTEC Level 5 Higher National Diploma in Business Unit Number 25 Unit Title Global Business Environment...

Unit 24 Managing and Leading Change Assignment Brief Qualification Pearson BTEC Level 5 Higher National Diploma in Business Unit Number 24 Unit Title Managing and...

Unit 23 Financial Management Assignment Brief Unit Number 23 Unit Title Financial Management Unit code D/618/5073 Unit type Core Unit level 5 Credit value 15...

Unit 22 Management Accounting Assignment Brief Qualification Pearson BTEC Level 5 Higher Nationals in Business Unit Number 22 Unit Title Management Accounting Unit code Y/618/5069...

Unit 51 Advanced Construction Development & Prototyping Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 51 Unit Title Advanced Construction Development & Prototyping...

Unit 52 Advanced Housing Design & Specification Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 52 Unit Title Advanced Housing Design & Specification...

Unit 53 Advanced Off-site Construction Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 53 Unit Title Advanced Off-site Construction Unit code F/618/8130 Unit...

Unit 54 Advanced Quantity Surveying Practice Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 54 Unit Title Advanced Quantity Surveying Practice Unit code...

Unit 55 Alternative Sustainable Solutions in Construction Assignment Brief Introduction The construction industry seeks to be dynamic and forward thinking but most buildings are still...

Unit 13 Cost and Management Accounting Assignment Brief Qualification Pearson BTEC Level 3 National Certificate in Business 601/7155/8 Pearson BTEC Level 3 National Extended Diploma...

Unit 1 Exploring Business Assignment Brief Qualification Pearson BTEC Level 3 National Certificate in Business 601/7155/8 Pearson BTEC Level 3 National Extended Diploma in Business...

Unit 15 Principles of Alternative Energy Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 15 Unit Title Principles of Alternative Energy Unit code...

Unit 10 Measurement & Estimating Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 10 Unit Title Measurement & Estimating Unit code T/618/8089 Unit...

Unit 13 Software Testing Assignment 2 Brief Qualification Pearson BTEC Level 3 Diploma in Information Technology Pearson BTEC Level 3 Extended Diploma in Information Technology...

Unit 6 Digital Applications for Construction Information Assignment Brief Qualification Pearson BTEC Higher Nationals Construction Unit Number 6 Unit Title Digital Applications for Construction Information...