Question
The following integrity constraints MUST be implemented: When a record about a tour operator is removed from the database, the records about Airlines associated with
-
The following integrity constraints MUST be implemented:
-
When a record about a tour operator is removed from the database, the records about Airlines associated with this tour operator must also be removed from the database.
-
When a record about a tour operators representative who supervised other representatives is removed from the database, the records about subordinate representatives must remain in the database.
-
Domain of attribute Category (Room entity set) contains only three values: standard, luxury and executive.
-
Domain of attribute Fee (Service entity set) contains numbers between 0 and 200.
-
Domain of attribute Nbed (Room entity set) contains integer numbers 1, 2, and 3.
-
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started