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]



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.


); }