Database Assessment for VET Solution Company

This report focuses on designing and implementing a relational database system for VET Solution, a veterinary organization in Cambridgeshire. The database aims to manage patient information, employee details, and branch data, enhancing communication and data sharing within the company. The report covers the design process using ER diagrams, data validation, and normalization techniques. It then details the development of the database using MS SQL Server 2014, including table creation, relationship diagrams, and query examples. Finally, the report provides comprehensive technical and user documentation, including diagrams illustrating data movement and functional dependencies.

Database Assessment

Table of Contents
Introduction............................................................................................................................ 5
LO1 Use an appropriate design tool to design a relational database system for a substantial
problem.................................................................................................................................. 6
P1. Design a relational database system using appropriate design tools and techniques. .6
Requirement of database administration framework.......................................................6
Client Requirement.........................................................................................................6
Framework Requirement.................................................................................................7
Software Requirements...................................................................................................7
Hardware requirements...................................................................................................7
ER diagram..................................................................................................................... 7
Relationship....................................................................................................................8
M1 Produce a comprehensive design for a fully functional system.....................................9
Data Validation................................................................................................................ 9
Data Dictionary.............................................................................................................. 10
Data Normalization........................................................................................................14
LO2 Develop a fully functional relational database system...................................................19
P2. Develop the database system using MS SQL Server 2014........................................19
Relationship diagram.....................................................................................................19
Design view of tables....................................................................................................20
P3. Produce a query language, with queries across multiple tables for the database.......27
M2.................................................................................................................................... 31
LO3 Test the system against user and system requirements:..............................................32
P4 Create a test plan to test the database:.......................................................................32
M4 Create and populate tables, validation, verification, data types and referential integrity
......................................................................................................................................... 36
LO4 Produce technical and user documentation..................................................................38
P5. Produce fully technical and user documentation for your designed database for VET
SOLUTION Company.......................................................................................................38
1

User documentation......................................................................................................38
Technical documentation..............................................................................................45
M5 Produce technical and user documentation for a fully functional system, including
diagrams showing movement of data...............................................................................50
Conclusion........................................................................................................................... 51
References........................................................................................................................... 52
List of figures
Figure 1 ER diagram.............................................................................................................. 8
Figure 2 Data validation 1.......................................................................................................9
Figure 3 Data validation 2.....................................................................................................10
Figure 4 relationship diagram...............................................................................................19
Figure 5 owner design view..................................................................................................20
Figure 6 owner datasheet view.............................................................................................20
Figure 7 owner pet design view............................................................................................20
Figure 8 owner pet datasheet view.......................................................................................20
Figure 9 Vet appointment design view..................................................................................21
Figure 10 vet appointment datasheet view...........................................................................21
Figure 11 Vet bill design view...............................................................................................21
Figure 12 vet bill datasheet view..........................................................................................21
Figure 13 vet branch design view.........................................................................................22
Figure 14 vet branch datasheet view....................................................................................22
Figure 15 vet consultation design view.................................................................................22
Figure 16 vet consultation datasheet view............................................................................23
Figure 17 Vet department design view.................................................................................23
Figure 18 vet department datasheet view.............................................................................23
Figure 19 Vet drug design view............................................................................................23
Figure 20 vet drug datasheet view........................................................................................24
Figure 21 vet manager design view......................................................................................24
Figure 22 vet manager datasheet view.................................................................................24
Figure 23 Vet prescription design view.................................................................................24
Figure 24 vet prescription datasheet view............................................................................25
Figure 25 vet staff design view.............................................................................................25
Figure 26 vet staff datasheet view........................................................................................25
Figure 27 Vet treatment design view....................................................................................25
2

