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) ) )

Computer Science & Information Technology

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

Computer Science & Information Technology

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)

Computer Science & Information Technology

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

Computer Science & Information Technology

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

Computer Science & Information Technology