School of Computer ScienceWestern Illinois University

IS 342 Amaravadi

Assignment#3 - IIWorth: 10 Pts

Data Modelling with ER Diagrams

Please use plain 81/2” x 11” paper for doing these problems. Do not use ruled paper. Diagrams must be neatly drawn and legibly labeled. (It is not necessary though to use a ruler to draw the diagrams). Please do not crowd work into one page or two pages. There is a maximum penalty of 5 points if these requirements are not met. There is one bonus point for neatness. Academic dishonesty of any sort is strictly prohibited.

PART II – 10 PTS

The government of ZIMBALE, a developing nation, desires to establish a system for collecting and reporting seaport statistics. This information would be used to improve port utilization and management, forecast future needs, analyze foreign trade patterns, and support requests for development grants in addition to the traditional function of controlling the flow of goods into and out of the country.

One aspect of the proposed system involves data on the utilization of port and docking facilities. Ships are of various types and come into port for a variety of reasons, including loading, unloading, maintenance and to take shelter from storms. They arrive first into the port area and sometimes stay there without using any docks. If ships have loading or unloading or maintenance to be done, they wait in the port area until a berth [“a parking spot” at a dock] becomes available. From there, they are taken by tug boats into docks. Some docks are special purpose docks permitting only one ship of a specialized type to be berthed at a given time, others are general purpose facilities which can berth one large ship or several small ones.

You have been assigned to assist in designing a database for the docking facilities/activities portion of the proposed information system. The following data will need to be stored:

1.Date and time of ship arrival at the port area. Assume that ships can visit multiple ports. Ports are designated by their name. The total tonnage handled at the port is also of interest.

2.Date and time of departure from the port area.

3.Date and time of docking. Ships can go to more than one dock during their visit to a given port. Note that a dock can have many berths.

4.Which berths were used while in port (dates and times).

5.Type of ship: passenger, splitbulk cargo, tramp cargo, tanker, natural gas, bulk carrier, container, barge carrier, roll on/off.

6.Physical characteristics of ships: Length, beam (width), draft (how deep in water both empty and full), dwt -- deadweight tonnage (empty weight), grt -- gross rate tonnage (maximum loaded weight).

7.Type of berth used: General cargo, passenger, oil, coal/ore, grain, timber, container, mixed purpose, roll on/off (vehicles drive on or off ship).

8.Berth characteristics: Location (which dock), length, water depth and age.

9.Each berth has several material handling equipment such as cranes, conveyor belts, pipelines etc. that are used to load/unload ships.There is also storage equipment such as tanks and silos. It is necessary to know the capacities of these containers.

  1. Type of activity while berthed: Loading, unloading, both, refueling, maintenance, other (such as passengers only, storms, etc.). These are referred to by codes More than one such activity can be carried out.
  2. Empty ships must be distinguished from those with cargo.

FIGURE1: An example of a berth. Notice the Material Handling Equipment.

PART II - REQUIREMENTS:

1.List the entity classes and attributes for Zimbale Seaports (4 points).

2.Develop an ER model (6 points).

GRADING AND SUBMSSION NOTES:

  • Only complete assignments will be accepted. Incomplete assignments receive a penalty of ten points.
  • There is a maximum five points penalty for illegibility, use of ruled paper etc. Also do not cram answers into one page – spread out your solutions.
  • There is a standard two point penalty for using wrong notation or not recognizing cycles.
  • Shoddy work will be rejected.