Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Task 1 Essay - 20 marks Write an essay on evolution of databases post year 2000, identify new technologies that are replacing RDBMS or other traditional approaches. Using a case study explain how...

1 answer below »

Task 1 Essay - 20 marks

Write an essay on evolution of databases post year 2000, identify new technologies that are replacing RDBMS or other traditional approaches. Using a case study explain how these advanced database technologies are helping various industrial sectors for example, health care, retail or any specific domains within an industry like SCM or CRM. Word limit is 2000 words excluding references.

Task 2 Case Study – 30 marks

Bushfires are a widespread and regular phenomenon in Australia and have caused significant 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 in NSW.

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 of two or more brigades. Each member is either a paid staff or a volunteer. RFS needs to keep 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 Task 1 Essay - 20 marks

Write an essay on evolution of databases post year 2000, identify new technologies that are replacing RDBMS or other traditional approaches. Using a case study explain how these advanced database technologies are helping various industrial sectors for example, health care, retail or any specific domains within an industry like SCM or CRM. Word limit is 2000 words 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 that period.

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 and facilitate the emergency needs of the firefighters and to house our specialist vehicles and equipment.


There’re three type of stations:

• Integrated and career fire stations: Integrated and career stations include career firefighters who support local volunteers. RFS has 38 integrated and career fire stations typically servicing large urban centres and housing between 4-6 or more emergency vehicles.

• Urban Fire Stations: There are 204 urban fire stations catering to the needs of larger brigades and including a 3-4 bay drive-through motor room, turn-out area, workshop, Breathing Apparatus cleaning room and drying room.

• Rural Fire Stations: RFS has 951 rural fire stations typically housing 2-3 vehicles and brigade 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:

1. Tankers: RFS has over 1200 tankers in its fleet. Tankers come in 2-wheel drive and 4-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, axes and other hand tools are stowed in lockers on the vehicle. Tankers are generally used in 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 the fire.

2. 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 fight structure fires, as they require a reticulated or static water supply (e.g.: a dam) to operate. 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 are parked.

3. 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 conduct rescues from upper floor windows and are also able to send water down onto the fire from hoses built into the ladder or platform system. Some aerial appliances are equipped with 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 have no pump and require a pumper to attend the fire scene to pump the water from the mains 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 and Bendigo.

4. All Terrain: RFS have three all-terrain vehicles. These fire trucks are stationed at ski resorts and have caterpillar treads instead of wheels to provide over-snow firefighting capability during the winter months. All-terrain vehicles have a similar operating capacity to pumpers.

5. 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 including the “jaws of life”, which is designed to free people trapped in their car following a


road 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).

6. Hazardous Materials Incident Units (HazMat Van): There are nine hazardous material incident units that are used at incidents where chemicals and other hazardous substances are present. They carry an array of equipment that can be used to dam and contain chemical spills and clean up the contaminated area. Units are also equipped with decontamination showers for firefighters involved in the incident. These showers hose off chemicals the firefighters may have been exposed to when wearing their chemical protection suits.

7. 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.

8. 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 liters) and pump and are especially suited for hard to access areas.

9. Protective Equipment Units (PE Vans): There are four protective equipment units that are used to support incidents. PE Units carry additional breathing apparatus, including specialized 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 materials incidents.

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



1. Write create table statements for above tables. Make sure primary key, foreign key, not null and other constraints are included in table creation scripts. 5 Marks

2. Write insert statements to populate these tables with sample data. Create data which will meet the relational requirements. 5 Marks

3. As part of audit requirements, it is required to generate the below reports. The supervisor has once again asked you for help: Each 2 marks

a. Details of incidents and the list of staff members who were involved with those incidents.

b. Details of Trucks that were used while responding to incidents.

c. Details of staff members along with the details of shifts they have worked.

d. Details of which brigade and stations have access to which vehicles.

e. Count of members in every brigade

f. Count of members in every station

g. Count of vehicles in every station by type

h. Count of incidents that involved more than 2 members

i. Count of vehicles used in responding to incident by type of vehicle

j. Count of members who are working more than 5 shifts in a week

Note: Create ONE document for essay and query, Task 1 and 2. Paste the query and screenshots from SQL Server in the document.

Answered Same Day Jun 17, 2021

Solution

Deepti answered on Jun 18 2021
155 Votes
Contents
Introduction    2
Definition    2
History of Databases    3
Advanced Technology Developments    5
Case Study    7
Conclusion    7
References    8
“A Brief History of ERP – since 1960 and the future of ERP”. 2019-ERP Information https:
www.erp-information.com/history-of-erp.html    8
Introduction
The objective of the essay is to explore the history of databases post the year 2000, look at the differences between new technology and traditional models of data storage and retrieval. It further demonstrates the use of advanced database technology within the domain of Customer Relation Management (CRM) with the help of a case study.
Databases have played a very important role in the evolution of computers. Since the evolution of DBMS in 1960s, they have evolved substantially with the internet and the need of faster speed and processing of data. Database applications have grown substantially after 2000s for applications developed for sales transactions, vendor consolidations, PDAs, etc. Database are everywhere and are used for daily needs from predicting weather to online shopping. New trends have been witnessed which focus on making powerful technology accessible to everyone. An insight into the history of databases after 2000s is discussed in this essay to provide better understanding of their evolution. The case study of Salesforce used by the
and Pizza Hut to handle its Customer Relationship Management (CRM) System is further discussed in order to demonstrate how the advanced technology od databases facilitates the chosen industry sector for the domain of CRM.
Definition
A database is a structure set of self-describing data in the form of records. It contains description of its structure represented in the form of conceptual or physical object. A Database Management System is a system that controls database. A database along with DBMS and its applications are refe
ed as Database system or Database. The different types of databases are Object-Oriented Database, Relational Database, Distributed Database, NoSQL Database, JSON Database Graph Database, OLTP Database, open source, Cloud Database, Data Warehouse.
Relational DBMS were an efficient way to process and store structured data. Subsequently, as the processing speed got faster and unstructured data including photographs, art, etc. became common place with the revolution of the internet, the RDBMS was not the option for data management. Due to the schema-less and non-relational nature of unstructured data, Relational Database Management Systems could not handle them. This was followed by the innovation of NoSQL. Not Only SQL came into existence as a response to the requirement of faster processing of unstructured data. NoSQL database gained preference as they offered flexibility as well. It uses distributed database system to handle structured as well as unstructured data. The main advantages of this database system over RDBMS includes lower costs, distributed computing, high scalability, flexible schema, processing of both structured and unstructured data without complex relationship.
History of Databases
The computer age introduced its co
elate- database back in 1960s. Initially, it comprised of network and object-oriented DBMS. Then came the relational database concept with SQL in 1990s. Specialized database management came into existence with online analytical Processing and has seen exponential growth till today. A collection of data was initially simple collection of items. Examples included commercial CD-ROM with collection of recipes, photographs, etc. Next, the multimedia genre was introduced with database of audios, videos, texts and images which could be navigated in different ways.
Screenshots: The timeline of database evolution and development over the years as shown in (Frisendal, 2018)
The database flourished over the internet where HTML is a sequential list of individual elements. Further, since 2000 till date, big data has been working for large scale businesses with NoSQL.
A term was coined as NoSQL that refers to not only SQL databases that store or retrieve data using other query languages. Such...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here