VAT Calculation and HMIS System Requirements

The provided document outlines the technical specifications and requirements for a veterinary healthcare management system (VAT CALCULATION). It includes details on data quality guarantee techniques, timing, reliability, and security standards. The system is expected to have various features such as user authentication, virus security, firewalls, public access, physical entry to software with access to HMIS data, disaster protection, and recovery. The document also references several reports and studies related to animal healthcare in Australia.

VET SOLUTION
Submitted by:
Date:

Table of Contents
Introduction
L01 Use an appropriate design tool to design a relational database system for a substantial problem
 ER Diagram
 User Requirement
 Data Dictionary
 Data Validation
 Data Normalization
LO2 Develop a fully functional relational database system, based on an existing system design
 Create Table using MS SQL server
 Created Queries with multiple tables for the database using sql query tools
LO3 Test the system against user and system requirements.
 Create test plan for developed Vet Solution Database
LO4 Produce technical and user documentation
 User Documentation
 Technical Documentation
Conclusion
Reference

Introduction
A veterinary company, VET SOLUTION, which started around 2005 and based at Cambridge
shire have recently opened certain branches in a direction of southeast England. Due to the
huge amount with paper work and the poor communication among staffs and the branches.
VET SOLUTION have approach your company, ULKOM LTD, requesting for a computerized
database system.
LO1
Entity Relationship diagram

Table Creation

Lo2:
Data Dictionary:

-----------------
Queries:
SELECT P.PATNAME, P.STREET, P.CITY, P.STATE, P.ZIPCODE
FROM TREATMENT T, PAT P
WHERE T.PATID = P.patid
AND T.PHYSICIANID = '123456789'
ORDER BY P.PATNAME;
SELECT *
FROM PHYSICIAN
WHERE SUPERVISOR = '123456789'
ORDER BY PHYSNAME;
SELECT PATNAME, STREET, CITY, STATE
FROM PAT
WHERE STATE = 'TX';
SELECT PATNAME, STREET, CITY, STATE
FROM PAT
WHERE STATE
IN ('TX', 'NY', 'CA');
SELECT DESCCRIPT, COST
FROM ILLNESS
ORDER BY COST DESC;
SELECT COUNT( COST ) AS TOTAL_NO, MAX( COST ) AS MAXIMUM_COST, MIN( COST ) AS MINI
MUM_COST, AVG( COST ) AS AVERAGE_COST
FROM ILLNESS;
SELECT DRUGNAME, DCOST
FROM PRESCRIPTION
ORDER BY DCOST DESC;
SELECT COUNT( DCOST ) AS 'NUMBER', MAX( DCOST ) AS 'Most
Expensive', MIN( DCOST ) AS 'Cheapest', AVG( DCOST ) AS 'Average Cost'
FROM PRESCRIPTION;

SELECT COUNT( PATID ) AS 'TREATMENTS'
FROM TREATMENT
WHERE PHYSICIANID = '221100998';
SELECT P.PATNAME, P.STREET, P.CITY, P.STATE, P.ZIPCODE
FROM TREATMENT T, PAT P, PHYSICIAN H
WHERE T.PATID = P.PATID
AND T.PHYSICIANID = H.PHYSID
AND H.PHYSNAME = 'SMITH, MARY'
ORDER BY P.PATNAME DESC;
SELECT P.PATNAME, H.PHYSNAME
FROM TREATMENT T, PAT P, PHYSICIAN H
WHERE T.PATID = P.PATID
AND T.PHYSICIANID = H.PHYSID
AND H.PHYSID = '123456789'
AND H.SUPERVISOR = '123456789'
GROUP BY H.PHYSNAME;
SELECT P.DRUGNAME, T.TREATDATE
FROM PRESCRIPTION P, TREATMENT T
WHERE P.DRUGID = T.DRUGCODE
AND T.PHYSICIANID = '123456789'
ORDER BY T.TREATDATE;
SELECT DISTINCT P.DRUGNAME
FROM PRESCRIPTION P, TREATMENT T
WHERE P.DRUGID = T.DRUGCODE
AND T.PHYSICIANID = '123456789';
SELECT DISTINCT I.DESCCRIPT
FROM ILLNESS I, TREATMENT T
WHERE I.ILLCODE = T.ILLNESSCODE
AND T.PHYSICIANID = '123456789'
ORDER BY I.DESCCRIPT;
SELECT DISTINCT PHYSNAME
FROM PHYSICIAN P, PRESCRIPTION C, TREATMENT T

