this is the whole question

Scenario Beam Draft 110 20.21 7.3 JS JAGUAR The Port of Brisbane maintains an information system to help with movement of vessels in and out of the port. Table 1 is an extract of a report from the information System showing details of some ships that have enteredleft the Port of Brisbane. Register Number Vessel Name Date Registered Vessel Type Length (m) (m) (m) 6913300 Lotsella 1998-12-01 Tanker 9578024 2001-09-13 LPG Tanker 99.9 17.43 7.06 9690107 Seatrade Red 1988-10-12 Container Ship 185 30.25 10.02 9639696 Tao AC8 2010-01-30 Bulk Carrier 158 24.04 9.99 9341938 Maersk Lome 2013-05-17 Container Ship 255 37.3 13.9 9371969 Souni 2010-01-30 General Cargo 117 19.7 6.45 8521232 Pacific Dawn 1992-10-02 Passenger 245 36 8.1 9241061 Queen Mary 2 1999-02-28 Passenger 345 41 10.3 9357315 Goliath Leader 2008-10-19 Vehicles Carrier 199.91 32.28 10 Table 1. Vessel information - Some) vessels that have visited Port of Brisbane Each vessel is identified by a unique Register Number. Each vessel is also identified by a Vessel Name (although Vessel Name cannot be guaranteed to be unique as sometimes, as vessels are retired, a new vessel may be given the name previously assigned to the retired vessel). The date on which the vessel was registered is recorded. Each vessel is of a particular Vessel Type. (There are a limited number of allowed values for Vessel Type. Each Vessel Type is identified by a unique code and has a Vessel Type Name. For example, Vessel Type Code = P, Vessel Type Name = Passenger.) Other information recorded about vessels include, its Length overall (in metres), m) its Beam (in metres), and its Draft in metres). Beam is the width of the vessel at its widest point. The Draft gives the vertical distance from the waterline to the bottom of the hull (i.e. the minimum depth of water that the vessel can safely navigate without running aground). When laden with goods or passengers, the vessel will sit lower in the water and hence have a larger (deeper) draft. There is no directly calculable relationship between Length Overall (LOA), Beam, and Draft. Vessels enter/leave the Port of Brisbane to load/unload cargo, to embark/disembark passengers, for maintenance, etc. Vessels must tie up (berth) at a wharf in the Port of Brisbane. Table i contains some relevant information about Port of Brisbane wharves. Each wharf is identified by a name. each wharf has a number (at least one) of uses that is/are related to the type of cargo carried by vessels that visit the port. Each wharf has a set of dimensions that describe the wharf. The Length is the distance available for use by machines (Cranes) and vehicles in loading/unloading. The Berth Pocket dimensions describe the area next to the wharf available for a vessel to tie up to the wharf. Port of Brisbane authorities use the wharf's dimensions and its uses to allocate a wharf to a vessel visiting the port. The wharf must be able to physically accommodate the vessel. That is, the Berth Pocket Length and Width must be greater than or equal to the vessel's Length Overall and Beam, and the Berth Pocket Depth must be greater than the vessel's Draft. Ideally, the Wharf Use should match the cargo indicated by the Vessel Type. For example, the Lotsella could be allocated to any of Caltex Crude, Caltex Products, BP Crude or BP Products as it will physically fit in the berth pocket of each of these wharves and, as it is a Tanker, its cargo (crude oil or petroleum products) matches the Wharf Use of each of these wharves. On the other hand, even though the Queen Mary 2 is a passenger ship, it cannot be allocated to the Cruise Terminal wharf as it will not physically fit in this wharf's berth pocket. Wharf Wharf Use Wharf Berth Pocket Length (m) Length Width Depth (m) (m) (m) FI 1 Containers, ro/ro, general cargo, motor vehicles 197 197 45 14 FI2 Containers, ro/ro, general cargo, motor vehicles 200 200 45 14 FI3 Containers, ro/ro, general cargo, motor vehicles 299 299 45 14 FI 4 Containers 302 302 45 14 FI 5 Containers 250 250 45 14 FI 6 Containers 150 150 45 14 F17 Containers 200 200 45 14 FI 8 Containers 220 220 45 14 FI 9 Containers 317 317 45 14 FI 10 Containers 396 396 45 14 Caltex Crude Crude oil discharge and load 91.4 400 50 14.3 Caltex Products Petroleum products 81 285 35 10.3 BP Crude Crude oilfeedstocks discharge, load and discharge 15 329 50 14.3 petroleum products BP Products Petroleum products load and unload LPG 35 235 35 10.9 Grain Grain, woodchips, cottonseed exports, motor 285 285 45 13 vehicles Pinkenba Grain, silica sand, other dry-bulk handling, general 314 412 35 10.4 cargo, soya bean meal, fertiliser, petroleum products Bulk 11 Coal exports 240 317 50 14 Incitec North Bulk liquid and bulk dry fertiliser 123 210 35 10 Incitec South Bulk liquid and bulk dry cargoes 152 220 35 10.4 Maritime 1 Bulk oil and chemicals 32 218 35 9 Qld Bulk Terminal Bulk cargo 158 270 35 10 Cruise Terminal Passenger vessels 386 237 35 8.8 Table 2. Port of Brisbane Wharves The Port of Brisbane reports on wharf usage as shown in the example Wharf Usage Report in Table 3. The Wharf Usage Report shows, for some selected period of time, each wharf that had at least one vessel berthed during the report period (between Start Date and End Date). For each such wharf, the report includes, the vessel that was berthed, when the vessel tied up at the wharf (On Berth date/time). when the vessel left the wharf (Off Berth date/time). The length of time each vessel spent tied up at the wharf (Duration) is calculated. The usage of the wharf (Occupancy (hrs)) is calculated as the sum of the durations of each vessel, and the fractional usage of the wharf (Occupancy Rate (%)) is calculated as usage hours divided by the reporting period hours (End Date - Start Time). Wharf Usage Report Port: Start Date: Port of Brisbane 2020-02-27 00:00 End Date: 2020-02-28 23:59 Wharf: Ship (Reg#) 9241061 9341938 9690107 FI 10 Ship Name Queen Mary 2 Maersk Lome Seatrade Red On berth 2020-02-27 07:00 2020-02-27 18:45 2020-02-28 08:30 Off berth 2020-02-27 16:15 2020-02-28 06:30 2020-02-28 16:50 Occupancy (hrs) Occupancy Rate (%) Duration (hrs) 9.25 11.75 8.33 29.33 61.10 Wharf: Ship (Reg#) 6913300 Caltex Crude Ship Name Lotsella Off berth On berth 2020-02-28 16:50 Duration (hrs) 7.16 7.16 14.93 Occupancy (hrs) Occupancy Rate (%) Wharf: Ship (Reg#) 8521232 Cruise Terminal Ship Name On berth Off berth Pacific Dawn 2020-02-27 09:00 2020-02-27 14:35 Occupancy (hrs) Occupancy Rate (%) Table 3. A sample of Wharf Usage Report at the Port of Brisbane Duration (hrs) 5.55 5.55 23.00 Deliverables You are required to submit the following items for Task 1: 1. A list of elementary facts that fully and explicitly verbalise the fact types contained in the scenario description. 2. A conceptual schema model produced using the Entity Relationship Diagram (ERD) language, using the Barker notation, which fully captures all of the fact types and any necessary constraints. 3. A conceptual schema model produced using the object Role Modelling (ORM) language, which fully captures all of the fact types and any necessary constraints. 4. A textual description of the ERD model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model (200-300 words) 5. A textual description of the ORM model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model (200-300 words) Occupancy Rate(%) 8.8 ELIVERABLES Cou are required to submit the following items for Task 1: 1. A list of elementary facts that fully and explicitly verbalise the fact types contained in the scenario description. 2. A conceptual schema model produced using the Entity Relationship Diagram (ERD) language, using the Barker notation, which fully captures all of the fact types and any necessary constraints. 3. A conceptual schema model produced using the Object Role Modelling (ORM) language, which fully captures all of the fact types and any necessary constraints. 4. A textual description of the ERD model, prepared for the business owner as an aid to communicating and understanding the less abvious features of the model (200-300 words) 5. A textual description of the ORM model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model (200-300 words) ASK 2 15 Markel