In Chapter 6, you were asked to create a logical entity relationship diagram (ERD) for a charter company that owns boats that are used to charter trips to the islands ("Your Turn 6-8"). The company has created a computer system to track the boats it owns, including each boat's ID number, name, and seating capacity. The company also tracks information about the various islands, such as name and population. Every time a boat is chartered, it is important to know the data about the trip that takes place and the number of people on the trip.

The company also keeps information about each captain, such as Social Security Number, name, birth-date, and how to contact next of kin. Boats travel to only one island per visit. Create a physical ERD for this situation. Compare the diagram that you drew to the logical diagram that you created in Chapter 6.