VET Solution Database System Design and Implementation

This report details the design and implementation of a relational database system for a veterinary clinic, known as VET Solution. The system was designed using appropriate tools and techniques, including ER diagrams and data normalization. The database was implemented using MS SQL Server and tested against user and system requirements. The report includes a comprehensive data dictionary, query examples, and test cases. It also provides user and technical documentation for the system.

Database Assignment
1

List of Contents
Introduction......................................................................................................................................6
LO1 Use an appropriate design tool to design a relational database system for a substantial
problem............................................................................................................................................7
P1 Design a relational database system using appropriate design tools and techniques.................7
M1 Produce a comprehensive design for a fully functional system..............................................10
LO2 Develop a fully functional relational database system, based on an existing system
design:............................................................................................................................................18
P2 Develop and implement a fully functional database system using MS SQL Server:...............18
M2: Implement a full functional database system.........................................................................25
P3 Produce a query language, with queries across multiple tables produced earlier:...................26
M3 Produce appropriate management information.......................................................................29
LO3 Test the system against user and system requirements:........................................................30
P4 Create a test plan to test the database:......................................................................................30
M4. Assess the effectiveness of the testing...................................................................................34
LO4 User and Technical Documentation:.....................................................................................35
P5 Produce technical and user documentation..............................................................................35
M5: Produce fully functional system.............................................................................................39
Conclusion.....................................................................................................................................41
References......................................................................................................................................42
2

List of figures
Figure 1 ER diagram......................................................................................................................10
Figure 2 Treatment details table....................................................................................................16
Figure 3 staff table.........................................................................................................................17
Figure 4 presecription table...........................................................................................................17
Figure 5 animal table.....................................................................................................................17
Figure 6 owner table......................................................................................................................18
Figure 7 invoice detail table..........................................................................................................18
Figure 8 drugs table.......................................................................................................................18
Figure 9 doctor table......................................................................................................................18
Figure 10 consultation table...........................................................................................................19
Figure 11 clinic table.....................................................................................................................19
Figure 12 appointment table..........................................................................................................19
Figure 13 design data table of treatment details............................................................................20
Figure 14 design data view of staff table.......................................................................................20
Figure 15 design data view of prescription table...........................................................................20
Figure 16 design data view of pet animal table.............................................................................21
Figure 17 design data view of owner table....................................................................................21
Figure 18 design data view of invoice table..................................................................................21
Figure 19 v drug detail table..........................................................................................................22
3

Figure 20 design data view of doctor table....................................................................................22
Figure 21 v consultation table........................................................................................................22
Figure 22 design data view of clinic table.....................................................................................23
Figure 23 design data view of appointment table..........................................................................23
Figure 24 Query output 1...............................................................................................................24
Figure 25 Query output 2...............................................................................................................25
Figure 26 Query output 3...............................................................................................................25
Figure 27 Query output 4..............................................................................................................26
Figure 28 Query output 5..............................................................................................................26
Figure 29 Query output 6...............................................................................................................27
Figure 30 Query output 7...............................................................................................................28
Figure 31 Query output 8...............................................................................................................28
Figure 32Test case 1......................................................................................................................30
Figure 33 Test case 2.....................................................................................................................31
Figure 34 test case 3......................................................................................................................31
Figure 35 Test case 4.....................................................................................................................32
Figure 36 Animal table..................................................................................................................33
Figure 37 Owner table...................................................................................................................33
Figure 38 invoice detail table........................................................................................................33
Figure 39 doctor table....................................................................................................................34
Figure 40 Query report 1...............................................................................................................34
4

Figure 41 Query report 2...............................................................................................................34
Figure 42 VET solution relational diagram...................................................................................36
Figure 43 Invoice detail table design.............................................................................................37
Figure 44 Owner table design........................................................................................................37
Figure 45 Pet animal table design..................................................................................................37
Figure 46 Prescription table design...............................................................................................38
Figure 47 Treatment detail table design........................................................................................38
List of tables
Table 1 Example Of Primary Key...................................................................................................8
Table 2 Example of foreign key......................................................................................................8
Table 3 Data dictionary table.........................................................................................................11
Table 4 Un-normalized table.........................................................................................................13
Table 5 1NF table..........................................................................................................................13
Table 6 2NF table..........................................................................................................................14
Table 7 3NF table..........................................................................................................................15
Table 8Test case table....................................................................................................................29
5

