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.

Computer Science & Information Technology

You might also like to view...

Computers are actually more complex than most people think

Indicate whether the statement is true or false

Computer Science & Information Technology

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

Computer Science & Information Technology

To unlock an item, click Object on the Menu bar, then click ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

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

Computer Science & Information Technology