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) )
Computer Science & Information Technology
You might also like to view...
Within the script element, you add XHTML style comments in order to hide the JavaScript code from ________
Fill in the blank(s) with correct word
Computer Science & Information Technology
If the final modifier is added to the definition of a method, this means:
a. The method may be redefined in the derived class. b. The method may be redefined in the sub class. c. The method may not be redefined in the derived class. d. None of the above.
Computer Science & Information Technology