Introduction
In this project assignment, the report is designed and developed for the management of
database system that can be provided by the company UKKOM LTD at Cambridge shire that
has experience of many years in the electronic database. Tshis database can be built to help
staff for updating of data and provide security and reliability to the database. To meet the
requirement of the company it can be built.
The database administration framework after execution effectively, send for testing and
approving information data utilizing different experiments and furnished all data in this report
with illustrations.
6

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.
Roles and particular of VET arrangement of Database System:
A course of action of VET arrangement Database is used to administer whole data inside an
association by securing huge measures of data. Programming application is using the tables
of the relational database. It decreases data redundancy and presents data in an inducing way
that assistants incapable essential administration. It improves the execution of a structure and
gives advance worked in examination functionalities. The VET arrangement database tables
likewise give assistance to keep up information data by putting away in database stockroom
to get whenever through application level (Deque, 2017).
Tools & techniques of a relational database are:
Relational Database: It is the most generally perceived sort of DBMS. In this, data is put
away as tables. Application programming used for information arranging in data in tables is
MS SQL Server. It is generally called Standard Query Language which called SQL (spin-
off). Relational databases much of the time drive the association between fundamental and
web-enabled applications essential for gaining ground in an incredibly forceful market. It is
intended to pass on the reason for building and works with the social information parts and
enabling to make and use social databases in nature (Done, 2013).
Relational Database logical design:-
Logical data model information display is required in starting to design a VET course of
action physical database. Also, the steady data demonstrate winds up out of a sensible data
show. In addition, distinctive sort of data indicate starts with the planning of data show. The
coherent information display arranges formalizes the entities, or attributes and the objects.
Another basic endeavor of logical data modeling information demonstrating is to ensure that
model entity are balanced by ascribes that exceptionally identify with them. No attribute
7

should appear in an element unless it portrays the uniqueness identifier for the substance
which is the essential key.
ER-Diagram
These are substance relationship outlines which are utilized for pictorial portrayal or
comprehension of information data shared among various elements. An outline work permits
the administrator to see the connections between different substances known as ER chart.
Element (Entity):
An entity is a piece of substance exists in the database. It doesn't need to do anything; it
basically needs to exist. In database affiliation, a component can be an alone thing,
individual, place, or question. Information can be secured about such substance.
Attribute (Quality):
An attribute portrays the information about the element that ought to be secured. In the
database that the element is a specialist, properties could fuse name, individual ID, prosperity
plan enrollment, and work zone. An entity will have no less than zero attributes, and each one
of those ascribes applies just to that entity (ComputerScience, 2018).
Relationship:
A relationship depicts the connection between entities or tables in a database and it is spoken
to by precious diamond shape and it has numerous types.
Data Elements
It is the type of elements that contain the information of data like database attributes that can
be specified by their data types.
Data Types:
The information compose is utilized to characterize what sort of data is putting in which
database, for example, whole number, coast, character, string or more. Fundamentally, it
characterizes the sort of factor which is utilized as a part of the database.
8

Indexing:
Indexing is utilized for finding the area of data put in the database by giving the key to them
or a few pointers or address.
Primary (Essential)/Foreign Key:
A primary key is a piece of candidate key to characterizing its property is one of a kind in the
database and remote key is utilized in the interest of the primary key in another table to give a
connection between them.
Table 1 Example Of Primary Key
Table 2 Example of foreign key
VET solution system database entity relationship diagram:
For Vet database arrangement is planned with seven tables which will be made to build up a
database for putting away data of the program in the database. These tables are interrelated
with making the association between them. The beneath figure is delivered by the engineer
and structure requirements
9

Figure 1 ER diagram
M1 Produce a comprehensive design for a fully functional system
Integrity of data:
This is the basic snippet of security of data. In the utilization of broadcast, "Information
honesty" suggests the exactness and uniformity of informational collection missing in the
database, information warehouse, information store or another frame. Data Integrity could be
10

