cycles or multiple cascade error

  • look at the diagram :

    A. if I'll change RoomNum in Room table it will update OfficeRoomNum in  Employee table that is not connected to any table and LocateInRoomNum in Device table which is also not connected to any table - no cycle!!

    B. if I'll change EmpID in Employee table it will update SighnByEmpId in Device table wich is not connected to any other table - no cycle!!

    C. if I'll change DevId in Device table it will update no table because is not connected to any table -  no cycle!!

    Where is the cycles or multiple cascade error ??

     

  • Again, Look for my answer here


    * Noel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply