Assignment on Vet Solution

30 Pages2868 Words440 Views

Added on 2020-10-05

Assignment on Vet Solution

Added on 2020-10-05

Related Documents

VET SOLUTIONSubmitted by:Date:

Table of ContentsIntroductionL01 Use an appropriate design tool to design a relational database system for a substantial problemER DiagramUser RequirementData DictionaryData ValidationData NormalizationLO2 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 toolsLO3 Test the system against user and system requirements. Create test plan for developed Vet Solution DatabaseLO4 Produce technical and user documentation User DocumentationTechnical DocumentationConclusionReference

IntroductionA veterinary company, VET SOLUTION, which started around 2005 and based at Cambridgeshire have recently opened certain branches in a direction of southeast England. Due to thehuge amount with paper work and the poor communication among staffs and the branches.VET SOLUTION have approach your company, ULKOM LTD, requesting for a computerizeddatabase system. LO1Entity Relationship diagram

Table Creation

End of preview

Want to access all the pages? Upload your documents or become a member.

SQL Triggers and Stored Procedures

|954

|38

Assignment on Vet Solution

Assignment on Vet Solution

End of preview

SQL Triggers and Stored Procedureslg...

SQL Triggers and Stored Procedures