BuildingPermit-ER_exercise

BuildingPermit-ER_exercise - rate area (zone) related to...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
E-R Exercise: Mid-Michigan City Online Building Permits Mid-Michigan city wants to put an interactive building permit application form on its website, so those who want to do so can not only print out the permit forms, but can actually fill them out and submit them for review online . The system needs to be designed so that the city can also track and manage permit applications and cross- reference to previous applications for the same parcel. Website users should be able to access application status. Currently, permits are tracked through a manual log book that has such columns as the date filed, application number, name/address of applicant, name of building project, and location of property on which the structure will be built. An application may relate to one or more parcel of land. Each land parcel may be owned either privately or by the city. The parcel needs to somehow be identified uniquely. We know the parcel owners’ names and addresses, the parcel’s assessed tax value, and the tax
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: rate area (zone) related to the parcel. The zone says what can/cant be built on the parcel. Each building project must have some kind of description and purpose stated, and the application needs to have a status (pending, approved, denied) in the review process. Each status has an associated status date. The Planning Commission reviews and approves/denies the application. Once the application is approved, it becomes a building permit, with the specific date approved, expected completion date, and work description included. Applications can be made by several partiesthe land owner, a contractor, or an architect. Each architect has a license number issued by the city. The license also has an expiration date. Mid-Michigan city also wants to track historically the applications for building projects on each parcel of land. To Do: Draw an E-R diagram for the above, with entities, relationships, cardinality, optionality, but no attributes shown....
View Full Document

Ask a homework question - tutors are online