1. (4 points) List all the strong entities in the ERD below.
2. (12 points) List all the weak entities, their partial keys, and their identifying relationships. What constraint does the partial key and the identifying relationship of each weak entity specify in this diagram?
3. (14 points) Create the relations (tables) for SHIP, SHIP MOVEMENT, and SHIP TYPE entities in the ERD below. (Note: make sure to draw the table structures including all the column names, underline the primary keys, and use directed lines to connect the foreign keys to the tables they reference. Do NOT use SQL statements)
- IP_MOVEMENT
- Longitude
- Latitude
- SHIP
- SHIP_TYPE
- (1,1)
- Continent
- STATE/COUNTRY
- PORT
- SEA/OCEAN/LAKE