Cruise Business Case: Part $1$

The specialty cruise has a pirate theme and goes on fun missions. Cruise members become part of the crew.

Use the following business rules for the cruise database:

Each employee $($cruise members and captain$)$ have unique IDs.

There are two types of employees: crew and captain.

You cannot be a crew member and a captain.

Only captains have a parrot

Each ship has at least $40$ crew members

Each mission has a unique mission number with one or more ships

Mom New

now

To you & Khari Hunter

Three Dollar Cafe

$(770)288-2025...$

Searc

Use It

Provide all appropriate connectors.

Employee

EmployeelD

EmployeeLastName

EmployeeFirstName

ShipID

$[$

$]$

$3$

MissionID

ParrotID

EmployeelD

ShipsMissions

ParrotName

ShipID

MissionID

Captain

Crew

$4$

ParrotColor

MissionName

ScheduledDate

QuotedPrice