Please Do Exercise 9.4 (BANK ER schema only).
9.4. Figure 9.8 shows an ER schema for a database that can be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a BANK ER schema and specify all primary keys and foreign keys.