Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 2

Figure 8.8
-Figure 8.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.