One to one relationship

[ManvinderKaur]

Hi
I have to create a database for a site survey company. I have a table for assessment and one table for people names (who will do survey). This is a one to one relationship. Is it a good idea to merge both tables together.
Thanks


Manvinder

[pbaldy]

Well, you said "names" plural, which would imply there are more than one. If there's only one name field, then I'd say to have it all in one table. If there are more than one, then each should be a separate record in the second table, making the relationship one-to-many.

[ManvinderKaur]

yes for example one table
tblBaseline
ID
StartDate
Finishdate
ProductionUnit
MeterialInput
RepID (FK)
BusinessID(FK to other table business)

TblRepresentative
RepID
EcoBIZProjectOffier
EcoBizFcilitatorName
ContactOffier

is this good to keep in two table or one
because each survey have different set of names
EcoBIZProjectOffier
EcoBizFcilitatorName
ContactOffier
i.e one to one relationship between both tables