WHERE P.PHYSID = T.PHYSICIANID
AND C.DRUGID = T.DRUGCODE
AND SUPERVISOR = '123456789'
AND C.DRUGNAME
IN ('CODEINE', 'PERCODAN');
SELECT T.TREATDATE AS DATE, A.PATNAME AS 'PAT
Name', I.DESCCRIPT AS Illness, I.COST AS 'Treatment
Costs', C.DRUGNAME AS Prescribed, C.DCOST AS'Drug
Costs', T.NDRUGS AS No, (T.NDRUGS * C.DCOST) AS 'Total Drug
Cost', ((T.NDRUGS * C.DCOST) + I.COST ) AS 'Total Cost'
FROM PHYSICIAN P, PRESCRIPTION C, TREATMENT T, PAT A, ILLNESS I
WHERE P.PHYSID = T.PHYSICIANID
AND C.DRUGID = T.DRUGCODE
AND A.PATID = T.PATID
AND I.ILLCODE = T.ILLNESSCODE;
SELECT A.PATNAME AS 'PAT Name', COUNT( T.PATid ) AS 'No.
Treatments', SUM( I.COST ) AS 'Tot. Treatment $', SUM( C.DCOST ) AS 'Tot. Drug $', (
SUM( I.COST ) + SUM( C.DCOST )
) AS 'Total Costs'
FROM PRESCRIPTION C, TREATMENT T, PAT A, ILLNESS I
WHERE C.DRUGID = T.DRUGCODE
AND A.PATID = T.PATID
AND I.ILLCODE = T.ILLNESSCODE;

LO3
Test Plan
Document History -
Version Date Author Description of Change
1 05/15/2018 Draft
2 05/15/2018 Draft - Reviewed
Approvers List -
Name Role Approver /
Reviewer
Approval /
Review Date

POSITIVE ASPECTS
Purpose
The particular test program states the serious examining approaches and general
structure that will lead to drive the particular assessment of the software. The actual
document states:
o Test Strategy: which leads to rules the test that is based after, which includes
with the task (such as start out or ;last dates, aims, assumptions) and description
related to the approach for setup a test which is valid (like while gary the
gadget person.: gain access to / exit requirements, creating test occasions,
performing specific tasks , setting up, strategies related to data).
o Deal for Execution : describes that how a test would probably performed and
also process to acknowledge and other defects in report , also for fixing and
implementing maintenance also.
o Management of a Test: approach for dealing with other logistics which make
sure that all the events which can move upward during an execution (e. h.:
escalation methods, communications, danger and also mitigation, crew
rostering )
Project Overview
The information Module is an effective instrument providing personnel from the
business with the ability to view appropriate facts such as personal information as well
as replacing personal facts with a great web strengthened PC while not having to include
the HR business office.
Top features of this aspect spans car system, making information available anywhere,
anytime. All information is certainly essentially subject to company’s described
protection policy, where he can simply view the information he will be authorized to. A

great ESS-User can only edit a number of areas in the ESS Component, sustaining the
reliability and confidentiality associated with employee facts
Audience
o Project team members accomplish tasks specific in this record, and provide
recommendations and enter into on this record.
o Project Supervisor Plans for your testing actions in the general project program,
reviews the actual document, paths the overall efficiency of the check according
to the working job thus specified, approves the particular report and is
accountable for the results.
o The stakeholder srepresentatives as well as members (individuals as recognized
by the PMO Leads) might take portion in the UAT analysis in order that the firm
is in-line with the effects of the test.
o Technical Workforce ensures that the test strategy and deliverables are in
collection with the design, presents the atmosphere for testing and comes after
the procedures associated with commonly the fixes of defects.
o Business analysts definitely will give their advices about sensible changes.
STRATEGIES FOR TESTING
Evaluation Objective
The aim of the test is usually to verify how the features of ORANGEHRM MODEL 3. zero -
OUR DETAILS COMPONENT works in line with the technical specs. The test will carry out
and verify the test intrigue, distinguish, fix and retest all of the high and method
seriousness defects per often the top requirements, prioritize reduce seriousness
defects for long term correcting via CR.
The ultimate item of the test will be two fold:
o AN application which is ready for production
o A proper setup of all stable examination intrigue which can also be reused
regarding Practical and further UAT check delivery.