utilized to depict a method, an express or a limit – and is reliably used as a center individual
for "information quality". Data respects are sorted out by a data show and furthermore, data
composes (Ioffe, 2015).
Validation of data:
While using SQL, approval of information data is a piece of a VET arrangement database.
The main factors of data respectability are imperatives and the erase and refresh choices. In
SQL the major necessities are checked, interesting, not an invalid, and essential limitations.
The checked restrictions are used for confirmation that a declaration almost the data is
legitimate for completely lines in a table. The novel limitation guarantees that no 2 lines have
comparative characteristics in that segment. Not valid imperative is put on the portion &
communicates that in the area where data are required (Database Management, 2018).
Data dictionary:
It is a standout among a most basic portion of a VET arrangement database. In its data word
reference, which is observed only the table’s arrangement for that gives the information about
the database? A word reference for information contains the meanings of all diagram
challenges in the database (tables, ordering, gatherings, groups, bundles, triggers, and so
forth), memory required, the example objects, column, default regards for segments,
uprightness basic data, name of clients, benefits, and parts for each client has been in all
actuality, reviewing information (Studytonight, 2018).
Table 3 Data dictionary table
Table name Attribute Description Data type Key
Pet_animal Petanimal_id Identity of animal Integer Primary
Owner_id Identity of owner Integer Foreign
Sex type of person or
gender
Char
Animal_type Type of animal Char
11

age Age of animal Integer
Appointment Appointment_id Id of appointment Integer Primary
Doctor_id Doctor id Integer Foreign
Owner_id Id of owner Integer Foreign
Petanimal_id Id of anima Integer Foreign
Appointment_date Date of
appointment
Date
Owner Owner_id Id of owner Integer Primary
Owner_fname First name of
owner
Char
Ownwe_lname Last name of
owner
Char
Owner_contact Contact details of
owner
Integer
Owner_address Address of owner Varchar
Staff Staff_id Identity of staff Integer Primary
Clinic_id Identity of clinic Integer Foreign
Staff_domain Staff are of work
Clinic Clinic_id Id of clinic Integer Primary
Clinic_name Name of clinic Char
Clinic_contact Phone no. of clinic Integer
Clinic_location Location of Varchar
12

clinic
Clinic_suburb Suburb of clinic Varchar
Doctor_id Id of doctor Integer Foreign
Drugs Drug_id Id of drug Integer Primary
Drug_charge Charge of drug Integer
Date Date on drugs Date
Petanimal_id Animal identity Integer Foreign
Doctor
Doctor Id Doctor Identity Integer Primary key
Doc_name Name Varchar
Doc_Specialist Specification Varchar
Doc_age age of doctor Integer
Address Varchar
Contact Integer
Salary Integer
Prescription
Prescription_id Identity Integer Primary key
Date show the working
time
Date
Prescription_charge Amount Integer
Petanimal_id animal registration Integer
Data Normalization:
13

It is utilized for masterminding information in the best possible organization of relations by
following the properties of 1NF, 2NF and 3NF which are sorts of standardization to decrease
redundancy and gives integrity of data and it likewise gives best outcomes in optimized route
for the database. Now, first accumulate the information to build up the database which is in
the un-normalized frame (Panthon, 2018):
Table 4 Un-normalized table
Participants
Doctor_id Appointment_id Doc_address Petanimal_id
Doc_name Prescription_id Doc_contact Treatment_id
Doc_specialist Invoice_id Age Treatment_charge
Doc_age Consultation_id Animal_type Treatment_date
Doc_salary Appointment_date Sex Drug_charge
Doc_address Treatment_id Prescription_charge Doctor_id
Doc_contact Petanimal_id Prescription_id Doc_name
Age Consultation_charge Date Doc_specialist
Animal_type Owner_id Staff_id Doc_age
Sex Owner_fname Staff_domain Ownwe_lname
1NF: In 1NF form, the data should be in atomic form and no redundancy is present.
Table 5 1NF table
Clinic doctor Staff Appointment owner
Clinic_id Doctor_id Staff_id Appointment_id Owner_id
Clinic_ name Doc_name Staff_domain Prescription_id Owner_fname
14

Clinic_contact Doc_specialist treatment_detail
s
Invoice_id Ownwe_lname
Clinic_locatio
n
Doc_age Petanimal_id Consultation_id Owner_contact
Clinic_suburb Doc_salary Treatment_id Appointment_date Owner_address
Date Doc_address Treatment_char
ge
Treatment_id Prescription_charg
e
Petanimal_id Doc_contact Treatment_date Petanimal_id Prescription_id
Drug_id age Consultation_charg
e
Date
Drug_charge Animal_type
Sex
2NF: The data should already be present in 1NF and no partial dependency is allowed.
Table 6 2NF table
Clinic doctor Staff Appointment owner
Clinic_id Doctor_id Staff_id Appointment_id Owner_id
Clinic_ name Doc_name Clinic_id Doctor_id Owner_fname
Clinic_contact Doc_speciali
st
Staff_domain Owner_id Ownwe_lname
Clinic_locatio
n
Doc_age treatment_details Petanimal_id Owner_contact
Clinic_suburb Doc_salary Treatment_id Appointment_date Owner_address
Doctor_id Doc_address Treatment_charge Consultation_details prescription
15

