AADVERTISEMENT AdvertisementId AdvertisementDate NEWS_PAPER NewsPaperId Name OBJECTION ObjectionID Description ObjectionType ObjectionDate AdvertisedDate Charges contains against d d Direction INSPECTION InspectionId InspectionDate Report Result INSPECTOR InspectorId InspectorName ContactNumber CLEARED_APPLICATION ClearedDate APPLICATION ApplicationId ApplicationDate TotalCharges ApplicationType LOT LotNumber StreetName DEVELOPER ABNNumber OWNER_BUILDER OwnerDeveloperCe rtificationDate TREE_REMOVAL_ APPLICATION NumberOfTrees PERSON PersonId Name Address(StreetNumber, StreetName, Suburb, State, PostCode) PersonType OWNER d does peformed on makes is for NEWS_PAPER_AD o CONSTRUCTION MERGER/ SUB_DIVISION Merger/ SubDivisionPlan IsOwnerBuilder ApplicationType = PersonType = IsOwnerBuilder = ApplicationType = "CA" "Y" "O" "D" "CA" "C" "M" "T" CHARGES ApplictionCategory Amount applies submits SUBURB SuburbName PostCode situated in DEMOLITION DemolitionDate BUILDING BuildingPlan o EXTENSION ExtensionPlan ConstructionType Construction Type = "E" "B" "D" REJECTED_APPLICATION RejectedDate Reason "R" owns BOUNDARYThe assumptions could vary depending on the ERD drawn by the student. However, some of the assumptions and business rules relevant to the above ERD have been presented below: There can be other application types other than tree removal, building and merger/sub division. If an application is for Tree removal then it cannot be for building or for merger/sub division or an Unknown type. Even though a lot may be owned by many persons in the real world, each lot is assumed to have only one owner; each lot is situated in one suburb only. Each boundary is assumed to have a lot number. Only some owners are owner builders. There can be other types of persons other than developers and owners. Each developer should have an ABN number. Each owner builder should have an owner developer certification. A listed newspaper company might not have received any advertisement from the council. The same advertisement may appear in more than one newspaper. However, for the same advertisement, each newspaper can charge different amounts to the council. There may be no objection for an application; an application might have received many objections too. Each objection is received from at most one person only. Only some objections specify the details of the persons who raised it. An inspection can be carried out only after application clearance (date). A new inspector might not have performed any inspection. Each inspection should have a unique inspectionId; each application should have a unique applicationId.Even though the total charges for an application are calculated, it has been shown as stored attribute to avoid complex calculation-coding in the application.