Animal Sanctuary DB (1 Viewer)

Dreamweaver

Well-known member
Local time
Today, 14:52
Joined
Nov 28, 2005
Messages
2,466
I've just started this and am in the very early stage before even a ERD is developed this is what Ive come up with so far

The main sections are

I did sort of have a peak at Data Models :)

It's something I haven't tackled before if you see anything amis please let me know
Animals
Basic details would be name, type, breed, Colour Description, Gender, DateIn, DateOut, Status, DangerLevel.
Activaty Records
Feeding Records
Medication records
Health Records
A set of photos should be able to be created with comments Etc

Employees
General Employee Records
Tasks this might be daily to x times a day depending on animal
Animal Skills Records I.E. Which animals can that employees care for/Has been trained to handle

Foods
Where do they get it
Food Information Record
Stock



Vets
Vets contact details

Customers
Customer Can bring animals in or take them out, If taking home they may need veting so a system should be designed where the admin user can add the Questions that would need to be answered.
Customer Could also make donations to the sanctuary

Environment
the enviroment could be a cage, kennel padock Etc
it would be important to keep clean and maintained

Financial
Costs per animal, feed, maintenance, employee Not wages system just totals
 

Dreamweaver

Well-known member
Local time
Today, 14:52
Joined
Nov 28, 2005
Messages
2,466
Thanks for looking @Ranman256 I can start working on the ERD next.
 
Last edited:

Users who are viewing this thread

Top Bottom