Petanimal_id Doc_contact Treatment_date Consultation_id Prescription_id
Drug_id age Petanimal_id Consultation_charge Date
Drug_charge Animal_type Invoice_details Petanimal_id Prescription_charge
Date Owner_id Treatment_id
Sex Consultation_id
Owner_id
Invoice_id
Petanimal_id
Prescription_id
3NF: In 3NF data are already pass through 1NF & 2NF and the transitivity and complexity
are solved in this type.
Table 7 3NF table
Clinic doctor Staff Appointment owner
Clinic_id Doctor_id Staff_id Appointment_id Owner_id
Clinic_ name Doc_name Clinic_id Doctor_id Owner_fname
Clinic_contact Doc_specialis
t
Staff_domain Owner_id Ownwe_lname
Clinic_location Doc_age treatment_details Petanimal_id Owner_contact
Clinic_suburb Doc_salary Treatment_id Appointment_date Owner_address
Doctor_id Doc_address Treatment_charge Consultation_details prescription
16

Drugs Doc_contact Treatment_date Consultation_id Prescription_id
Drug_id Pet_animal Petanimal_id Consultation_charge Date
Drug_charge Petanimal_id Petanimal_id Petanimal_id Prescription_charge
Date Owner_id Invoice_details Petanimal_id
Petanimal_id Sex Invoice_id
Animal_type Petanimal_id
age Drugs_id
Treatment_id
Consultation_id
Owner_id
Prescription_id
17

LO2 Develop a fully functional relational database system, based on an
existing system design:
P2 Develop and implement a fully functional database system using MS SQL
Server:
Relational database: It is an arrangement of tables which shows the relationship between the
entities in the database. In predefined class’s information is stored in the database. Each table
contains at least one relation and the information of a class in the form of segments. It is the
most basic type of database design which can be mainly used to view the relations between
the elements and their attribute associated with that.
To design a relational database a user should use the utilities of MS SQL server of 2014
edition. Database produced in this are robust & secure with stored and data field required
with the specified information (Teach-ict, 2018).
Figure 2 Treatment details table
Figure 3 staff table
18

Figure 4 prescription table
Figure 5 animal table
Figure 6 owner table
Figure 7 invoice detail table
19

Figure 8 drugs table
Figure 9 doctor table
Figure 10 consultation table
20

Figure 11 clinic table
Figure 12 appointment table
Figure 13 design data table of treatment details
21

Figure 14 design data view of the staff table
Figure 15 design data view of the prescription table
Figure 16 design data view of pet animal table
22

Figure 17 design data view of owner table
Figure 18 design data view of invoice table
Figure 19 v drug detail table
23

Figure 20 design data view of doctor table
Figure 21 v consultation table
Figure 22 design data view of clinic table
24

Figure 23 design data view of appointment table
M2: Implement a full functional database system
Executing the database and to examine above have been planned to achieve upkeep
destinations as delineated in client necessities. The specific data composes for each
characteristic of elements will make it more secure and keep waste esteem data from securing
the database. For example, if an engineer enters a character and int information compose field
then the data won't be added to the database. Moreover, the essential key given to each
component in a substance set will be used to perceive a particular inquiry or component from
the different things and these fields can't be left clear. The security of the system will be
checked time to time by the usage of an essential key as no unapproved or not legitimate
individual will ever get induction to the database only like interlopers (SearchSQLServer,
2018).
25

