The following table shows a relation called AUTHOR BOOK ROYALTIES for a law firm

specialized in textbook author contracts. It represents information about textbooks such as the

author, the textbook they wrote and the publisher including author royalties.

The Author number $($ANbr$)$ is unique for each author and is sufficient to obtain information

about the author name and its institution name. Each book is assigned a unique number $($BNbr$)$

providing information about the book name, its publisher and its price. The publisher city can be

derived from the publisher name.

Finally, a royalty is for authors for a given book.