• connect to database like this

• create initial database like this

• SQL query for all relations belonging to a specific entity

select entities.entity_id,entities.entity_name, relations.relation_to_entity from entities,relations where relations.relation_from_entity=6 and entities.entity_id=relations.relation_to_entity;