P3 Produce a query language, with queries across multiple tables produced
earlier:
The query contains a set of operation that can be applied to the database tables the operations
like update, insert, delete and find. The query language is used to separate the information in
the database for utilizing the structured query. The query can be controlled by the user in the
required manner. SQL is used for composing the queries in the relational database (Deque,
2017).
Query 1
SELECT dbo.owner.owner_fname, dbo.owner.owner_lname, dbo.owner.owner_contact,
dbo.owner.owner_address, dbo.pet_animal.animal_type, dbo.pet_animal.age FROM
dbo.owner INNER JOIN dbo.pet_animal ON dbo.owner.owner_id =
dbo.pet_animal.owner_id
Figure 24 Query output 1
Query 2
SELECT dbo.clinic.clinic_name, dbo.clinic.clinic_location, dbo.doctor.doc_age,
dbo.doctor.doc_name, dbo.doctor.doc_salary, dbo.doctor.doc_address FROM dbo.clinic
INNER JOIN dbo.doctor ON dbo.clinic.doctor_id = dbo.doctor.doctor_id
26

Figure 25 Query output 2
Query 3
SELECT dbo.clinic.clinic_name, dbo.staff.staff_domain FROM dbo.clinic INNER JOIN
dbo.staff ON dbo.clinic.clinic_id = dbo.staff.clinic_id
Figure 26 Query output 3
Query 4
SELECT dbo.presecription.prescription_charge, dbo.presecription.date,
dbo.treatment_details.treatment_date, dbo.treatment_details.treatment_charge,
dbo.pet_animal.sex, dbo.pet_animal.animal_type, dbo.pet_animal.petanimal_id
FROM dbo.pet_animal INNER JOIN dbo.presecription ON dbo.pet_animal.petanimal_id
= dbo.presecription.petanimal_id INNER JOIN dbo.treatment_details ON
dbo.pet_animal.petanimal_id = dbo.treatment_details.petanimal_id
Figure 27 Query output 4
27

Query 5
SELECT dbo.owner.owner_fname, dbo.owner.owner_lname,
dbo.appointment.appointment_date, dbo.doctor.doc_name, dbo.owner.owner_contact
FROM dbo.appointment INNER JOIN dbo.doctor ON dbo.appointment.doctor_id =
dbo.doctor.doctor_id INNER JOIN dbo.owner ON dbo.appointment.owner_id =
dbo.owner.owner_id
Figure 28 Query output 5
Query 6
SELECT dbo.drugs_details.drugs_charge, dbo.drugs_details.date, dbo.owner.owner_fname,
dbo.owner.owner_lname, dbo.owner.owner_address, dbo.pet_animal.animal_type,
dbo.pet_animal.age FROM dbo.drugs_details INNER JOIN dbo.pet_animal ON
dbo.drugs_details.petanimal_id = dbo.pet_animal.petanimal_id INNER JOIN dbo.owner ON
dbo.pet_animal.owner_id = dbo.owner.owner_id
Figure 29 Query output 6
Query 7
SELECT dbo.treatment_details.treatment_charge, dbo.treatment_details.treatment_date,
dbo.presecription.prescription_charge, dbo.presecription.date, dbo.drugs_details.date AS
drugs_date, dbo.drugs_details.drugs_charge, dbo.consultation_details.consultation_charge
FROM dbo.consultation_details INNER JOIN dbo.invoice_details ON
28

dbo.consultation_details.consultation_id = dbo.invoice_details.consultation_id INNER JOIN
dbo.drugs_details ON dbo.invoice_details.drugs_id = dbo.drugs_details.drugs_id INNER
JOIN dbo.presecription ON dbo.invoice_details.prescription_id =
dbo.presecription.prescription_id INNER JOIN dbo.treatment_details ON
dbo.invoice_details.treatment_id = dbo.treatment_details.treatment_id
Figure 30 Query output 7
Query8
SELECT dbo.doctor.doc_name, dbo.clinic.clinic_name, dbo.clinic.clinic_location,
dbo.doctor.doc_specialist, dbo.owner.owner_fname, dbo.owner.owner_lname,
dbo.owner.owner_address FROM dbo.appointment INNER JOIN dbo.owner ON
dbo.appointment.owner_id = dbo.owner.owner_id INNER JOIN dbo.doctor ON
dbo.appointment.doctor_id = dbo.doctor.doctor_id INNER JOIN dbo.clinic ON
dbo.doctor.doctor_id = dbo.clinic.doctor_id
Figure 31 Query output 8
M3 Produce appropriate management information.
This report contains the data management information for implementation of queries same
like above-defined queries that are important to the developer for accessing and make
changes that are required in the various queries that are implemented in the program to
distinguish assortment of specific information for various queries. It can help the developer to
implement query that becomes simple for recovering the information so that data
administrator will turn out simple (Teach, 2018).
29

