Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A boat chartering company ( B C C ) has a name and an address, as well as a unique commercial register code ( CRC

A boat chartering company (BCC) has a name and an address, as well as a unique commercial
register code (CRC) for identification. The BCC is organized in boat charter offices (BCO), which
are located on islands in different countries. The BCOs have an address in a country and a unique
BCO?number (BCO_no). The BCO offers different BOATs, which are all characterized by crew and
passengers. All boats are identified by a unique BOAT_number. There are three different types of
boats: sailboat, yacht, and speedboat. The boat type speedboat is additionally characterized by
Max_Speed and Range. Each depot has BCO has employees. There are two types of employees:
Office_Employee and Crew_Members. An employee is identified by a SSN and contact data.
Contact data consist of an address, an email and a phone-number.
image text in transcribed

Step by Step Solution

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

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions