MIS303 E-R Diagram Assignment:A1 Home Improvement (AHI) provides installation services for home improvementin Northern Virginia. AHI does not employ installers, but rather subcontracts the installations out toa list of approved installers. Whenever a customer requests an installation servicein the store, a contract is created forthe installation. AHI offers different payment options such as 20% deposit+80% after completion, 30% deposit+70% after completion, etc. AHI decides a deposit amount based on the installation job and the customer pays upfront. Then AHI will assign an installer for the installation job in the contract. Afterwards, the installer will go to the customer’s house and complete the installation. Currently, this process is primarily paper-based and does not provide managementwith the information neededto efficiently monitorcontractsand installers.AHIoften runs advertisements for specials such as guaranteed 2-week installation. Without a way to effectively manage installations, installation service sometimes does not get completed within the promised timeframe which has resulted in customer dissatisfaction. You are hired by AHI to create a databasethathelps automatically tracks installation contracts and installers.The databasemust keep track of each AHI customer,including their unique customer ID, first name, last name, street address, city, state, zipcode, and phone number. It also keeps track of all approved installers, including their unique installer ID, SSN(i.e., social security number), first name, last name, city, state, zipcode, phone number, and daily charge (i.e., how much AHI pays to the installer for one day’s work). In addition, the database records each payment option, including unique payment option IDand depositpercentage. In order to provide management with the information needed to effectively track installations, the database keepstrack of the detailsfor each installationcontract, including unique contract ID, the ID of the customer who requests the service, the ID of the installer assigned to complete the installation, description of the requested installation job, the service charge amount (i.e., how much the customer need to pay to AHI for the installation service), the ID of the payment form, the date the contract is created, the date an installer is assigned toMIS303: E-R Diagram Assignment

Page 2of 2work on the installation, the date the installation is completed by the installer, and the customer’s ratingof the job performed by the installerafter the job is finished.Each installation contract may have not been assigned an installer yet, but once assigned each installation is assigned to only oneinstaller.An installer might have not been assigned to any installationor might have been assigned to multiple installations. Each installation contract is associated with one payment option, but each payment option may have not been used for any installation contract yet or may have been used for multiple installation contracts. The database only records existing customers who has requested services from AHI.While a customer might have requested for multiple installations, each installation is for one customer. Q. Carefully read the above business description and draw an Entity-Relationship Diagram (E-R diagram) using Microsoft Powerpoint 2016for the databasethat is required for AHI’s tracking system. Make sure that:1)Your E-RDiagramincludesall necessaryentities, attributes, and relationships.Hint: since each installation is represented as a contract, installation or contract or installation contract are the same.There are two ways to represent an entity. You do NOThave to do both. You only need to choose one way and the following way is highly recommended as it saves space.2)For each entity, you need tounderline its identifier.3)For each relationship, you need to give it a meaningful name(remember that arelationship should have a name with a verb).4)For each relationship, you needto specify the relationship type andcardinality numberson both sides of the relationship correctly based on the given business rules.5)Make sure that the E-R diagram looks professional: the boxes for entities and the diamonds for relationships are clearly separated from each other rather thanbeing overlapped; the lines are connecting to boxes for entities and diamonds for relationships; the numbers for cardinalities are written at the appropriate positions (i.e., near the entities and are not overlapping with the lines).Hint: you may copy the E-R diagram styles for the examples in the lessons.6)Nameyour finished Powerpoint fileexactly as your last name followed by your G number without “G”and then followed by suffix “_ER_diagram”(there should not be extra spaces or underlines in between; e.g. Ye12345678_ER_diagram.pptx)and submit it via Blackboard.MIS303 E-R Diagram Assignment