1. Map the Conceptual EERD given on figure 1 to produce a complete LOGICAL ERD. This LOGICAL ERD needs to include all the correct tables, relationships, multiplicity constraints, attributes, primary keys and foreign keys. Please provide the correct logical EERD diagram, this question was submitted before, but the wrong answer was given.

Contract Customer subscribes to Staff contractRefNo(PK) contractStartDate 1..1 CustNO{PK) contractEndDate custName staffNo(PK) contractYearlyCost custSumame staffFullName custEmail staffMobNo custMobileNo staffEmail 1..1 1..1 1..1 covers [optional, and} instigates is registered (optional, or) for Corporate Individual Engineer Initial_Assessor Property companyName indivAddress is broken down in techExpertise propertyld(PK} 1..1 streetAddress postCode city makes conducts property TelNo heatSystemSpecif Maintenance_Visit 1..1 Payment visitNo[PK} takes place at at visitDate Time visitStatus paymentRefNo[PK] visitNotes paymentDate paymentAmount {mandatory, and} {mandatory, or} Servicing Repair Part requires is for Oneoff_Payment Instalment issueDescrip partRefNo(PK) 0..1 partName partDescrip frequency 0 * partPrice