1 Reply Latest reply on Feb 4, 2012 12:06 PM by zimbabwe

    More entity relationship questions

    zimbabwe

      Title

      More entity relationship questions

      Post

      Along the same lines as my previous question:

       I have a one to many relationship between students and rent/fees and then a one to many relationship from rent/fees to payments, as Philmodjunk suggested.

       So far so good.  But students can also incurr fees from periodic inspections and poorly cleaned premises at check out.  so I have a one to many relationship between students and a table called Chk/Insp (For checkout and inspection).  That table has a one to many relationship with rent/fees. 

      so in summary: rent/fees has two relationships, one from students--<chk/Insp--<Rent/fees---<payments  and one from

      students---<Rent/fees---<payments.

      My question is if this is redundant or superfluous?  I have tow pathways to rent/fees but I feel like i need to have a table documenting check out and inspection deficiencies.  is that okay?

      ER_table.png