Reference no: EM13906965
A merchant shipping company wishes to use a computer database to help with its operations. There are three distinct areas in which such assistance is desired.
First, it is required that details of the company fleet be recorded. The fleet comprises a number of types of ship: cargo vessels have a deadweight (cargo capacity), class of cargo carried (e.g. dry, container, grain) and number of onboard loading derricks; oil tankers also have a deadweight, and a class of petroleum for which they are equipped; and passenger vessels have a maximum passenger capacity for each of "first" and "tourist" classes, and a number of staterooms. All ships have a crew, which comprises, a master, a number of officers and seamen. They have length, beam, draught and displacement, and burn particular types of fuel. They also have a maximum speed and endurance. Each ship has a home port, which may or may not be the same as its port of registration.
Secondly, the officers and crew have to be paid! Their salary depends on their qualifications and current appointment - to which ship and in what capacity. There is also a "bounty" payment made in respect of each trip made, which depends on the length of the trip and on the individual's length of service with the company. In addition, ship's officers who are sailing in less than their customary capacity (e.g. a master sailing as a first mate) receive an extra payment.
Finally, the company is required by its insurers to maintain a record of the position of each vessel; its port and date of departure, destination and estimated date of arrival; number of officers, total number on board, and total value of cargo carried, if any. Ships currently in dock for repairs must also be included in this catalogue.
Required
(a) Construct an ER diagram from the description above.
|
What costs would be irrelevant
: Prentice company is considering dropping one of its product lines what costs of the product line would be relevant to this decision? what costs would be irrelevant?
|
|
Database for a programming support environment
: Design the database for a programming support environment. In this environment programmers produce programs, which are written in given programming languages.
|
|
Accounting change is reported under retrospective approach
: Could you please research and explain if account balances in the general ledger are adjusted or not when an accounting change is reported under the retrospective approach?
|
|
The first-in first-out inventory costing method
: In 2002, Roses Exotic Seed Shop, a flower store, changed to the last-In first-out (LIFO) inventory costing method of accounting for inventory. Suppose that during 2003, Roses's Exotic Seeds Shop switches back to the first-in first-out (FIFO) inventor..
|
|
Construct an er diagram
: Finally, the company is required by its insurers to maintain a record of the position of each vessel; its port and date of departure, destination and estimated date of arrival; number of officers, total number on board, and total value of cargo ca..
|
|
Show that the game that results if player one is prohibited
: Show that the game that results if player 1 is prohibited from using one of her actions in G does not have an equilibrium in which player 1's payoff is higher than it is in an equilibrium of G.
|
|
Write a paper about human overpopulation
: Write a paper about Human Overpopulation
|
|
Illustrate with example managerial problem and rule manager
: Managers make decisions with the expectation that profits will increase. Illustrate with one example the managerial problem and the rule or logic the manager should do in order to make a decision that will maximize profits.
|
|
Prepare journal entries for transactions-financial statement
: LEW Jewelry Co. uses gold in the manufacture of its products. LEW anticipates that it will need to purchase 500 ounces of gold in October 2014, for jewelry that will be shipped for the holiday shopping season. Prepare the journal entries for the foll..
|