Figure 28 vet treatment datasheet view................................................................................26
Figure 29 vet bill details design view....................................................................................26
Figure 30 vet bill details datasheet view...............................................................................26
Figure 31 Query 1................................................................................................................ 27
Figure 32 query 2................................................................................................................. 27
Figure 33 query 3................................................................................................................. 28
Figure 34 query 4................................................................................................................. 28
Figure 35 query 5................................................................................................................. 29
Figure 36 query 6................................................................................................................. 29
Figure 37 query 7................................................................................................................. 30
Figure 38 Test case 1...........................................................................................................32
Figure 39 Test case 2...........................................................................................................33
Figure 40 Test case 3...........................................................................................................33
Figure 41 Test case 4...........................................................................................................34
Figure 42 Test case 5...........................................................................................................35
Figure 43 Validation 1.......................................................................................................... 36
Figure 44 validation 2........................................................................................................... 37
Figure 45 treatment table.....................................................................................................38
Figure 46 Vet staff table.......................................................................................................38
Figure 47 prescription table..................................................................................................39
Figure 48 Manager table......................................................................................................39
Figure 49 drug table............................................................................................................. 39
Figure 50 Department details...............................................................................................40
Figure 51 consultation table.................................................................................................40
Figure 52 Branch table.........................................................................................................40
Figure 53 Bill details table....................................................................................................41
Figure 54 Bill ID.................................................................................................................... 41
Figure 55 Appointment table................................................................................................41
Figure 56 pet table............................................................................................................... 41
Figure 57 owner table...........................................................................................................42
Figure 58 Query 1................................................................................................................ 43
Figure 59 Query 2................................................................................................................ 43
Figure 60 query 3................................................................................................................. 44
Figure 61 Query 4................................................................................................................ 44
Figure 62 query 5................................................................................................................. 45
Figure 63 owner design view................................................................................................45
Figure 64 owner pet design view..........................................................................................45
3

Figure 65 Vet appointment design view................................................................................45
Figure 66 Vet bill design view...............................................................................................46
Figure 67 vet branch design view.........................................................................................46
Figure 68 vet consultation design view.................................................................................46
Figure 69 Vet department design view.................................................................................46
Figure 70 Vet drug design view............................................................................................47
Figure 71 vet manager design view......................................................................................48
Figure 72 Vet prescription design view.................................................................................48
Figure 73 vet staff design view.............................................................................................48
Figure 74 Vet treatment design view....................................................................................48
Figure 75 vet bill details design view....................................................................................49
Figure 76 Relationship diagram............................................................................................49
Figure 77 functional dependency.........................................................................................50
List of tables
Table 1 Data dictionary........................................................................................................10
Table 2 1 NF........................................................................................................................ 16
Table 3 2 NF........................................................................................................................ 17
Table 4 3 NF........................................................................................................................ 18
Table 5 Test cases............................................................................................................... 32
4

Introduction
This report fundamental target is to outline and build up the VET solution database of
Cambridgeshire. The VET solution is an organization that offers veterinary services that give
the care administrations to animals. The organization requires a database for data
stockpiling, recovery, and refresh and adjust. It can be overseen by building up a database
administration framework in organization. In addition, organization requires a database for
enhancing the correspondence and data distribution amongst the Company. The designed
database for the organization will be created utilizing the software name MS SQL server
2014 which gives incredible database administration belongings to the organization. This
report will incorporate an outlining system of the VET solution database, improvement of
database and testing of the database. Lastly, a technical document and full user
documentation will be accommodated of the planned database.
5

LO1 Use an appropriate design tool to design a relational database
system for a substantial problem
P1. Design a relational database system using appropriate design tools
and techniques
For planning the VET arrangement organization's database, initially a suitable outlined will
be set up as the model like ERD chart utilizing a planning instrument. The organization VET
solution is expanding its outlet in various nations, it is important for organization to move to
the database administration framework. The clients and employee of the organization are
expanding step by step so to deal with this circumstance organization chooses to move to
the database administration framework rather than the database done manually on paper.
Organization needs a database which could include and adjust the patient points of interest
and employee detail, likewise, the distinct database must deal with the data of all the VET
solution branches. It is required to build a database for making an appropriate printed invoice
for the clients (Oracle, 2017).
Requirement of database administration framework
The vital goal of an organization to picks the database administration framework is to create
and protect the relationship that is present in the VET solution organization information
(Elmasri, and Navathe, 2010).
Client Requirement
 It is necessary for the database to have the capacity to alter the data embedded.
 Database made must record and oversee detail data of Pets (i.e. patients).
 Database must be ready to manage and add the employee record.
 Database made must record and oversee detail data of Owners to which the pet
belongs too.
 Database made ought to have the capacity to include and deal with the receipt subtle
elements to Owner of the pet for medicines of their pet.
 Database must have the capacity to manage and add the bill details of pets at all
centers of VET solution.
 Database must have the capacity to manage and include all the pet details like
