(4) [10 pts] Consider the ER diagram for SHIP_TRACKING database to keep track of transport ships...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(4) [10 pts] Consider the ER diagram for SHIP_TRACKING database to keep track of transport ships and their locations for maritime authorities. Map this diagram to a relational schema (SHIP, SHIP TYPE, PORT, PORT_VISIT, SHIP_MOVEMENT, STATE_COUNTRY, SEA_OCEAN_LAKE), and specify all primary keys and foreign keys for each relation. Answer SHIP_MOVEMENT Sname Owner N Phame HOME PORT 1 IN HISTORY 1 SHIP PORT Latitude (0) (0:") Time stamp SHIP AT PORT Longitude N TYPE N N (1,1) IN ON Date Time 1 1 Type Tonnage SHIP TYPE Start date End_date PORT VISIT Name Hull STATE/COUNTRY Name SEA/OCEAN/LAKE Continent (4) [10 pts] Consider the ER diagram for SHIP_TRACKING database to keep track of transport ships and their locations for maritime authorities. Map this diagram to a relational schema (SHIP, SHIP TYPE, PORT, PORT_VISIT, SHIP_MOVEMENT, STATE_COUNTRY, SEA_OCEAN_LAKE), and specify all primary keys and foreign keys for each relation. Answer SHIP_MOVEMENT Sname Owner N Phame HOME PORT 1 IN HISTORY 1 SHIP PORT Latitude (0) (0:") Time stamp SHIP AT PORT Longitude N TYPE N N (1,1) IN ON Date Time 1 1 Type Tonnage SHIP TYPE Start date End_date PORT VISIT Name Hull STATE/COUNTRY Name SEA/OCEAN/LAKE Continent
Expert Answer:
Related Book For
Fundamentals of Momentum, Heat and Mass Transfer
ISBN: 978-1118947463
6th edition
Authors: James Welty, Gregory L. Rorrer, David G. Foster
Posted Date:
Students also viewed these databases questions
-
An array of structures is needed to keep track of 50 grocery items containing the item name, item type, cost, quantity, and tax percentage for each grocery item. The following declarations have...
-
The figure below shows an open triangular channel in which the two sides, AB and AC, are held together by cables, spaced 1 m apart, between B and C. Determine the cable tension. -Cable Water 8 m +6 m
-
A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The E-R diagram in Figure 2-24 illustrates the key...
-
from the given option three are similar to each other becausethey follow the same patter identify the option that is dissimilarto the other three A. BCED B. EFhG c. KLNM D. RSVT
-
As noted in this case, Japanese companies typically rely more heavily on debt capital than U.S. companies. Explain how this fact may cause the independent audit functions in the two countries to...
-
Table B.7 of Appendix B gives the following values for steam at 400C and 150 bar: (a) The value 2975 is not the true specific enthalpy of steam at the given condition. Why not? State the process [H 2...
-
The comedian Groucho Marx famously commented, Id never join a club that would have me as a member. Some venuessuch as exclusive websites, nightclubs, etc.carefully monitor participants to screen out...
-
A straight piece of conducting wire with mass M and length L is placed on a frictionless incline tilted at an angle θ from the horizontal (Fig). There is a uniform, vertical magnetic field B at...
-
An investor believes that NVDA stock is a good purchase. She wants to believes that the stock will appreciate 8% following the next earnings call. Currently NVDA trades for $700/share. The investor...
-
Should Grand Central Publishing continue to bid for Dewey, wait for the scheduled auction with several interested publishers, or pull out of the race? Why? 2. What is the role of authors, agents, and...
-
Using the information below, calculate WACC. Target Capital Structure: 30% Debt and 70% Equity Long-term government bond rate is 2.5%; levered beta is 0.9; market risk premium is 6%; tax rate is 25%....
-
Question 3 Go to the website for the Observatory for Economic Complexity (https://oec.world/en) and find the country profile for Vietnam (click on profiles countries and type 'Vietnam' in the search...
-
While you're lunching with a group of young nurses, one of them says, "On my unit, we seem to have had an increase in catheter-associated urinary tract infections (CAUTIs), but the rate on monthly...
-
What tactical advantages did the Americans have over the Chinese in the Korean War? What advantages did the Chinese have over Americans? Resource: https://youtu.be/1Wb6P8lI8xY...
-
Module 3: Strategies Research the topics below.Use reliable academic sources and/or review the books suggested in the Handbook to support your answer. It is also suggested to carry out an effective...
-
customer defines the quality objectives for a firm and individuals decide if the objectives were met. Thinking of your experience as a customer, please describe a customer experience for a product or...
-
The zoo will have several animals, and each animal will have a name, age, and species. Moreover, each animal will have a method make_sound(), which should return a string representing the sound it...
-
CdF2 (s) Cd+ (aq) + 2 F- (aq) 1. A saturated solution of CdF2 is prepared. The equilibrium in the solution is represented above. In the solution [Cd+] eq = 0.0585 M and [F-] eq = 0.117 M. a....
-
A cylindrical rod 3 cm in diameter is partially inserted into a furnace with one end exposed to the surrounding air, which is at 300 K. The temperatures measured at two points 7.6 cm apart are 399...
-
A pump is required to deliver 60,000 gpm against a head of 300 m when operating at 2000 rpm. What type of pump should be specified?
-
A thin coating is to be applied to both sides of a piece of thin plastic that is being mechanically transported. The plastic is 4.5- m-thick and 0.0254-meters-wide and is very long. We want to coat a...
-
Consider a first-order system with no input such that the input-output differential equation is given by \[\dot{y}+3 y=0 \text {. }\] Find its system response.
-
Consider the electrical circuit shown below where \(v_{i}(t)=\beta\), for \(t \geq 0\). Find the dynamic system response \(v_{o}(t)\). VC C ww R V;(t) R ww R3 A First-Order Electrical System Vo (t) +
-
Find the dynamic system response for the spring mass damping system shown in Figure 3.2, where \(f(t)=\beta, x(0)=0\) (i.e. there is no initial energy stored). b f(t) k Figure 3.2 A first-order...
Study smarter with the SolutionInn App