Some additional info on constraints and surprises when using them

Sorry if lecture was the wrong word. I meant the kind of “talk” you
might get at a workshop in which the presenter (lecturer?) is letting you in on
some really good stuff.

And the significance of the two blue arrows in Figure 21-4?

Thanks yet again,

Dan

Daniel B Madvig
Campus Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.gif

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J
image009.png

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J
image006.gif

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J
image010.gif

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J
image001.jpeg

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J
image011.gif

That’s funny – the blue arrows got moved versus where I put them.
Anyhow they were supposed to point to diagram 21-4 on top to show that
multi-column key with optional columns could result in 21-4 on bottom where
bogus rows could be inserted since key does not fire when any portion is null.
Sorry about that – I just assumed email and our posting system would keep
things in place – valuable lesson learned J
image001.gif