Task 2 Case Study
BushfiresareawidespreadandregularphenomenoninAustraliaandhavecausedsignificant property damage and loss of both human and animal life. Several organisations are working to prevent and battle bushfires. RFS (NSW RURAL FIRE SERVICE) is a volunteer and community-based fire and emergency services organisation inNSW.
Data and Information Management plays a critical role in planning and operations of RFS. RFS has three type of Brigades including Fire Brigade, Forest Industry Brigade, and Coastguard Brigade. Each Brigade has a number of members and no one can be a member oftwoormorebrigades.Eachmemberiseitherapaidstafforavolunteer.RFSneedstokeep record of staff personal details of members including name, age, gender, address, contact details, … and their location. The members work in shifts. A shift consists of start and end time. The shifts do not overlap, but they are consecutive, i.e. there is a shift on at any given time and day. We are assuming that the model we are creating (and eventually the database we will design) covers some extended period of time. Each member will thus be assigned to many shifts in thatperiod.
RFS keeps record of its operations in the incidents including members and equipment involved, as well as the details of incident (e.g. type, location, date/time started, date time finished, …)
Stations: RFS delivers services to the community through a network of rural, urban and integrated fire stations across NSW. RFS’s fire stations are specifically designed to support andfacilitatetheemergencyneedsofthefirefightersandtohouseourspecialistvehiclesand equipment.
There’re three type of stations:
Integrated and career fire stations: Integrated and career stations include career firefighters whosupportlocalvolunteers.RFShas38integratedandcareerfirestationstypicallyservicing large urban centres and housing between 4-6 or more emergencyvehicles.UrbanFireStations:Thereare204urbanfirestationscateringtotheneedsoflargerbrigades and including a 3-4 bay drive-through motor room, turn-out area, workshop, Breathing Apparatus cleaning room and drying room.RuralFireStations:RFShas951ruralfirestationstypicallyhousing2-3vehiclesandbrigade equipment.Trucks
There are many different types of fire appliances in RFS’s fleet ensuring our firefighters can respond to different types of fires and other emergency incidents:
Tankers:RFShasover1200tankersinitsfleet.Tankerscomein2-wheeldriveand4-wheel drive combinations and are designed to carry a large water tank (up to 3000 litres) as well as a pump. Operational equipment such 2 as hoses, nozzles, standpipes, breathing apparatus, axesandotherhandtoolsarestowedinlockersonthevehicle.Tankersaregenerallyusedin bushfires as the water can be carried to where it is required and then used at the fire ground to extinguish the fire. The pump on a tanker runs independently, so that the truck can drive around and extinguish thefire.Pumpers: RFS has over 200 pumpers currently in supply. As the name implies, pumpers are equipped with a large pump capable of pumping thousands of litres of water per minute, some up to 4000 litres per minute. Pumpers are generally used in an urban environment to fightstructurefires,astheyrequireareticulatedorstaticwatersupply(e.g.:adam)tooperate. Pumpers are also equipped with an extensive inventory of operational equipment including hoses, nozzles, ladders, breathing apparatus, chemical protection suits and other firefighting gear, stowed in lockers on board the pumper. Pumpers carry some water, up to 2000 litres, but because their pumps are so large, they need the truck engine to run them, so pumpers operate only when they areparked.Aerial appliances: ‘Aerial’ appliances are not aircraft. They are fire trucks equipped with a long extension ladder, or in some cases a hydraulic platform (like a massive “cherry picker”), capable of reaching several storeys in the air. From these heights firefighters are able to conductrescuesfromupperfloorwindowsandarealsoabletosendwaterdownontothefire fromhosesbuiltintotheladderorplatformsystem.Someaerialappliancesareequippedwith their own pump that can hook directly into the reticulated water supply to deliver water direct to the hose located at the end of the extension ladder or platform. Other aerial appliances havenopumpandrequireapumpertoattendthefirescenetopumpthewaterfromthemains water supply to the aerial appliance. RFS has seven aerial appliances in its truck fleet, these being strategically located in outer metropolitan Melbourne and in provincial cities such as Ballarat andBendigo.AllTerrain:RFShavethreeall-terrainvehicles.Thesefiretrucksarestationedatskiresorts andhavecaterpillartreadsinsteadofwheelstoprovideover-snowfirefightingcapabilityduring the winter months. All-terrain vehicles have a similar operating capacity topumpers.Rescue Vehicles RFS has 26 rescue units that are predominantly used to rescue people involved in car accidents. Rescue units are equipped with a large array of rescue equipment includingthe“jawsoflife”,whichisdesignedtofreepeopletrappedintheircarfollowingaroad accident. In many instances rescue units are also equipped to carry out other forms of rescue including industrial accidents and high angle (e.g. Window cleaners caught on the sides of high-rise buildings).
Hazardous Materials Incident Units (HazMat Van): There are nine hazardous material incidentunitsthatareusedatincidentswherechemicalsandotherhazardoussubstancesare present.Theycarryanarrayofequipmentthatcanbeusedtodamandcontainchemicalspills and clean up the contaminated area. Units are also equipped with decontamination showers forfirefightersinvolvedintheincident.Theseshowershoseoffchemicalsthefirefightersmay have been exposed to when wearing their chemical protectionsuits.Mobile Communications Vehicles (MCV’s): RFS’s fleet of mobile communications vehicles are used to assist communications and incident management at large and/or protracted incidents. MCVs are equipped with extensive radio communications equipment, also have computers, faxes, photocopiers and whiteboards that are useful tools for incident management.Quick Attacks: RFS’s 21 quick attack vehicles are used in built-up areas to provide a quick initial firefighting response. They have a small tank (500 to1500 litres) and pump and are especially suited for hard to accessareas.Protective Equipment Units (PE Vans): There are four protective equipment units that are usedtosupportincidents.PEUnitscarryadditionalbreathingapparatus,includingspecialised oxygen breathing apparatus for long duration incidents such as shipboard and mine rescue, and a compressor to refill used air cylinders. There are also splash suits and gas suits that are used in hazardous materialsincidents.RFS keeps record of truck details such as make, model, make year, ….
For more information about the RFS mission and activities, and data/information requirement refer to the RFS website (https:// https://www.rfs.nsw.gov.au/)
Data Model has been provided below to help you write SQL statements
Writecreatetablestatementsforabovetables.Makesureprimarykey,foreignkey,notnull and other constraints are included in tablecreationscripts. 5 MarksWrite insert statements to populate these tables with sample data. Create data which will meet therelationalrequirements. 5 MarksAs part of audit requirements, it is required to generate the below reports. The supervisor has once again asked youfor help: Each 2marksDetails of incidents and the list of staff members who were involved with thoseincidents.Details of Trucks that were used while responding toincidents.Details of staff members along with the details of shifts they’veworked.Details of which brigade and stations have access to whichvehicles.Count of members in everybrigadeCount of members in everystationCount of vehicles in every station bytypeCount of incidents that involved more than 2membersCount of vehicles used in responding to incident by type ofvehicleCount of members who are working more than 5 shifts in aweekNote:. Paste the query and screenshots from SQL Server in the document.
[Button id=”1″]
Quality and affordable writing services. Our papers are written to meet your needs, in a personalized manner. You can order essays, annotated bibliography, discussion, research papers, reaction paper, article critique, coursework, projects, case study, term papers, movie review, research proposal, capstone project, speech/presentation, book report/review, and more.
Need Help? Click On The Order Now Button For Help
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
