'Alpaca Pedigree' SQL Entities

Databases
1

Hello all,

I am building a “Smart” image gallery for my clients and one of the things they want to do is display the pedigree relationships between their alpacas. You can see the Pedigree ER diagram here:-

They basically want to show that table structure on the website, but obviously formatted nicely in HTML. So my question is, what would be the best approach to get that data in the least queries? Im concerned this could be quite expensive in terms of how many queries are used if im not careful!

I really hope that made sense! Any questions please just ask :blush:

Kind regards and thanks,

2

What do those tables contain? What is the link between them?

3

Just the names of the alpacas, its basically a family tree…

4

Like parent-child connections? Maybe this article written by r937 might be of help to you (it talks about categories and subcategories, but in both cases we’re talking adjacency I think): http://sqllessons.com/categories.html

5

Yes just that, parent- child connections :slight_smile: