The Leisure Travel Boat Company Owns a Number of Boats - Case Study - Business Assignment Help

Assignment Task

The Leisure Travel boat company owns a number of boats more than 100 of staff members are working there. Each boat is allocated to a particular voyage, although some voyages may have several boats. Each voyage passes through a number of ports.One or more Captains are allocated to each voyage. Each Captains is only responsible one voyage.Some of the ports have a dockyard where boats are kept and each of the boats has one home dockyard. All the boats have unique registration no and number of passengers that boat can carry on it. Number of passengers is varied from boat to boat. Each voyage is identified by a voyage number. All the staff members having their employee number, name, (first name, last name) address (Apartment number, street number and city), contact number (mobile and home phone number), age, salary. Other than this information medical history of all the captains are stored in the system. Fixed no of hours should be covered by each captain within the month other than this, every additional working hour he will be paid 5% of basic salary.

Each dockyard has a name, address and telephone number. Although each boat has home dockyard boats can be serviced at any dockyard throughout the journey. Maintenance engineers, mechanics works at a particular dockyard, Maintenance engineers have their qualification and mechanics have their experience stored in the system.Voyage booking and cancellation Online enquiry facilities and voyage schedules are available for passengers. 10 days prior to the journey date Passengers can start booking voyage by paying full amount of charges.

The group Passengers has facility to do whole boat booking. All the Charges are depending on the voyage, food and entertainment facility can be provided on request. If any passenger wants to cancel the booking it should be done 2 days prior to the journey date, then company will refund the 75% of the Charges. otherwise the company has the right to charge 50% and refund only the half of the amount of the amount. i want to this scenario ER diagram only please

This Business Assignment has been solved by our Business experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.