A charter company owns boats that are used for charter trips to islands. The company has...

 

Transcribed Image Text:

A charter company owns boats that are used for charter trips to islands. 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 their names and populations. Every time a boat is chartered, it is important to know the date that the trip is to take place and the number of people on the trip. The company also keeps information about each captain, such as Social Security number, name, birthdate, and contact information for next of kin. Boats travel to only one island per visit. QUESTIONS: 1. Create a data módel. Include entities, attributes, identifiers, and relationships. 2. Which entities are dependent? Which are independent? 3. Draw an entity-relationship model A charter company owns boats that are used for charter trips to islands. 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 their names and populations. Every time a boat is chartered, it is important to know the date that the trip is to take place and the number of people on the trip. The company also keeps information about each captain, such as Social Security number, name, birthdate, and contact information for next of kin. Boats travel to only one island per visit. QUESTIONS: 1. Create a data módel. Include entities, attributes, identifiers, and relationships. 2. Which entities are dependent? Which are independent? 3. Draw an entity-relationship model