plz draw a ER diagram with following requriment

any business rules that you have assumed whilst preparing your model.

a list of the attributes for each of the entities and the relationships

the primary key for each of the entities

the foreign keys needed to represent the relationships

------------------------------------------------------------------------------------------------------------------------------------

Lanchester Liners operate several different ships and several different cruises. Ships are identified by a unique ship number. Ships have itineraries consisting of a departure port and an arrival port. Different ships will, at different times, use the same itineraries.

A cruise consists of at least one itinerary, or there may be several, navigated by one ship. Each itinerary is identified by a unique itinerary id. The name of the tour operator responsible for each cruise is recorded together with the weekday(s) on which the cruise takes place.

Employees of Lanchester Liners are assigned to a particular ship. A captain and first officer are mandatory for each cruise; the captain being in charge of piloting the ship and giving orders to the first officer as required. Each captain and each first officer both have an employee number and a total number of pilotage hours.

Once on board, passengers are issued with a passenger card, which they use to pay for any services or goods on board. Passengers may book excursions originating at various ports on an itinerary. There may also be various attractions visited on excursions (eg Theme Parks, Art Galleries, Museums, Historical Sites etc). Excursions may have a maximum number of spaces available to fill.

There are guest lecturers on each cruise, who are classified as passengers, not as crew.

It is a requirement of Lanchester Liners to record the level of customer satisfaction associated with each cruise for a particular tour operator. This is to help the company support its quality management programme.