treatment given, diagnosis done, drugs and more.
 Database must have the capacity to include and deal with the points of interest of
administrations (i.e. services) offer to pet.
6

Framework Requirement
For planning and dealing with the database, a framework with several requirements is
essential. There are certain software and programming necessities for building up the
database for the VET solution;
 Database needs to work proficiently and adequately.
 Database ought to have unmistakable recognizable proof and proper introduction
including name, address, contact etc.
 Database must have the capacity to perform quickly and have great ease of use
(Stonebraker, Deng and Brodie, 2017).
For database development of the VET solution some hardware and software requirements
are;
Software Requirements
a. Windows or Linux operating system.
b. MS SQL server
c. Several tools for designing like UML, draw.io.
Hardware requirements
a. Minimum size of hard disk must be 2GB.
b. Minimum 2GB of RAM.
c. Processor of either 32 or 64-bit.
d. Display resolution of 1024*468.
ER diagram
It is an abbreviation for entity relationship chart. ER graph is the best top-down methodology
for planning the database for organizations. It is the theoretical graph that is utilized to
characterize the connection among the few entities. For constructing an ER chart first the
elements are distinguished and subsequently, the relations are found among the recognized
entities. Certain more information is included for every element called traits which
characterizes the attributes of an Entity (Datanamic, 2017).
Entity
It is an accumulation of items having comparative qualities that are, distinguished by an
association as having an unrestricted presence.
Attribute:
Each identified entity has particular qualities called as attributes.
7

Relationship
There is a connection among the entity that is recognized as a connection. The relation may
be of various cardinality proportions that are coordinated, many to many and many to one.
Figure 1 ER diagram
8

M1 Produce a comprehensive design for a fully functional system
Data Validation
Validation of information is required for the information execution, confirmation, and
approach for sorted out information (Dave, 2014). There are diverse kinds of approval
 Verification of the data type
 Verification of code
 Verification of imperative
 Verification of structure.
Figure 2 Data validation 1
9
Patient ID cannot
be null

Figure 3 Data validation 2
Data Dictionary
Data dictionary is a lattice of information description. It is an arrangement of information that
is stored in the database to make them meaningful. It is utilized to extricate the important
information from the showed data. Information dictionary includes diverse components that
are;
 Table name
 Attribute
 Type of attribute and
 Attribute description (Agiledata, 2017).
Table 1 Data dictionary
Table name Attribute Data type Description PK/FK
Vet
consultation
consultation ID Int Unique identity of
consultation
PK
Consultation charge Int Consultation Fees
Consultation type Text Type of consultation
Owner pet Pet identity Int Unique identity of pet PK
color Text Pet color
10
Length of salary is
fixed.

Type Text Pet type
Sex Text Pet gender
breed Text Description of pet
problem Text Issue with the pet
Owner ID Int Unique identity of owner FK
owner Pet owner ID Int Unique identity of owner PK
Name nvarchar(50) Owner’s name
Contact nvarchar(50) Owner’s telephone
number
suburb nvarchar(50) Owners address or area
Vet
appointment
ID appointment Int Unique identity of
appointment
PK
Clinic ID Int Unique identity of clinic FK
status Text Appointment status
Vet bill
details
bill details ID Int Unique identity of bill
details
PK
bill ID int Unique identity of bills FK
Drug ID int Unique identity of the
drug
FK
Consultation ID int Unique identity of
consultation
FK
Treatment ID Int Unique identity of
treatment
FK
Prescription ID Int Unique identity of
prescription
FK
Vet Staff Vet staff ID Int Unique identity of staff PK
11

Clinic ID int Unique identity of the
clinic
Department ID int Unique identity of
department
Number members Int Total number of members
Vet branch Clinic ID Int Unique identity of the
clinic
PK
Name nvarchar(50) Clinic’s name
Suburb nvarchar(50) Area of the Clinic
location Text Clinic’s location
Vet drug Drug ID Int Unique identity of the
drug
PK
Drug name Text Name of the drug
Drug charge nvarchar(50) Drug cost
Vet bill Bill ID int Unique identity of the bill PK
Owner ID int Unique identity of the
owner
Clinic ID int Unique identity of the
clinic
FK
Date Date Date of the bill
Vet
department
Department ID int Unique identity of
department
PK
Department name text Name of the department
Vet
prescription
Prescription ID int Unique identity of
prescription
PK
Prescription detail Text Details of the prescription
Prescription charge int Charges to be paid.
12

