FIT9132 - Introduction to Databases - IT/Computer Science Assignment Help

Assignment Task

This task continues the work you have started in assignment 1A by refining/extending the model you developed and implementing it as a set of tables under your Monash Oracle database account. 
Since this is an ongoing development process based on your assignment 1A submission and marker feedback, you must ensure that your assignment 1A submission and the marker feedback remains confidential and is only seen by yourself and the FIT9132 teaching staff. 
Assignment 1B's brief must be read in conjunction with the assignment 1A brief - i.e. your final model must encompass both sets of requirements. 
You may modify your assignment 1A conceptual model in any manner you wish as you work through assignment 1B, provided your final model meets both sets of requirements. 
In developing your final logical data model, composite attributes present on your conceptual model must be expanded into their component simple attributes, unless otherwise directed. If the supplementary material presented in this document does not guide you in deciding the components you may make any reasonable decision on their simple component attributes. 
Further research has revealed that the FDAS must keep full historical details of all building fire damage. The following points need to be considered in your further development: 
A building may be damaged due to a fire event: 
If the building is partially damaged the building will be repaired. If further permits are required to facilitate this repair the FDAS system will not record their details, the FDAS will only maintain the original approval under which the building was built. 
If the building is damaged beyond repair the owner may choose to rebuild. If they do rebuild the new building will be assigned a new building number for that property. The date the new building was approved for construction and the size of the new building in square metres will be recorded within the FDAS. 
Fire assessors, which are identified by an assessor_id, may change employment from one insurer to another (they cannot assess for multiple insurers at the same time). To keep track of the historical employment of a particular assessor the date at which they started assessing for a particular company is recorded. When they leave employment with a particular insurer the date they stopped assessing for that company is also recorded. 
Since the owner name for a property may be an individual’s name, a business name or the name of the body corporate, the FDAS requires that owner name not be treated as a composite attribute. FDAS is also happy to keep the Chief Executive Officer's name for an LGA and all contact phone numbers as simple attributes. 
The property types which FDAS currently record are: "farm property, a residential property (in a city or town) or a business property". Discussions have indicated that this range of property types needs to be expanded and be such that it can be added to/modified as needed on a regular basis. 
When a new fire is detected, it is added to the FDAS immediately. Initially, attributes which record the impact of the fire, such as area burnt, are set to 0 and will be updated as the fire proceeds and data is gathered. After a fire passes through a particular area, first level responders (fire personnel 
or police officers) move through the area and record details of buildings which have been damaged and whether the building has been totally destroyed or not. These details are then added into the FDAS. Note that FDAS are not interested in recording details about the first level responders, only the property damage they note. 
At a later stage, when the site is safe, insurance companies will schedule assessor visits to those buildings which were insured at the time of the fire impact. Assessor visits will be added to the FDAS after the visit has been completed. The assessor will provide the damage cost for an insured building when they have completed all necessary visits. 
Buildings which are not insured will have their damage cost estimated by the LGA on the basis of the recorded LGA building value. 

Assumption
1- Each time a fire happens a unique fire code isassigned.
2- With that unique code we can see the date and location of the fire 3- We save the size of the fire aswell
4- A fire may start another fire, we record that as well. It will be a unaryrelationship.
5- A fire may occur in many LGAs and an LGA might have many fires happening at the same time in different area of a specificLGA.
6- In each FIRE EVENT a specific location for the fire isrecorded
7- The recorded specific location might be part of on or manyLGA
8- There will be 3 different property type to assess the fire damages. 9- An owner might have severalproperties
10- If someone has no property, we won`t call themowner
11- To align with the business rule, we consider a property type in our design which is individual owner or bodycorporate
12- We assume each assessor works only for one insurancecompany
13- If there is no building damage, we won`t record any building damage so cardinality must be one.
14- A building might catch fire manytimes.

This FIT9132 IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.