Sir Grant,

Is interim table same as derived table?

Please help me Sir finalize my table. Based from your advice, are these the tables that I will create?

[font="Courier New"]PERSON (column: person_id, last_name, first_name, middle_name)

STUDENT (column: person_id, student_number)

ADDRESS (column: address_id, person_id, address)

INTERIM_TABLE (column: person_id, address_id) <-- (this still confused me Sir...is this "query generated" ? or an actual table in MSSQL Server?)[/font]

Oh my golly, I forgot (or maybe I do not know) how to determine if the address is permanent, mailing, or email...silly me. :w00t:

Very warm regards,

Mark Squall