This preview shows page 1. Sign up to view the full content.
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
- Fall '10