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

Info icon This 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
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/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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern