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