multiple table design problem

From: Georg Gruber <georg_gruber_at_web.de>
Date: 7 Feb 2002 10:57:03 -0800
Message-ID: <7265435d.0202071057.76d9e32e@posting.google.com>

hello,

my name is Georg Gruber, i'm from Austria, Europe and this is my first posting to this newsgroup.

i've tryed to find an answer for my question before, but i couldn't find any.

so maybe you can help me...

i have 3 table called HOTEL, GUEST, PERSONAL. all 3 tables contain the address information (telephone, fax, email, website etc.)

so i want to make a 4th table called CONTACT.

how can i transform this 3 tables to store all the contact related information in the CONTACT table? (i want a clean to provide a clean solution that uses 3NF)
do i have to introduce a CONTACT_TYPE table?

thanks for your time,
comments welcome,
Georg. Received on Thu Feb 07 2002 - 12:57:03 CST