Case Study
The CQ-Council (hereafter called as council) posts a full page advertisement, in local newspapers once a month, displaying all the Development Plan applications (here after called as application) that have been received during the previous month from the developers/ owners of the plots under the council’s purview.
General public members are allowed to raise objections against the applications that appear on those advertisements within a certain period of time, such as two weeks from the date of the advertisement. The council maintains the details of those objections and the respective application details. The council maintains all such objections even if they are from an anonymous member of the public.
The council also maintains detailed records of the following:
suburban areas in the council
lots in each suburban area
subdivision/merger plans
plots and owners
For your information, the council designates some of its suburban areas for recreation, community, commercial, residential, etc. Some parts of the land, in each suburban area, are allocated for approach road and street facilities. The remaining land in a suburban area is further divided into land parcels (here after called as lots). Each of such lots has a unique lot number and details of at least three boundaries and at most four boundaries.
Assignment Requirements
You are expected to create an information system to cater the above information needs of the council. In this assignment, conceptual and logical design phases of the development of that information system have to be carried out. The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.