LO3 Test the system against user and system requirements:
P4 Create a test plan to test the database:
Data validation:
In data validation, the data in the database are checked that it will be secure and the
information stored in that is available at the time of use. To check the reasonability and
sensibility of data in the database the data validation could perform. In data validation, the
accuracy of the available data are not check it also check how much error is present in data
and in what amount it will be useful. Different validation methods that can be done in the
database system are:
 Type checking
 Format checking
 Presence checking
 Range checking
 Length checking
Data verification:
After the migration of data different type of data is checked to determine the accuracy and the
inconsistency in data. When the data are transfer from one point to another it could check that
it will translate accurately and the new system will support. The types of data verification are
proofreading and double entry check. Proofreading is time-consuming and costly method. It
can be done by the data validation where the authorization is performed now in this the data
are verified that it can lose or not by authentication.
Table 8Test case table
Sr. no. Test Cases Expected Result Actual result
1. Data should be in fixed
format
Gives an error if month
write-in end or change in
format
Error message
generates if the user
writes the date in
numeric no. without
30

in format
2. Incremental primary key Error display if change the
manner
If the primary value
changes from
incremental manner
then an error is
displayed.
3. Primary key error by
inserting the other value
in the table
If the user enters other value
or foreign key value in the
primary key then error
display and value not stored
Value not stored in
the database.
4. Reference data deletion
error and terminate
The error evolve in query
execution
Execution of query
doesn’t work
5. Error if user enter text in
numeric type
If the user enters text in id
key value then error
generates.
Implemented
successfully the value
not insert into the
database.
6 When user create a table
with insert query
Table of the clinic should be
created
Successfully done
7 When the user wants to
show the inserted details
of clinic table
after clicking on datasheet
view, the stored information
should be displayed
Successfully done
8 When user write a query
to insert the data into a
tale
The data should be inserted
successfully
Successfully done
31

Figure 32Test case 1
Figure 33 Test case 2
32

Figure 34 test case 3
Figure 35 Test case 4
33

Figure 36 Test Case 6
Figure 37 Test Case 7
M4. Assess the effectiveness of the testing
The test cases are very useful to improve security, reliability, and performance of database
system. The test case can track where the error is generated and how the database should
handle so the user who uses can take advantage of using the database in an effective manner.
Different testing and experiment and tools are used to test the database. In this report, I have
done several testing methods. In these test cases, it will tell what table should accept what
value and should be stored in the table. Various testing types of techniques with a different
type of test cases are used to which evolve a different type of errors which are not accepting
data in statement view the SQL query will develop which will provide the robust and correct
database.
34

LO4 User and Technical Documentation:
P5 Produce technical and user documentation
User documentation: The improvement of the client documentation is left until after the
testing documentation stage is finished. In the event that it is made heretofore, parts of the
framework could change because of shortcomings being found. Client documentation is
given to the client who gives an outline of how to utilize the framework. Paper-based client
records are more often than not as a booklet or document.
The run of the mill configuration of a paper-based client record incorporates
 Technical detail like software and hardware requirement
 Index
 Technical terms glossary
 Users guide: This contains the document in bulk
 Brief introduction of a system
 Contents of table
 Troubleshooting
Client documentation is frequently utilized amid staff instructional courses keeping in mind
the end goal to acquaint the staff with both the framework and the client reports.
Figure 38 Animal table
35
Data of animal are
successfully stored

Figure 39 Owner table
Figure 40 invoice detail table
Figure 41 doctor table
Query reports:
Report 1:
Query1: SELECT * FROM Clinic
36
Data of owner are
stored successfully
owner_id
Is stored here
Salary of
doctor is here
stored

Figure 42 Query report 1
Report 1:
Query2: SELECT * FROM Doctor
Figure 43 Query report 2
Technical documentation:
"Technical documentation": With respect to the item it is a bland term. For the manufacturer
and producer, the data are passed to the general people and individuals are said that the terms
are connected with the report where the technical details of the system are specified
(Techopedia, 2018).
 Software and installation manuals
 Servicing, user, operating instructions
The term 'specialized documentation' alludes to various reports to an item with the
information related to that & data that could be utilized and put away for many purposes.
"Diverse purposes" includes definition of the product and detail, planning, fabricating,
affirmation of quality, item obligation, item introduction; the portrayal of highlights,
capacities, and interfaces; proposed, sheltered and revise utilize; administration and repair of
37
Required
output report from
query
Required
output result of
doctor

