# DB Design Theory - Thoughts

**URL:** <https://forum.kirupa.com/t/db-design-theory-thoughts/222108>\
**Category:** programming\
**Created:** [April 10, 2007, 9:49pm UTC](https://forum.kirupa.com/t/db-design-theory-thoughts/222108 "2007-04-10T21:49:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![DHDesign](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@DHDesign](https://forum.kirupa.com/u/DHDesign)\
**Post date:** [April 10, 2007, 9:49pm UTC](https://forum.kirupa.com/t/db-design-theory-thoughts/222108/1 "2007-04-10T21:49:57Z")

</div>

ive been reading some tutorials and articles on db design…and then i started also using DBDesigner 4 (great open source app, check it out) to design by DB’s.

the question lies here:

we have two tables…(for simplicity, each just has two fields)

## VendorTbl

VendorID (PK)  
VendorName

## VendorContactTbl

VendorContactID (PK)  
ContactName

Now, two ways im looking at this that I wanted your opinions on:

Method 1:

The VendorContactTbl would also have a VendorID

## VendorContactTbl

VendorContactID (PK)  
ContactName  
VendorID (FK)

OR

This is mostly what I’m getting in tutorials

A third table

## Vendors\_Contacts\_tbl

VendorID (FK)  
VendorContactID (FK)

Thoughts, reasons?

Thanks!