Vet manager Manager ID int Unique identity of
manager
PK
Manager name Text Manager’s name
Manager age Int Manager’s age
Salary nvarchar(50) Salary of the manager
Clinic ID int Unique identity of the
clinic
FK
Vet
treatment
Treatment ID int Unique identity of
treatment
PK
Treatment name nvarchar(50) Treatment name
Treatment charge int Charges of the treatment
Data Normalization
It is done to conquer the entanglements of the un-standardization frame. It is utilized to expel
excess. It deteriorates the table to expel inconsistencies from the database. Here is the
standardization improved the situation the VET arrangement (Essential SQL, 2017).
Un-normalization
consultation ID
Consultation charge
Consultation type
color
Type
Sex
breed
problem
Owner ID
Pet owner ID
13

Name
Contact
suburb
ID appointment
status
bill details ID
Prescription ID
Vet staff ID
Department ID
Number members
Name
Suburb
location
Drug ID
Drug name
Drug charge
Date
Department ID
Department name
Prescription ID
Prescription detail
Prescription charge
Manager ID
Manager name
Manager age
Salary
14

Treatment ID
Treatment name
Treatment charge
1-NF
Table 2 1 NF
Vet Staff Owner Vet treatment
Vet staff ID Pet identity consultation ID
Clinic ID color Consultation charge
Department ID Type Consultation type
Number members Sex ID appointment
Clinic ID breed Clinic ID
Name problem status
Suburb Pet owner ID Drug ID
location Name Drug name
Department ID Contact Drug charge
Department name suburb Prescription ID
Manager ID Bill ID Prescription detail
Manager name Prescription charge
Manager age Treatment ID
Salary Treatment name
Treatment charge
2-NF
Table 3 2 NF
Vet Staff Owner Vet treatment Veterinary
procedures
Vet staff ID Pet identity Treatment ID consultation ID
15

Clinic ID color Treatment name Consultation charge
Department ID Type Treatment charge Consultation type
Number members Sex ID appointment
Clinic ID breed Clinic ID
Name problem status
Suburb Pet owner ID Drug ID
location Name Drug name
Department ID Contact Drug charge
Department name suburb Prescription ID
Manager ID Bill ID Prescription detail
Manager name Prescription charge
Manager age
Salary
3-NF
Table 4 3 NF
Vet consultation Owner pet Owner Vet
appointment
Vet bill details
consultation ID Pet identity Pet owner ID ID appointment bill details ID
Consultation
charge
color Name Clinic ID bill ID
Consultation type Type Contact status Drug ID
Sex suburb Consultation ID
breed Treatment ID
problem Prescription ID
Owner ID
Vet Staff Vet branch Vet drug Vet bill Vet department
16

Vet staff ID Clinic ID Drug ID Bill ID Department ID
Clinic ID Name Drug name Owner ID Department
name
Department ID Suburb Drug charge Clinic ID
Number members location Date
Vet prescription Vet manager Vet treatment
Prescription ID Manager ID Treatment ID
Prescription detail Manager name Treatment name
Prescription
charge
Manager age Treatment
charge
Salary
Clinic ID
17

LO2 Develop a fully functional relational database system
P2. Develop the database system using MS SQL Server 2014.
Figure 4 relationship diagram
Relationship diagram
In such kind of database data is in form of tables that is in tuples and columns. Every table in
the diagram is related in a way that few relations present between them. Distinctive
assignments are achieved by information a table that is looking at, revealing and arranging.
For connection with SQL database dialect is utilized. It is useful to utilize the social database
since it gives simple administration, adaptability, straightforward information extraction and
distinctive check and approval of information for ensuring it (Skymark, 2017)
18

Design view of tables
Owner
Figure 5 owner design view
Figure 6 owner datasheet view
Owner pet
Figure 7 owner-pet design view
Figure 8 owner-pet datasheet view
19

Vet appointment
Figure 9 Vet appointment design view
Figure 10 vet appointment datasheet view
Vet bill
Figure 11 Vet bill design view
20

Figure 12 vet bill datasheet view
Vet branch
Figure 13 vet branch design view
Figure 14 vet branch datasheet view
Vet consultation
Figure 15 vet consultation design view
21

