Add a constraint to the schema that enforces the restriction that the number of books assigned to a shelf cannot exceed the shelf capacity.
What will be an ideal response?
CREATE ASSERTION ShelfCapacity
CHECK ( NOT EXISTS (
SELECT *
FROM Shelves S
WHERE S.Capacity <
( SELECT COUNT (*)
FROM Books B
WHERE B.ShelfId = S.ShelfId) ) )
You might also like to view...
The if statement is called a ______________ statement because it selects or ignores one action (or sequence of actions).
a) single-selection b) multiple-selection c) double-selection d) repetition
Which Office 365 plan would a company with 150 employees choose if they wanted employees to have access to Office 2013 desktop applications?
A) Small Business Premium B) Midsize Business C) Midsize Business and Enterprises (E1 ) D) Midsize Business and Enterprises (E3)
In which type of social engineering attack is an email used to trick the user into visiting a fake website?
a. Pop-up windows b. Email attachments c. Websites d. Third-party authorization
A person's presence on a social media is referred to as a(n) _________.
A. online identity B. persona C. avatar D. all of the above