Unformatted text preview: rate area (zone) related to the parcel. The zone says what can/can’t 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 parties—the 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
This note was uploaded on 11/17/2011 for the course ITM 311 taught by Professor Harrisonmcknight during the Fall '10 term at Michigan State University.
- Fall '10