Books & Author Database Design

Discussion in 'Database' started by badams, May 15, 2009.

  1. badams

    badams New Member

    May 15, 2009
    Likes Received:
    Trophy Points:
    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.


    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 ) .......

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice