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.
