Search for Perfect Database Module(s)


Hope someone can help me. I currently maintain a database website on cetaceans (whales & dolphins) on wordpress however at the moment I have several pieces of data in different locations and this is very time consuming to update.

I know it is possible somehow but no idea how to do it but I would love the ability to have 1 primary table database with all the information on whales & dolphins I require and have pages reading from the table based on key words and / or a reference number?

This means I can have automatically populated profiles similar to this:

Park pages like this:

and have advance searches which all reads off the primary table, returning a summary table and link to profile page

I am happy to learn but if I can know if this is possible, then that would be fantastic!

Any help would be most appreciated,

Drupal version: