Please see attachment.
Appendix 1: Copies of manual records held so far
Owner details: |
Pet details: Christina White Kennel Cough/Cat Flu Last Vaccine Date: 31/03/2010 |
Pet details: |
Owner details: |
Pet details: 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 |
||||
Telephone Number |
01337 457982 |
Christina White |
George Street Vets |
01387 234156 |
James Grierson |
Lockerbie Vets Practice LOCKERBIE |
01576 982011 |
Marissa Khalim |
Moffat Small Pets Practice MOFFAT |
01886 753210 |
Javier Fuentes |
Barony Vets |
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: