Database Design

Please see attachment.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

  

Appendix 1: Copies of manual records held so far

Owner details:
First name: Emilio Surname: Ramirez
Address: 43 Rashgill Road
LOCHMABEN
DG12 9FS
Telephone number: 01576 321905

Pet details:
Name: Harif Dog/Cat: DOG – Male
Breed: Cockerspaniel Vet:

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Christina White

Kennel Cough/Cat Flu Last Vaccine Date: 31/03/2010

Pet details:
Name: Sophia Dog/Cat: CAT – Male
Breed: Non-Specific Vet: Christina White
Kennel Cough/Cat Flu Last Vaccine Date: 31/03/2010

Owner details:
First name: Janette Surname: Sparks
Address: 53 Wellington Avenue
DUMFRIES
DG1 7GN
Telephone number: 01387 253986

Pet details:
Name: Misty Dog/Cat: DOG – Female
Breed: Non-Specific Vet:

Javier Fuentes

Kennel Cough/Cat Flu Last Vaccine Date: 07/07/2010


Task 1: Appendix 2: Vet details

Vet’s Name

Neil King

Veterinary Practice Name and Address

Kings Small Pets Service
Dumfries Road
LOCHMABEN
DG3 7RD

Telephone Number

01337 457982

Vet’s Name

Veterinary Practice Name and Address

Telephone Number

Christina White

George Street Vets
85 George Street
DUMFRIES
DG1 3AS

01387 234156

Vet’s Name

Veterinary Practice Name and Address

Telephone Number

James Grierson

Lockerbie Vets Practice
School Road

LOCKERBIE
DG12 4XX

01576 982011

Vet’s Name

Veterinary Practice Name and Address

Telephone Number

Marissa Khalim

Moffat Small Pets Practice
Ballgreen Road

MOFFAT
DG11 6DJ

01886 753210

Vet’s Name

Veterinary Practice Name and Address

Telephone Number

Javier Fuentes

Barony Vets
Barony Avenue
DUMFRIES
DG1 3LN

01387 734222

Task: Using the information from the records on page 1 and 2

a. Design and create a relational database, and explain what the relevant entries are and how you assigned attributes to them:

*Draw 3 tables, one for customer details, one for pet details, and one for vet details, tables should have FIELD NAME – DATA TYPE – SIZE.*

The tables should include:

· valid data field names

· data types of one occurrence of date/time, number, text and currency

· customised field sizes appropriate to field content

· primary and foreign keys

· referential integrity rules applied


Draw tables here:

b. Explain what the primary key is for each entity:

c. Explain how you established relationships and relationship rules between the entities:

and produce an Entity-Relationship Model to demonstrate the relationship: (Fill in the boxes)

d.

Produce evidence on how you added foreign key/s to the relevant entity/entities to enable the relationship to be established:

e.

Explain how you determined referential integrity for each entity and justified your selection. Within your selection you must have at least one occurrence of cascade update and one occurrence of cascade delete. They may be selected separately or together:

Order a unique copy of this paper

600 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal

Order your essay today and save 25% with the discount code GREEN