1

I have three table that related to one table,in my new design I want to replace the relationship by using sparse columns. you Can see diagram below.

enter image description here

I know I would have Redundancy.but i want to know what is the other risk of this way of design? by this new way my queries would be very easy and fast.what is your idea about it?sorry for my bad english,and thanks.

Oded
  • 489,969
  • 99
  • 883
  • 1,009
vesna
  • 403
  • 1
  • 3
  • 13
  • http://msdn.microsoft.com/en-us/library/cc280604.aspx – Oded Oct 23 '12 at 12:10
  • I see no reason why your queries would not be fast with the current struture unless you have no indexing. Databases are optimized to use joins effectively. – HLGEM Oct 23 '12 at 20:24

1 Answers1

1

If there would be only one entry per wfdoc.id in the three satellite tables (attendance, credit, replacedetail), then your new design is possible, although wasteful of disk space. But if there could be several entries in the attendance table for one wfdoc.id, then this is a very bad idea.

No'am Newman
  • 6,395
  • 5
  • 38
  • 50