Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A charter company owns boats that are used for charter trips to islands. The company has created a computer system to track the boats

 

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 mdel. Include entities, attributes, identifiers, and relationships. 2. Which entities are dependent? Which are independent? 3. Draw an entity-relationship model

Step by Step Solution

3.41 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth

5th edition

978-1118057629, 1118057627, 978-111880817

More Books

Students also viewed these Databases questions

Question

Why do bars offer free peanuts?

Answered: 1 week ago

Question

Describe the major elements and issues with iterative development.

Answered: 1 week ago