For Books table I had simple text field for authors. Now I have list of authors and so splitted the table into authors and then there is a one to one relationship between author. upto this it is fine.

Now The display order of the author is also important because at times you have one major author which should be first and then the other author.

I added display order for the author.

Now there is a twist in the tail.

The same author could be a major in one and a minor in other. So how does this one get solved.

Example

Book A

Authors **X**, Y Z ( X is the main author )

Book B

Author **P**, Q, R ( P is the main author )

Book C

Autho X, **P**, Y ( What if P is main one ) .......