Re: Please check my 1,2&3 NF for assignment

Thanks for your comments Alan

Colin

"Alan" <alanshein_at_erols.com> wrote in message news:<9tu39j$4u6fp$1_at_ID-

114862.news.dfncis.de>...
> In 3NF Option 2, there is no way to determine which job a particular
> interview was for. This could be solved by adding job-reference# as an FK in
> the interview table, but you would quickly see that this could then be
> factored down to your classmate's design. In option 1, your concern about
> matching the date and time to a specific interview (good catch, BTW) can be
> solved simply by adding another record to the job_application table for each
> interview. Your classmate's version is the more correct. Check out
> many-to-many relationships for a better understanding of the issues
> involved.
>
> Regarding your address question, you've identified the issues, and the
> correct solution is the one that is right for your particular business and
> technical requirements. The answer, as you'll find with most I.S. questions
> is, "It depends."
>
> Good luck!
>
>
Received on Mon Dec 03 2001 - 12:03:37 CET