Figure 16 vet consultation datasheet view
Vet department
Figure 17 Vet department design view
Figure 18 vet department datasheet view
Vet drug
Figure 19 Vet drug design view
22

Figure 20 vet drug datasheet view
Vet manager
Figure 21 vet manager design view
Figure 22 vet manager datasheet view
Vet prescription
Figure 23 Vet prescription design view
23

Figure 24 vet prescription datasheet view
Vet staff
Figure 25 vet staff design view
Figure 26 vet staff datasheet view
Vet treatment
Figure 27 Vet treatment design view
24

Figure 28 vet treatment datasheet view
Vet bill details
Figure 29 vet bill details design view
Figure 30 vet bill details datasheet view
25

P3. Produce a query language, with queries across multiple tables for
the database.
Query 1:
Implement the query for finding the owner name and the pet associated with it and the
status of appointment and the clinic name and location where the appointment is
made.
SELECT dbo.owner.name AS owner_name, dbo.owner_pet.pet_identity,
dbo.vet_appointment.status, dbo.vet_branch.name AS clinc_name, dbo.vet_branch.location
FROM dbo.owner INNER JOIN dbo.owner_pet ON dbo.owner.pet_owner_id =
dbo.owner_pet.owner_id INNER JOIN dbo.vet_appointment ON dbo.owner_pet.pet_identity
= dbo.vet_appointment.patient_id INNER JOIN dbo.vet_branch ON
dbo.vet_appointment.clinic_id = dbo.vet_branch.clinic_id
Figure 31 Query 1
Query 2:
Implement the query for finding the clinic identity and total staff of the clinic.
SELECT dbo.vet_branch.clinic_id, COUNT (dbo.vet_staff.vet_staff_id) AS no_of_staff
FROM dbo.vet_branch INNER JOIN dbo.vet_staff ON dbo.vet_branch.clinic_id =
dbo.vet_staff.clinc_id INNER JOIN dbo.vet_department ON dbo.vet_staff.department_id =
dbo.vet_department.department_id GROUP BY dbo.vet_branch.clinic_id
Figure 32 query 2
26

Query 3:
Implement the query for finding the maximum salary and its associated manager at
the clinic and clinic id and the area code.
SELECT MAX(dbo.vet_manager.salary) AS Expr1, dbo.vet_manager.clinic_id,
dbo.vet_branch.suburb, dbo.vet_manager.manager_id FROM dbo.vet_branch INNER
JOIN dbo.vet_manager ON dbo.vet_manager.clinic_id = dbo.vet_branch.clinic_id GROUP
BY dbo.vet_manager.clinic_id, dbo.vet_manager.manager_id, dbo.vet_branch.suburb
Figure 33 query 3
Query 4:
Implement the query for finding the invoice of the owner that includes the dates, bill
number, name of owner, contact number, problem associated with pet and its identity
number, type of pet and its breed.
SELECT dbo.vet_bill.date, dbo.vet_bill.bill_id, dbo.owner.name AS owner_name,
dbo.owner.contact, dbo.owner_pet.problem, dbo.owner_pet.pet_identity,
dbo.owner_pet.breed, dbo.owner_pet.type FROM dbo.vet_bill INNER JOIN dbo.owner
ON dbo.vet_bill.owner_id = dbo.owner.pet_owner_id INNER JOIN dbo.owner_pet ON
dbo.vet_bill.patient_id = dbo.owner_pet.pet_identity AND dbo.owner.pet_owner_id =
dbo.owner_pet.owner_id
Figure 34 query 4
Query 5:
27

