Table Students
SIDPK SID DormPK
Table Dorms
DormPK Dorm Fee
if a student can have many dorms then:
Table Students
SIDPK SID
Table Dorms
DormPK Dorm Fee
Table StudentDormHist
SIDPK DormPK
--- In [email protected], "tam_yehia" <[EMAIL PROTECTED]> wrote:
>
> Hi all, i need your help
>
> if i have the following relation
>
> SID Dorm Fee
> 100-10-6789 Randolph 3200
> 123-65-4321 Ingersoll 3100
> 136-22-3333 Randolph 3200
> 567-33-4444 Pitkin 3100
>
> how to convert this relation into 3NF, what are the new relation, and
> the PK for each.
>
> Thanks
>
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
