Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the following relations containing cruise information: Cruise ( cid: integer, from: string, to: string, distance: integer, departs: time, arrival: time ) Ship ( sid:
Given the following relations containing cruise information:
Cruise cid: integer, from: string, to: string, distance: integer, departs: time, arrival: time
Ship sid: integer, sname: string, cruisingrange: integer
Certified eid: integer, sid: integer
Employees eid: integer, ename: string, salary: real
Note that the Employees relation describes captain and other kinds of employees as well; every captain is certified for some ship otherwise heshe would not qualify as a captain and only captains are certified to manage a cruise.
Write the following queries in TRC and DRC Note that some of these queries may not be expressible in relational calculus. For such queries, please explain why they cannot be expressed.
Find the names of captains certified for Viking ships.
Find the cruise that can be managed by every captain whose salary is more than $
Find the names of captains who can operate ships with a range greater than miles but are not certified on any Viking ships.
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