TASK 1 (25 Marks) Your task is to design two conceptual information models, using two different modelling languages, that each characterise an effective and efficient way to represent the information escribed in the scenario below. See the Deliverables section following the scenario description for more details of what is required. SCENARIO 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 entered/left the 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, 0) its Length overall (in metres), (ii) its Beam (in metres), and (iii) 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. Beam Register Vessel Name Date Vessel Type Number Registered 6913300 Lotsella 1998-12-01 Tanker 9578024 JS JAGUAR 2001-09-13 LPG Tanker 9690107 Seatrade Red 1988-10-12 Container Ship 9639696 Tao Ace 2010-01-30 Bulk Carrier 9341938 Maersk Lome 2013-05-17 Container Ship 9371969 Souni 2010-01-30 General Cargo 8521232 Pacific Dawn 1 992-10-02 Passenger 9241061 Queen Mary 2 1999-02-28 Passenger 9357315 Goliath Leader 2008-10-19 Vehicles Carrier Table 1 - Vessel information - (Some) vessels that have visited Port of Brisbane Length (m) 1101 99.9 185 158 255 117 20.21 17.43 30.25 24.04 37.3 19.7 36 41 32.28 Draft (m) 7.3 7.06 10.02 9.99 13.9 245 345 199.91 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. 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 IAB201 Semester 1, 2020 - Assignment 1 - Information Modelling 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 Length (m) 197 200 FI 1 299 299 302 250 150 200 220 317 396 91.4 Berth Pocket Length Width (m) (m) 197 45 200 45 45 302 45 250 150 200 220 317 396 400 81 285 329 Containers, ro/ro, general cargo, motor vehicles Containers, ro/ro, general cargo, motor vehicles Containers, ro/ro, general cargo, motor vehicles FI4 Containers FI 5 Containers FL6 Containers FI7 Containers FI 8 Containers FI 9 Containers FI 10 Containers Caltex Crude oil Crude Caltex Petroleum products Products BP Crude Crude oil, LPG Petroleum products Products Grain Grain, Motor vehicles Pinkenba Grain, General cargo, Fertiliser, Petroleum products Bulk 1 Coal Incitec Fertiliser North Incitec General cargo South Maritime 1 Crude oil, Chemicals Qld Bulk Bulk cargo Terminal Cruise Passenger vessels Terminal Table 2 - Port of Brisbane Wharves 15 35 BP 285 314 412 240 123 317 210 152 220 32 218 158 270 386 260 The Port of Brisbane reports on wharf usage as shown in the example Wharf Usage Report below. 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 IAB201 Semester 1, 2020 - Assignment 1 - Information Modelling 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: Port of Brisbane Start Date: 2020-02-27 00:00 End Date: 2020-02-28 23:59 Wharf: Ship (Reg#) 9241061 9341938 9690107 Fl 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 Duration (hrs) 9.25 11.75 Off berth 2 020-02-27 16:15 2020-02-28 06:30 2020-02-28 16:50 Occupancy (hrs) Occupancy Rate (%) 8 22 29.23 61.10 Wharf: Ship (Reg# 6913300 Caltex Crude Ship Name Lotsella On berth 2020-02-28 16:50 Off berth n berth O sella Duration (hrs) 7.16 7.16 14.93 Occupancy (hrs) Occupancy Rate(%) Wharf: Ship (Reg#) 8521232 Cruise Terminal Ship Name Pacific Dawn | On berth 2020-02-27 09:00 Off berth 2020-02-27 14:35 Occupancy (hrs) Occupancy Rate(%) Duration (hrs) 5.55 5.55 23.00 1AB201 Semester 1, 2020 - Assignment 1 - Information Modelling Wharf Usage Report Port: Port of Brisbane Start Date: 2020-03-21 00:00 End Date: 2020-03-25 23:59 Wharf: Ship (Reg#) 9357315 FI 3 Ship Name Goliath Leader On berth 020-03-21 07:00 Duration (hrs) 46.0 2 Off berth 2020-03-23 05:00 Occupancy (hrs) Occupancy Rate(%) 46.0 51.0 Duration (hrs) Wharf: Ship (Reg# 9578024 6913300 Caltex Crude Ship Name JS JAGUAR Lotsella O n berth - 2020-03-22 13:30 9.0 Off berth 2020-03-21 09:00 2020-03-23 08:45 Occupancy (hrs) Occupancy Rate(%) 19.25 28.25 29.4 Wharf: Ship (Reg# 8521232 Cruise Terminal Ship Name Pacific Dawn berth Duration (hrs) 2020-03-24 06:00 Off berth 2020-03-24 14:30 Occupancy (hrs) Occupancy Rate (%) 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) TASK 2 (5 Marks) Compare and contrast the two languages used to model the scenario in Step 1. Did you find one language easier to use than the other? Were there any aspects of the scenario that were difficult to model? In your opinion, did one language produce a "better" model in terms of the quality criteria discussed at the end of lecture 2? (300- 500 words) TASK 1 (25 Marks) Your task is to design two conceptual information models, using two different modelling languages, that each characterise an effective and efficient way to represent the information escribed in the scenario below. See the Deliverables section following the scenario description for more details of what is required. SCENARIO 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 entered/left the 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, 0) its Length overall (in metres), (ii) its Beam (in metres), and (iii) 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. Beam Register Vessel Name Date Vessel Type Number Registered 6913300 Lotsella 1998-12-01 Tanker 9578024 JS JAGUAR 2001-09-13 LPG Tanker 9690107 Seatrade Red 1988-10-12 Container Ship 9639696 Tao Ace 2010-01-30 Bulk Carrier 9341938 Maersk Lome 2013-05-17 Container Ship 9371969 Souni 2010-01-30 General Cargo 8521232 Pacific Dawn 1 992-10-02 Passenger 9241061 Queen Mary 2 1999-02-28 Passenger 9357315 Goliath Leader 2008-10-19 Vehicles Carrier Table 1 - Vessel information - (Some) vessels that have visited Port of Brisbane Length (m) 1101 99.9 185 158 255 117 20.21 17.43 30.25 24.04 37.3 19.7 36 41 32.28 Draft (m) 7.3 7.06 10.02 9.99 13.9 245 345 199.91 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. 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 IAB201 Semester 1, 2020 - Assignment 1 - Information Modelling 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 Length (m) 197 200 FI 1 299 299 302 250 150 200 220 317 396 91.4 Berth Pocket Length Width (m) (m) 197 45 200 45 45 302 45 250 150 200 220 317 396 400 81 285 329 Containers, ro/ro, general cargo, motor vehicles Containers, ro/ro, general cargo, motor vehicles Containers, ro/ro, general cargo, motor vehicles FI4 Containers FI 5 Containers FL6 Containers FI7 Containers FI 8 Containers FI 9 Containers FI 10 Containers Caltex Crude oil Crude Caltex Petroleum products Products BP Crude Crude oil, LPG Petroleum products Products Grain Grain, Motor vehicles Pinkenba Grain, General cargo, Fertiliser, Petroleum products Bulk 1 Coal Incitec Fertiliser North Incitec General cargo South Maritime 1 Crude oil, Chemicals Qld Bulk Bulk cargo Terminal Cruise Passenger vessels Terminal Table 2 - Port of Brisbane Wharves 15 35 BP 285 314 412 240 123 317 210 152 220 32 218 158 270 386 260 The Port of Brisbane reports on wharf usage as shown in the example Wharf Usage Report below. 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 IAB201 Semester 1, 2020 - Assignment 1 - Information Modelling 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: Port of Brisbane Start Date: 2020-02-27 00:00 End Date: 2020-02-28 23:59 Wharf: Ship (Reg#) 9241061 9341938 9690107 Fl 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 Duration (hrs) 9.25 11.75 Off berth 2 020-02-27 16:15 2020-02-28 06:30 2020-02-28 16:50 Occupancy (hrs) Occupancy Rate (%) 8 22 29.23 61.10 Wharf: Ship (Reg# 6913300 Caltex Crude Ship Name Lotsella On berth 2020-02-28 16:50 Off berth n berth O sella Duration (hrs) 7.16 7.16 14.93 Occupancy (hrs) Occupancy Rate(%) Wharf: Ship (Reg#) 8521232 Cruise Terminal Ship Name Pacific Dawn | On berth 2020-02-27 09:00 Off berth 2020-02-27 14:35 Occupancy (hrs) Occupancy Rate(%) Duration (hrs) 5.55 5.55 23.00 1AB201 Semester 1, 2020 - Assignment 1 - Information Modelling Wharf Usage Report Port: Port of Brisbane Start Date: 2020-03-21 00:00 End Date: 2020-03-25 23:59 Wharf: Ship (Reg#) 9357315 FI 3 Ship Name Goliath Leader On berth 020-03-21 07:00 Duration (hrs) 46.0 2 Off berth 2020-03-23 05:00 Occupancy (hrs) Occupancy Rate(%) 46.0 51.0 Duration (hrs) Wharf: Ship (Reg# 9578024 6913300 Caltex Crude Ship Name JS JAGUAR Lotsella O n berth - 2020-03-22 13:30 9.0 Off berth 2020-03-21 09:00 2020-03-23 08:45 Occupancy (hrs) Occupancy Rate(%) 19.25 28.25 29.4 Wharf: Ship (Reg# 8521232 Cruise Terminal Ship Name Pacific Dawn berth Duration (hrs) 2020-03-24 06:00 Off berth 2020-03-24 14:30 Occupancy (hrs) Occupancy Rate (%) 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) TASK 2 (5 Marks) Compare and contrast the two languages used to model the scenario in Step 1. Did you find one language easier to use than the other? Were there any aspects of the scenario that were difficult to model? In your opinion, did one language produce a "better" model in terms of the quality criteria discussed at the end of lecture 2? (300- 500 words)