Test Presumptions
Key Presumptions
o Production of many factors like data expected along with stay available for the
program prior in commencement of related Functional Testing
o In every phase, single testing which includes Routine 3rd or more would be
initiated in an event the problem rate could loaded with Circuit
o General
o Exploratory Testing will carried after the building that can be ready to perform
tests
o Performance tests are not looked at with particular estimation.
o actual issues can come awith a guide JPEG formats
o Try out Team that would be provided with utilization of Testing environment
with the help of VPN connectivity
o The Test Personnel assumes that all necessary fills required for Test design and
also execution that can be retained Development/BUSINESS Specialists
appropriately.
o activities related to Test case design is performed by QA Get together
o Test surrounding and arranging activities will owned just by Team of Dev
o Dev personnel will present Defects for resolving strategies based on the
Problem seminars in the course of each pattern to program. The same would
probably be provided to evaluate teams to get started regarding Defect fix
periods prior
o BUSINESS ANALYST will definitely review along with sign-off all Test situations
made by Test Team before start off of Test delivery
o The defects will be encountered with HP ALM merely. Any kind of defect fixes
organized will probably be shared with Test Workforce ahead of making use of
the treatments around the Test surrounding
o Project Manager orBUSINESS ANALYST conducts overview and sign-off all
analyze giveaways

o The project provides evaluation planning, test style and ther design and test
effectiveness help
o

o Problem and validation Management
o This really is expected the known reality testers do all the movie screenplays in
each of the cycles seen by above. Even so it is diagnosed that the testers could
moreover carry out additional testing whenever they recognize a possible hole in
the pieces of software. This really is relevant in the next cycle specifically, when
the Business join the TCOE inside the delivery with the test analyst’s, considering
that the continuing business ANALYSTs own a further knowledge of the business
operations. If the gaps are recognized, the particular scripts and relared
traceability matrix would be current and after that any defect resistant to the
pièce.
o The defects would probably be ed through HP ALM solely. The technical
staff may gather information on every day basis coming from HP ALM, and ask
for further details from the Problem Supervisor. The technical group will
continue to work on fixes.

o It will probably be the responsibility of the tester to spread out the defects, web
page link those to the corresponding software, give an initial severity and
reputation, retest and close typically the defect; that may be the obligation in
the Defect Manager to examine often the significance of the disorders in
addition to facilitate with all the technical workforce the resolve and its
rendering, communicate with testers when the test out can continue or must be
halt, submission the battery power tester to retest, and adjust position as the
defect actions along through the cycle; is it doesn't accountability of the
technical group to check out HP ALM on a daily basis, look for details if possible,
fix the actual defect, have a discussion to the Deficiency Manager the fix is
performed, implement the answer per the particular Defect Overseer request.
o

1. Test Risks and Mitigation Factors
2. APPROVALS
The Names and Titles of all persons who must approve this plan.
Signature:

Name:
Role:
Date:
Signature:
Name:
Role:
Date:
LO4
Technical and user documentation
1. GENERAL INFORMATION
1.1 Purpose

