Figure 9.8 shows an ER schema for a database that may be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema, and specify all primary keys and foreign keys.
What will be an ideal response?
SHIP
SNAME OWNER TYPE PNAME
SHIP_TYPE
TYPE TONNAGE HULL
STATE_COUNTRY
NAME CONTINENT
SEAOCEANLAKE
NAME
SHIP_MOVEMENT
SSNAME DATE TIME LONGITUDE LATITUTE
PORT
S_C_NAME PNAME S_O_L_NAME
VISIT
VSNAME VPNAME STARTDATE ENDDATE
f.k.
f.k.
f.k. f.k. f.k.
f.k.
f.k.
You might also like to view...
Computers are actually more complex than most people think
Indicate whether the statement is true or false
The list of results returned to you when you search for information on the web is called a list of ________
A) strikes B) queries C) hits D) keywords
To unlock an item, click Object on the Menu bar, then click ____________________.
Fill in the blank(s) with the appropriate word(s).
A black exclamation point icon on a yellow triangle background appearing next to the device icon in Device Manager indicates that ________
a. A device is not working properly b. A device is not recognized c. A device has been configured manually with resource configurations d. None of the above