Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thanks for responding, Doug.
>StudentYear: iPKStudentYear, iFKStudentID, iyear
>AwardsAppliedFor: iPKAwardsAppliedFor, iFKStudentYear, iFKAward, lApproved
>Awards: iPKAward, cDescription, iAmount, etc.
>StudentPeriod: iPKStudentPeriod, iFKStudentYear, iFKAcademicPeriod, iFKAward
>AcademicPeriod: iPKAcademicPeriod, ...describes period ...
>How about relating StudentPeriod to AwardsAppliedFor instead? IOW:
>StudentPeriod: iPKStudentPeriod, iFKAwardsAppliedFor, iFKAcademicPeriod
Looks like that would work also, but the relationships would still be circular, I think (If I'm understanding it right). The tables would be more closely related...
AwardsAppliedFor and StudentPeriod both relate to Awards...
Guess I'm a bit confused...is this circularity necessarily a "bad" design?
Thanks for your input, J
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement