Entity Relationship Diagram Answers | Assessment Answer

Answer:

Business Rules/Assumptions

Some assumptions and business rules have been followed in the database development


The address, telephone and mobile numbers of applications, members and site inspectors.

All types of applications will be saved in separate tables to fetch the data easily.

The reason of objections is mandatory to store into the database.

The detail of cleared applications is also mandatory to store in the database.

Logical Design / 3NF Relations

Applicants (ApplicantID, Name, Address, TelPhoneNumber, Mobile)

SuburbanArea (SubAreaID, Address, Length, Width)

Lots (LotNumber, SubAreaID, Boundary1, Boundary2, Boundary3, Boundary4)

Foreign Key (SubAreaID) References SuburbanArea (SubAreaID)

Application (ApplicationID, ApplicationIssueDate, Detail, ApplicantID, LotNumber)

Foreign Key (LotNumber) References Lot (LotNumber)

Foreign Key (ApplicantID) References Applicants (ApplicantID)

TreeRemoval (ApplicationID, NumberofTress, TotalCharges)

Extension (ApplicationID, TotalCharges)

Demolition (ApplicationID, TotalCharges)

Construction (ApplicationID, TotalCharges)

LotDivision (ApplicationID, TotalCharges)

LotMerging (ApplicationID, TotalCharges)

Members (MemberID, Name, Address, TelPhoneNumber, Mobile)

Objections (ObjectionID, MemberID, ApplicationID, ObjectionIssueDate, ReasonofObjection)

Foreign Key (ApplicationID) References Application (ApplicationID)

Foreign Key (MemberID) References Members (MemberID)

SiteInspector (ID, Name, Address, TelPhoneNumber, Mobile)

ClearedApplications (ClearanceNumber, ApplicationID, ClearanceIssueDate, Detail)

Foreign Key (ApplicationID) References Application (ApplicationID)

InspectionReports (ClearanceNumber, ID, InspectionVisitDate, Details)

Foreign Key (ClearanceNumber) References ClearedApplications (ClearanceNumber)

Foreign Key (ID) References Inspector (ID) (TechTarget 2016) (Smartdraw 2016)

References

TechTarget (2016), entity relationship diagram, Available:  https://searchcrm.techtarget.com/definition/entity-relationship-diagram. [Accessed: 15-August-2016]

Smartdraw (2016), Entity Relationship Diagram, [Online]. Available: https://www.smartdraw.com/entity-relationship-diagram/. [Accessed: 15-August-2016]

Freetutes.com (n.d.), Types of attributes, [Online]. Available: https://www.freetutes.com/systemanalysis/sa7-types-of-attributes.html. [Accessed: 15-August-2016]

Edugrabs.com (2015), Types of Attributes in DBMS with Example (ER MODEL – Part 2), [Online]. Available: https://www.edugrabs.com/type-of-attributes-in-dbms/. [Accessed: 15-August-2016]

DOWNLOAD SAMPLE DOCUMENT NOW



Upload Document Document Unser Evaluion Get Money Into Your Wallet



Cite This work.

To export a reference to this article please select a referencing stye below.

Assignment Hippo (2022) . Retrive from https://assignmenthippo.com/sample-assignment/entity-relationship-diagram-answers-assessment-answer

"." Assignment Hippo ,2022, https://assignmenthippo.com/sample-assignment/entity-relationship-diagram-answers-assessment-answer

Assignment Hippo (2022) . Available from: https://assignmenthippo.com/sample-assignment/entity-relationship-diagram-answers-assessment-answer

[Accessed 27/11/2022].

Assignment Hippo . ''(Assignment Hippo,2022) https://assignmenthippo.com/sample-assignment/entity-relationship-diagram-answers-assessment-answer accessed 27/11/2022.



Buy Entity Relationship Diagram Answers | Assessment Answers Online

Talk to our expert to get the help with Entity Relationship Diagram Answers | Assessment Answers from Assignment Hippo Experts to complete your assessment on time and boost your grades now

The main aim/motive of the finance assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignment help Australia. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at www.assignmenthippo.com are so much skilled, capable, talented, and experienced in their field and use our best and free Citation Generator and cite your writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for Entity Relationship Diagram Answers | Assessment Answer Assignment Help Online

Want to order fresh copy of the Sample Entity Relationship Diagram Answers | Assessment Answers? online or do you need the old solutions for Sample Entity Relationship Diagram Answers | Assessment Answer, contact our customer support or talk to us to get the answers of it.

Assignment Help Australia
Want latest solution of this assignment

Want to order fresh copy of the Entity Relationship Diagram Answers | Assessment Answers? online or do you need the old solutions for Sample Entity Relationship Diagram Answers | Assessment Answer, contact our customer support or talk to us to get the answers of it.


Submit Your Assignment Here

AssignmentHippo Features

On Time Delivery

Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

Plagiarism Free Work

Get reliable and unique assignments by using our 100% plagiarism-free.

24 X 7 Live Help

Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

Services For All Subjects

Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

Best Price Guarantee

Get premium service at a pocket-friendly rate at AssignmentHippo

FREE RESOURCES

  • Assignment Writing Guide
  • Essay Writing Guide
  • Dissertation Writing Guide
  • Research Paper Writing Guide

FREE SAMPLE FILE

  • Accounts
  • Computer Science
  • Economics
  • Engineering

Client Review

I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

Tap to Chat
Get instant assignment help