(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
-
List one or more trade pacts in which your country is involved. Do these trade pacts affect all residents of your country in the same way? On balance, are these trade pacts good or bad for residents...
-
Michigan State Figurine Inc (MSF) sells crystal fugurines to spartan fans. MSF buys the figurines from a manufacturer to $10 per unit. They send orders electronically to the manufacturer, costing $20...
-
Purple Company has a current ratio of 2.2 on December 31. On that date its current assets are as follows: Purple Company's current liabilities at the beginning of the year were \(\$ 195,000\) and...
-
Sharon Feldman, president of Allied Company, considers $20,000 to be a minimum cash balance for operating purposes. As can be seen from the following statements, only $15,000 in cash was available at...
-
According to catastrophe theory, to recover from a catastrophe the athlete must According to catastrophe theory, to recover from a catastrophe the athlete must completely relax physically control her...
-
You are the contracting officer for a CPFF service contract for routine and emergency maintenance of testing equipment in the amount of $1,200,000. The contractor is not required to provide any...
-
SUNSET TELECOM Income Statement For the Year Ended December 31, 2024 Revenues Expenses: Cost of goods sold Operating expenses Depreciation expense Income tax expense Total expenses Net Income SUNSET...
-
The rectilinear motion of a particle is governed by a = 1 2 t - 6 t 2 . It starts from rest when t = 0 . Determine its velocity when it returns to its starting position.
-
1. Given the following image pixel intensity values I= [1 2 0] 1 3 (a) Perform k-means clustering with k-2. Your initial references vectors will be a = [1] and a2 [2]. You will be "running" the...
-
If the decedent is a Filipino citizen, his gross estate is: Based on the preceding number, the deductible family home is: If the decedent is a non-resident alien and his country does not impose...
-
Vadim bought his wife a "gold" bracelet from a guy on the street for $120. If he drops it in a beaker of water and the volume raises 450 cm 3 and the mass is determined to be 0.9 kg, then is the...
-
It is May. A corporate comptroller expects to have approximately $ 5 0 0 , 0 0 0 cash available in a few months and intends to invest the money in Treasury bonds. The current price of the issue that...
-
The value, in thousands of dollars, for houses on 70th Ave West in Podunk Arkansas are: 45; 47; 47.5; 51; 53.5; 125. Calculate the median for this data
-
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...
-
Equivalent Units and Product Cost Report-FIFO Method Following are the September 2019 charges (and certain annotations) appearing in the work-in-process account for Empire Company's processing...
-
what spanning tree does the Spanning Tree One Step function find when the order of edges is: (a) \(\{\{5,6\},\{4,5\},\{3,4\},\{2,6\},\{2,5\}\),...
-
Prove that a connected, undirected graph \(G\) is a tree if and only if for each edge \(\{u, v\} \in G, G-\{u, v\}\) is not connected.
Study smarter with the SolutionInn App