Add a constraint that enforces the restriction that the number of passengers on a plane cannot exceed the plane's capacity

What will be an ideal response?



CREATE ASSERTION PlaneCapacity
CHECK ( NOT EXISTS (
SELECT *
FROM Planes P, Flights F
WHERE P.Id = F.PlaneId AND P.Capacity <
( SELECT COUNT (*)
FROM Reservations R
WHERE R.FlightId = F.Id) ) )

Computer Science & Information Technology

You might also like to view...

A ____ is conducted to locate potential weaknesses found within the company's internal controls.

A. security audit B. security review C. security classification D. security testing

Computer Science & Information Technology

System BIOS can contains virus protection software

Indicate whether the statement is true or false

Computer Science & Information Technology

We can traverse a singly linked list backward starting from the last node.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The primary editing view in PowerPoint where the user can write and design presentation is:

A) Reading view. B) Normal view. C) Notes view. D) Slide Sorter view.

Computer Science & Information Technology