ULKOM LTD: Relational Database System for VET SOLUTION Project

This document presents a comprehensive database project for VET SOLUTION, a veterinary company seeking a computerized database system to improve communication and manage paperwork. The project, undertaken by ULKOM LTD, includes an Entity Relationship (ER) diagram illustrating the database structure. It details the creation of tables using MS SQL Server, along with various SQL queries designed to retrieve and manipulate data from multiple tables. A data dictionary is provided to define the database elements. The solution covers data validation and normalization. A test plan is created to test the system against user and system requirements. The project also includes both user and technical documentation, which are crucial for understanding and maintaining the database system. The overall goal is to provide VET SOLUTION with a functional and well-documented relational database system to meet their operational needs.

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: