Re: Organizing data into tables from flat file source

In message <1c2df63c.0204151226.504a784f_at_posting.google.com>, sm <somewhat_at_pacbell.net> writes

>tblUniversity ( ID[pk], Univerity )
>tblDepartment ( ID[pk], UniversityID[fk], Department )
>tblDivision ( ID[pk], DepartmentID[fk], Division )
>
> -- The last two are where I'm most confused ... how do I connect the
>address and contact info if there is no Division? --

Address is an attribute of Department and an attribute of Division. You can either keep all of the addresses together in one table or add address columns to the Department and Division tables. If you choose to use a separate Address table then you need to have a foreign key in both the Department and Division tables. Which is better depends on whether you consider Department-Address and Division-Address to be separate domains or both members of the Address domain. Both of those are reasonable interpretations.

-- 
Bernard Peek
bap_at_shrdlu.com

In search of cognoscenti