Implement the query for finding the owner details and the bill id and date associated
with owner and name, location and area code of that branch.
SELECT dbo.owner.name, dbo.owner.contact, dbo.owner.suburb, dbo.vet_bill.date,
dbo.vet_branch.location, dbo.vet_branch.name AS Expr1, dbo.vet_bill.bill_id FROM
dbo.owner INNER JOIN dbo.vet_bill ON dbo.owner.pet_owner_id = dbo.vet_bill.owner_id
INNER JOIN dbo.vet_branch ON dbo.vet_bill.Clinic_id = dbo.vet_branch.clinic_id
Figure 35 query 5
Query 6:
Implement the query for finding the owner details that is name, area code and contact
of owner.
SELECT dbo.owner.name, dbo.owner.suburb, dbo.owner.contact FROM dbo.owner
INNER JOIN dbo.owner_pet ON dbo.owner.pet_owner_id = dbo.owner_pet.owner_id
WHERE (dbo.owner_pet.type LIKE '%dog%')
Figure 36 query 6
Query 7:
Implement the query for finding the bill details and drug and prescription details
associated with the bill.
SELECT dbo.vet_bill.bill_id, dbo.vet_bill.owner_id, dbo.vet_drug.drug_charge,
dbo.vet_drug.drug_name, dbo.vet_prescription.prescription_detail,
dbo.vet_prescription.prescription_charge FROM dbo.vet_bill_detail INNER JOIN
dbo.vet_bill ON dbo.vet_bill_detail.bill_id = dbo.vet_bill.bill_id INNER JOIN dbo.vet_drug ON
28

dbo.vet_bill_detail.drug_id = dbo.vet_drug.drug_id INNER JOIN dbo.vet_prescription ON
dbo.vet_bill_detail.prescription_id = dbo.vet_prescription.prescription_id
Figure 37 query 7
29

M2
For the VET solution database arrangement tables are designed, to procure the principle
objective that is supported. Additionally, the field data frame is specified for each and every
field to build the safety of the database. This would safeguard the database from incorrect
entries. The client can't enter the information in wrong organization because of this. In the
event that the client enters the information in the wrong arrangement for instance if client
input the name in the wrong format that is numeric configuration than a VET solution
database framework will give an error for "wrong information organization" and section won't
be put away in the VET solution database. Additionally, the approval manage is connected
to the essential key section with the goal that no client can leave the segment vacant for the
essential important field. This would accomplish the secure database (Kadlec, 2013).
30

LO3 Test the system against user and system requirements:
P4 Create a test plan to test the database:
Table 5 Test cases
Sr. No. Test cases Expected Result Actual result
1. Input data is of incorrect
format
Data would not be stored
in the database.
The system gives an
error for incorrect input.
2. Treatment charge is
inputted in text format.
Data will not get stored in
the database.
The system gives an
error for incorrect input.
3 Patient id inserted not
follows the referential
integrity.
Data will not get input in
the database
The system gives an
error for an incorrect
input value of referential
integrity.
4 Consultation charge is
added in text format.
Charges need to be input
in integer format therefor
data will not be stored.
The system gives an
error for incorrect input.
5 Manager ID is left blank The primary key cannot be
null therefor data would not
be stored.
The system gives an
error for null value not
accepted.
31

Figure 38 Test case 1
Figure 39 Test case 2
32

Figure 40 Test case 3
Figure 41 Test case 4
33

Figure 42 Test case 5
34

M4 Create and populate tables, validation, verification, data types and
referential integrity
Verification is the way of checking the information irregularity. Information exactness is
likewise assessed in check of information.
Validation is done on information to play out the quality keep an eye on the database. It is
imperative to approve the database as it guarantees the consistency and accuracy of
information.
Some approval rules are connected on the diverse tables like invalid esteem approval is
connected to various segments of various tables (Gigl, 2017).
Figure 43 Validation 1
35
Id cannot be null

Figure 44 validation 2
36
Data type is set to
text.

LO4 Produce technical and user documentation
P5. Produce fully technical and user documentation for your designed
database for VET SOLUTION Company
User documentation
It is expected to make client documentation as this type of documentation causes end client
to effectively comprehend and utilize a database. The whole UI is incorporated into the client
documentation. The question and its yield the information recorded in the database and etc.
Here are certain table views and required information is extricated and the inquiries
executed for the essential yield (Hogan, 2018).
Figure 45 treatment table
Figure 46 Vet staff table
37
Treatment details
Staff details

Figure 47 prescription table
Figure 48 Manager table
Figure 49 drug table
38
Prescription details
Manager details
Drug details

Figure 50 Department details
Figure 51 consultation table
Figure 52 Branch table
39
Department details
Consultation details
Branch details

Figure 53 Bill details table
Figure 54 Bill ID
Figure 55 Appointment table
Figure 56 pet table
40
Bill details
Invoice details
Appointment details
Pet details

Figure 57 owner table
41
Pet owner details

Query 1:
Find the client name and their associated invoice.
SELECT MAX(salary) AS maximum_salary FROM dbo.vet_manager WHERE
(manager_id = manager_id)
Figure 58 Query 1
Query 2:
Find the maximum salary from manager.
Figure 59 Query 2
42

