A table, Abc, has attributes A, B ,and C , and a functional dependency A ? BC .Write an SQL CREATE ASSERTION statement that prevents a violation of this functional dependency.
What will be an ideal response?
```
CREATE ASSERTION FD
CHECK (1 >= ALL (
SELECT COUNT(DISTINCT *)
FROM Abc
GROUP BYA))
```
Computer Science & Information Technology
You might also like to view...
A ___________ involves somebody sending out junk e-mail with the target listed as the sender.
a. reverse MITM b. forward MITM c. forward spam d. reverse spam
Computer Science & Information Technology
The ________ attribute is added to a TABLE element’s opening tag to bind a data island to a table.
(a) DATA (b) DATAFLD (c) SPAN (d) DATASRC
Computer Science & Information Technology
A presentation's security can be enhanced by changing its ________
A) properties B) timings C) password D) slide order
Computer Science & Information Technology
A linked table is marked with an asterisk in the Navigation Pane
Indicate whether the statement is true or false
Computer Science & Information Technology