Closed

database

A merchant shipping company wishes to use a computer database to help with its operations . There are three distinct area in which such assistance is desired. 1. 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 dead weight (Cargo capacity). Class of cargo carried (e.g. dry, container, grain) and number of onboard loading derricks; Oil Tankers also have a deadweight, and class of petroleum for which they are equipped; and Passenger vessel 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 seaman. They have a length, beam, draught and displacement, and burn a particular type 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. 2. 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 and on the individual's length of service with the company. In addition, ship's officers who are sailing in less than their normal customary capacity (e.g. master sailing as a first mate) receive an extra payment. 3. Finally, the company is required by its insurers to maintain a record of the position of each vessel; its port and 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. By identifying the entities, attributes and relationships in the date above 1. Derive appropriate data structures for the three views (1,2,3). 2. Derive a conceptual schema, using an ER model, of the shipping company database. 3. Create a semantic object model of the shipping company database.

## Deliverables

Please present The required models

## Deadline information

October 1, 2001

Skills: Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: what is data structures in c, what is data structures, what is a data structures, what are data structures in c, what are data structures, use of data structures, types of data structures in c, types of data structures, types data structures, type of data structures, the computer merchant, petroleum engineering salary, operations on data structures, g crew, desired salary, data structures using, data structures types, data structures operations, current salary, computer data structures, database models, vessel, total fleet, sailing, petroleum engineering

About the Employer:
( 0 reviews ) Jamaica

Project ID: #2827872

16 freelancers are bidding on average $2189 for this job

sysg

See private message.

$212.5 USD in 14 days
(25 Reviews)
4.6
wirovw

See private message.

$51 USD in 14 days
(11 Reviews)
4.2
vw156565vw

See private message.

$42.5 USD in 14 days
(9 Reviews)
3.9
futuristicvw

See private message.

$42.5 USD in 14 days
(7 Reviews)
3.4
dinario

See private message.

$42.5 USD in 14 days
(16 Reviews)
3.1
paulthetutorvw

See private message.

$170 USD in 14 days
(1 Review)
2.1
ctrist

See private message.

$102 USD in 14 days
(2 Reviews)
1.7
binooplal

See private message.

$4250 USD in 14 days
(4 Reviews)
1.3
rsinghvw

See private message.

$127.5 USD in 14 days
(0 Reviews)
0.0
dablabhai

See private message.

$25.5 USD in 14 days
(0 Reviews)
0.0
mithrilvw

See private message.

$17 USD in 14 days
(0 Reviews)
0.0
edmundusvw

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
sschlom

See private message.

$29750 USD in 14 days
(0 Reviews)
0.0
sonnetjolt

See private message.

$63.75 USD in 14 days
(0 Reviews)
0.0
kavee2000

See private message.

$17 USD in 14 days
(3 Reviews)
0.0
sourceeffects

See private message.

$25.5 USD in 14 days
(0 Reviews)
0.0