Query 3:
Find the pet details from the database.
Figure 60 query 3
Query 4:
Figure 61 Query 4
Query 5:
43

Figure 62 query 5
Technical documentation
In this type of documentation that is based on technical aspects, all the data is identified with
VET Solution Company is archived appropriately to assist the administration of the
organization. It incorporates the model or configuration perspectives of table and the
relationship among the tables are archived. Additionally the useful reliance is incorporated
into the specialized documentation (Harrington, 2016).
Figure 63 owner design view
Owner pet
Figure 64 owner pet design view
Vet appointment
Figure 65 Vet appointment design view
44

Vet bill
Figure 66 Vet bill design view
Vet branch
Figure 67 vet branch design view
Vet consultation
Figure 68 vet consultation design view
Vet department
Figure 69 Vet department design view
Vet drug
45

Figure 70 Vet drug design view
46

Vet manager
Figure 71 vet manager design view
Vet prescription
Figure 72 Vet prescription design view
Vet staff
Figure 73 vet staff design view
Vet treatment
Figure 74 Vet treatment design view
Vet bill details
47

Figure 75 vet bill details design view
Figure 76 Relationship diagram
48

M5 Produce technical and user documentation for a fully functional
system, including diagrams showing the movement of data
It is needed for describing the association among the identified entities uniquely. The
functional dependency graphical representation is as follows.
Figure 77 functional dependency
49

Conclusion
The database of VET solution is effectively intended for the VET arrangement veterinary
organization as indicated by the prerequisites by utilizing the device MS SQL server 2014.
Composed database of VET arrangement will diminish the information redundancy, cost and
time of the VET company database. Utilizing the database VET arrangement can without
much of a stretch store the information and concentrate the significant information at
whatever point essential. It will support in developing the VET arrangement as per the
organization's necessity. It will benefit the organization in better and fast database. The
database planned is adaptable and simple versatile and is effective to utilize.
50

References
 Agiledata 2017. Introduction to Data Normalization: A Database "Best" Practice.
[online] Agiledata. Available at: http://agiledata.org/essays/dataNormalization.html
[Accessed 1 May 2018].
 Datanamic (2017). What is an Entity Relationship Diagram (ERD)?. [online]
Datanamic. Available at: http://www.datanamic.com/support/lt-dez006-what-is-an-
erd.html [Accessed 1 May 2018].
 Dave, P. 2014. [online] sqlauthority. Available at:
https://blog.sqlauthority.com/2014/11/13/sql-server-validation-rules-code-or-
database-notes-from-the-field-054/ [Accessed 1 May 2018].
 Elmasri, R. and Navathe, S., 2010. Fundamentals of database systems. Addison-
Wesley Publishing Company.
 Essential SQL 2017. What is a SQL Server Data Dictionary. [online] Essential SQL.
Available at: https://www.essentialsql.com/what-is-a-data-dictionary/ [Accessed 1
May 2018].
 Gigl 2017. Data validation & verification – Greenspace Information for Greater
London. [online] Gigl. Available at: http://www.gigl.org.uk/data-validation-verification/
[Accessed 1 May 2018]. Harrington, J.L., 2016. Relational database design and implementation. Morgan
Kaufmann.
 Hogan, R., 2018. A Practical Guide to Database Design. Chapman and Hall/CRC.
 Kadlec, J. 2013. SQL Server Management Studio Query Designer. [online] Mssqltips.
Available at: https://www.mssqltips.com/sqlservertip/1086/sql-server-management-
studio-query-designer/ [Accessed 1 May 2018].
 Oracle 2017. A Relational Database Overview. [online] oracle. Available at:
https://docs.oracle.com/javase/tutorial/jdbc/overview/database.html [Accessed 1 May
2018].
 References
 Skymark 2017. Relations Diagrams (Interrelationship Digraphs) are usefor figuring
out where to get leverage in solving aproblem.. [online] Skymark. Available at:
http://www.skymark.com/resources/tools/relations_diagram.asp [Accessed 1 May
2018].
 Stonebraker, M., Deng, D. and Brodie, M.L., 2017. Application-Database Co-
Evolution: A New Design and Development Paradigm. New England Database Day,
pp.1-3.
51