How to relate a field to another field in content type like a foregn key?
Instead of using relationships use field collection module. In this module you may create a collection of fields that they all point to an entity. 

As an example you can create author collection and in this collection insert first name field,last name field,gender field or any other information you need. 

You can add this collection as a field to the book content type.