MYSQL Databases PLEASE DON'T COPY AND PASTE THE ANSWER OR I WILL REPORT

I think the assignment is requiring comparing graph databases with sql

Let the following database schema be given. Person(idnumber, name, dob, mother, father) primary key idnumber foreign key father references Person(idnumber) foreign key mother references Person(idnumber) Consider the following query: For the person with idnumber 42 produce a list of all their ancestors. Note that ancestors include grandparents, great-grandparents and so on. (a) Outline how you would solve this task programmatically, ad- dressing which particular SQL shortcoming you have to over- come. (b) What other kind of database might be more appropriate for the above query and why