Express the constraint that the street number in the addressee's address must be within the range valid for the corresponding street.

What will be an ideal response?

CREATE ASSERTION ValidateRanges

CHECK ( NOT EXISTS

( SELECT *

FROM Addressee A, Streets S

WHERE A.StreetName = S.StreetName AND

A.City = S.City AND

(A.StreetNumber < S.MinHouseNumber

OR A.StreetNumber > S.MaxHouseNumber) )

)