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...
An efficient method of communication when more than one person is involved in the editing process of a document is to use ________
A) notes B) e-mail C) comments D) suggestions
Computer Science & Information Technology
You can choose a template for a new presentation from the ________
A) Start screen B) Ribbon C) Lock screen D) Slide pane
Computer Science & Information Technology