Reference no: EM132494214

We have the following Table: Cars(name, price) and the following assertion:

CREATE ASSERTION Check_My_Cars CHECK

(NOT EXISTS ((SELECT * FROM Cars) EXCEPT

(SELECT * FROM Cars WHERE name = name OR price = price)))

What does above assertion check?

a) Table "Cars" is not Empty.

b) Make sure that no tuple of Cars has both name and price NULL.

c) Make sure that there are no NULL's in any tuple of Cars.

d) Check that all tuples in Cars agree in the value of either the name or the price.

Q. We have the relations Time_Table(a, b) and also the following trigger exists (Why? Maybe because it's a good exam problem!)