Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This may be a simple a question but I just wanted to clarify, at work I have a table containing a list of titles and I also have a list of authors in two different tables.

What would be best way to connect them? I have a connector table with the IDs of the Authors and ID of the titles so you can left join them, is there a better way to do this? i looked at having an extra column in the title table which would allow the author ID but this would be problematic for multiple titles to a single author.

Does anyone have any suggestions of a better way of doing this ( instead of a connector table)?

any help would be greatly appreciated.

Thanks

James

share|improve this question

1 Answer 1

up vote 1 down vote accepted

A connector table is the standard way to solve this sort of problem.

As you say in your question, if you have a TitleID column in the Authors table it restricts you to one Title per Author, unless you add a Title2ID, Title3ID, etc columns, which for someone like Stephen King might mean quite a few columns.....

Also, by having the connector table you can deal with cases where a Title has more than one Author.

share|improve this answer
    
thank you , that is what I currently have in place just wanted to be sure there was not a better method before went on to develop the system more. thanks –  user1714133 Nov 1 '12 at 17:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.