The goal of this productive as well as specialized requirements document would be to give
documentation to potential HMIS solution firms within the requirements of vat computation to
implement and run a Desolate Management Info System..
Opportunity
This particular Technical and Useful Specifications Document will describe the actual valuable,
performance, reliability along with other system requirements diagnosed through the vat
calculations while the suggested info program solution for any Homeless Control Information
Program.
Project Sources
Crucial documents needed seeing as assisting references to this report generally tend to be
listed beneath and must be taken into account simply by feasible solution companies even
though answering to the details gone over in this document:
Functional Requirements
In order to accomplish the above articulated need, the vat computations require a community-
wide data assortment and handling system which includes the next functionality:
o Client Managing Solutions
o Client specific monitoring associated with intake process, which includes system entry
and exit
o Socio-demographic info, including capacity to document home and family relationships
o Retention of client specific classic data
o Outreach Program Consumer Management: Ability to house not perfect records with a
process to find adding records to key database when record is in fact indicated complete
o Case Government
o Client specific prognosis with regards to needs
o Ability to track buyer specific desired goals and outcomes
o Ability to share client level data across agencies
Service Delivery Oversight: Ability to document and maintain good buyer particular services
received by simply consumer, including capability to document preparing, scheduling and
follow up upon delivery of services.
Referral Control: Capacity to document and also retain good buyer specific referrals, which
includes follow-up, reminder capabilities, and status/outcome
User Organizational Influences

The project will need to have at least one fresh staff position at the VALUE-ADDED TAX
CALCULATION whose sole responsibility is the management, project administration, and
training duties in the HMIS on behalf of the Ensemble of Care. Fiscal managing of the
COMPUTER SOFTWARE will be overseen by just the finance section of the VAT CALCULATION.
Validity and accuracy
The system will utilize numerous data high quality guarantee techniques unquestionably,
including yet , not limited to:
o Input face masks
o Drop down lists with regular responses
o Record info completeness requirements
o Basic info reasoning warnings (i. age., Sex: Male with Being pregnant position: Y)
Timing
The program as well available one day per day on-line, twelve months weekly with the
exception of scheduled downtimes along with pre-notified system routine service..
RELIABILITY
The VAT program equipment and program retained from the VAT CALCULATION, typically the
Hosting Vendor, as well as the Taking part Businesses must almost all fulfill the minimum
security requirements from the VAT Data additionally to Technical Standards.
These kinds of Demands include:
o System Reliability
o User Authentication
o Virus Security
o Firewalls
o Public Access
o Physical Entry to Software with Access to HMIS Data
o Disaster Protection as well as Recovery

o Disposal
o System Checking
o Software App Security
o User Authentication
Reference:
1. Animal Medicines Australia. Pet Ownership in Australia 2016 Report; Animal
Medicines Australia Pty Ltd.:Barton, Australia, 2016.
2. Australian Companion Animal Council. Contribution of the Pet Care Industry to the
Australian Economy, 7th ed.; Rockwell Communications Inc.: East Kew, Victoria,
Australia, 2010.

3. O’Neill, D.G.; Church, D.B.; McGreevy, P.D.; Thomson, P.C.; Brodbelt, D.C.
Prevalence of disorders recorded in dogs attending primary-care veterinary
practices in England. PLoS ONE 2014, 9, e90501.
4. O’Neill, D.G.; Church, D.B.; McGreevy, P.D.; Thomson, P.C.; Brodbelt, D.C.
Prevalence of disorders recorded in cats attending primary-care veterinary practices
in England. Vet. J. 2014, 202, 286–291.
5. Ward, M.P.; Kelman, M. Companion animal disease surveillance: A new solution to
an old problem? Spat. Spatio-Temporal Epidemiol. 2011, 2, 147–157.
6. Guernier, V.; Milinovich, G.J.; Bezerra Santos, M.A.; Haworth, M.; Coleman, G.;
Soares Magalhaes, R.J. Use of big data in the surveillance of veterinary diseases:
Early detection of tick paralysis in companion animals. Parasite Vector 2016, 9,
303.
7. McGreevy, P.D. Breeding for Quality of Life. Anim. Welf. 2007, 16, 125–128.
8. McGreevy, P.D.; Nicholas, F. Some practical solutions to welfare problems in dog
breeding. Anim. Welf. 1999, 8, 329–341.
9. Nicholas, F.W.; Arnott, E.R.; McGreevy, P.D. Does hybrid vigour have any utility in
dog breeding? Vet. J. 2016, 214, 77–83.