- Qualifi Level 4 HSC401 Academic Study Skills Assignment: Portfolio on Personal Development, Source Evaluation, and Research Relevance in Health and Social Care
- AFM0ICD Budgeting Advice Assignment 1: Mr Confused Case Study on Business Budget Planning, Monitoring and Communication Using Microsoft Office Tools
- W84512A Enterprise Assignment: Business Analysis of a UK-Based SME Using Market Research, PEST & SWOT Tools BTEC Level1/Level2
- 5COSC022W JAX-RS REST API Assignment: Airline Agency System for Flight, Passenger & Booking Management
- 6315_6327_6220BEUG Construction Project Report: Yale College Redevelopment Programme Management
- MN4W50QA Professional Development Reflection Assignment: Weekly Learning Log & PDP-Based Self-Assessment Report
- BUS5017 Blockchain & FinTech Assignment Report: Supply Chain Finance Transformation in UK Manufacturing Sector
- Unit 12 Executive Recruitment Assignment Report: Retail Case Study for Hiring a Merchandising Officer
- CIPD Level 5HR03 Reward Management Assignment: GreenFriendlyEco Case Study for Performance and Retention Strategy
- FDY3008 Investigation and Innovation Project: Small-Scale SDG Solution with Reflective Skills Development Report
- F/618/5289 OTHM Level 3 Communication in Health and Social Care Assignment: Report and Presentation on Equality, Diversity, and Inclusion
- Reflective Assignment Report: Personal Nursing Values and Their Impact on Future Practice
- HWSC4003 Communication & Ethics Assignment: Reflective Report on Therapeutic Relationships in Health and Social Care
- Crime Data Visualisation Assignment: US Crime Case Study for Law Enforcement Intelligence
- MG410 Career Development Assignment: Self-Reflection, CV, LinkedIn & SMART Plan for Future Employment
- 6008LBSBSC Strategic Finance Assignment: UK Oil Plc Case Study for Evaluating Capital Investment Options
- H/618/5284 OTHM Level 3 Working Relationships and Partnership Assignment: Health & Social Care Case Study for Professional Roles and Quality Practice
- Fashion Product Management Assignment: TrendVogue Case Study for Sustainable Sourcing Compliance
- AFM01MA Management Accounting Assignment 1: BioTube Ltd. Case Study for Costing, Budgeting & Variance Improvement
- Aircraft Design Assignment Report: Mission-Based Design, Market Analysis & Performance Improvements
BTEC Level 2 Unit 10 Database Development Assignment: Pet Sitting Hotel Case Study
| 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.
Do You Need Assignment of This Question
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:
|
| 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:
|
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:
| 10 | 1C.4 |
| Test the functionality of the database and repair any faults with guidance | 10 | 1C.5 |
Ready your Unit 10 Database Development Assignment report with the help of UK Assignment Helper. Here specialize in professionals for all categories of assignments who provide you with plagiarism-free and improved content. You are assured that our report-writing service will make you productive and help you score high grades in your academic year. Contact us today and get your perfect report!
Answer
