Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Books & Author Database Design (http://www.go4expert.com/forums/books-author-database-design-t17534/)

badams 15May2009 11:59

Books & Author Database Design
 
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 ) .......


All times are GMT +5.5. The time now is 11:53.