a specialized item and its protected transfer. The more extensive view, where all reports
which are created during the life cycle of an item that can be seen as the component of an
specialized documentation is positively supported.
Figure 44 Invoice detail table design
Figure 45 owner table design
Figure 46 Pet animal table design
38

Figure 47 Prescription table design
Figure 48 Treatment detail table design
M5: Produce fully functional system
Functional dependency:
A functional dependency is a useful reliance is inconsequential if Y is a subset of X. In a
table with the characteristics of worker name and Social Security number (SSN), the
representative name is practically reliant on SSN in light of the fact that the SSN is
extraordinary for singular names. An SSN recognizes the representative particularly, yet a
worker name can't recognize the SSN in light of the fact that in excess of one worker could
have a similar name (Done, 2013).
Functional dependency characterizes the Boyce-Codd typical shape and third ordinary frame.
Useful reliance is identified with a hopeful key, which interestingly distinguishes a tuple and
39

decides the estimation of every single other character in the connection. At times, practically
subordinate sets are unchangeable if:
 Functional dependency on the right-hand side can hold a single attribute.
 Functional dependency can't be decreased on the left-hand side, since this may change
the whole substance of the set.
 In any of existing functional dependency may reduce it would change the content of
set (Gigl, 2018).

40

Conclusion
This report presumes that every one of the information data is tried and approved after
execution of this framework. This framework is composed and produced by VET solution
who has encountered in electronic databases. Utilizing this database administration
framework, gave arrangement will store the approved information in determined fields
identified with them and can use in different ways. This report additionally gives information
word references to comprehend the elements and its characteristics and furthermore having
ER outline of this database framework with usefulness subordinate chart.
41

References
 Computer Science GCSE GURU. 2018. Database Validation - Computer Science
GCSE GURU. [online] Available at:
https://www.computerscience.gcse.guru/theory/database-validation [Accessed 21 May
2018].
 Database Management. 2018. Data Validation. [online] Available at:
http://databasemanagement.wikia.com/wiki/Data_Validation [Accessed 16 May
2018].
 Deque. 2017. The Importance of User Documentation: A Lesson from Deque
University. [online] Available at: https://www.deque.com/blog/user-documentation-
important/ [Accessed 21 May 2018].
 Done, W. 2013. Why is Database Testing important? How is Database Testing done?
- QE works. [online] QE works. Available at: https://qeworks.com/why-database-
testing-is-important/ [Accessed 21 May 2018].
 Gigl. 2018. Data validation & verification – Greenspace Information for Greater
London. [online] Available at: http://www.gigl.org.uk/data-validation-verification/
[Accessed 21 May 2018].
 Graubner, J. 2018. What is "technical documentation"?. [online] Transcom.de.
Available at: https://www.transcom.de/transcom/en/technische-dokumentation.htm
[Accessed 21 May 2018].
 Ioffe, S. and Szegedy, C., 2015. Batch normalization: Accelerating deep network
training by reducing internal covariate shift. arXiv preprint arXiv:1502.03167.
 Pantheon.io. 2018. Build Great Websites Pantheon. [online] Available at:
https://pantheon.io/dev-reg-tools?utm_medium=Online
%20Advertising&utm_source=AdRoll&utm_content=Dev
%20Reg&utm_ad_group_name=Web_Prospecting-
Dev_Reg&utm_campaign=2018%20AdRoll%20Prospecting [Accessed 21 May
2018].
42

 SearchSQLServer. 2018. what is relational database? - Definition from WhatIs.com.
[online] Available at: https://searchsqlserver.techtarget.com/definition/relational-
database [Accessed 21 May 2018].
 Studytonight.com. 2018. 1NF, 2NF, 3NF and BCNF in Database Normalization |
Studytonight. [online] Available at: https://www.studytonight.com/dbms/database-
normalization.php [Accessed 21 May 2018].
 Teach-ict.com. 2018. Teach-ICT A2 Level ICT OCR exam board - The System Life
Cycle. [online] Available at:
http://www.teach-ict.com/as_a2_ict_new/ocr/A2_G063/331_systems_cycle/
slc_stages/miniweb/pg20.htm [Accessed 21 May 2018].
 Techopedia.com. 2018. What is Functional Dependency? - Definition from
Techopedia. [online] Available at:
https://www.techopedia.com/definition/19504/functional-dependency [Accessed 21
May 2018].
43