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...
AutoComplete, ToolTips, and Quick Info are displayed by the feature ________
A) Print Preview B) Expression Analyst C) Live Preview D) IntelliSense
Computer Science & Information Technology
A mouse, keyboard, printer, and monitor—or any hardware connected through your network—are all examples of ________
A) inputs B) peripherals C) outputs D) programmables
Computer Science & Information Technology
A(n) ____ is a small program that enables users to automate a large number of repeated processes within a document.
A. macro B. update C. upgrade D. patch
Computer Science & Information Technology
The spacing between tick marks is determined by the ________
A) base value B) rate of increase C) Major unit value D) data marker
Computer Science & Information Technology