Look at the Happy Cruise Lines database, for this question, consider only the following SHIP, PORT, and PASSENGER relations
Ans:
The new relation needs to store the below details :
i. Passenger details: It can be extracted from PASSENGER relation by using a foreign key PassengerNumber .
ii. Ship details: It can be extracted from SHIP relation by using a foreign key ShipNumber .
iii. Port details: It can be extracted from PORT relation by using a foreign key PortName
Output will include below relationship:
i. Passenger will visit using a SHIP which can be store as below:
(PassengerNumber, ShipNumber)
ii. Now a port needs to be stored with the relationship with a specific date as below:(PassengerNumber, ShipNumber, PortName, Date)
Final new relation is as below:
PASSENGERPORTVISIT(PassengerNumber, ShipNumber, PortName, Date)
Where (PassengerNumber, ShipNumber, PortName) is a composite key to uniquely identify the records.
You might also like to view...
What type of operators are used to compare two numeric values?
a. Arithmetic b. Complex c. Logical d. Relational e. None of these
You must create ____ before any of the other database objects.
A. reports B. queries C. data access pages D. tables
Why should you have a system backup plan in place?
What will be an ideal response?
Identify the correct answer from the list of choices.
A. A large and expensive computer capable of processing data for hundreds or thousands of users. B. A removable storage device for a PC. C. A primary storage device. D. A powerful desktop computer, used for medical imaging and computer-aided design. E. A computer used for breaking codes.