can you help me with my assignment? Figure: MARX Sample Company InvoiceMRAX InvoiceInvoice No: M1234Date: 09/01/2021Company NameMARX Sample Company4567 Broad StChicago, IL 45678BILL TOJohn Doe123 Main StreetKalamazoo, MI 12345Email: jdoe@gmail.commarxs@gmail.comEmail:DescriptionWeb DesignLogo DesignDatabase DesignNoQtyUnit CostAmount$ 3000$ 2500$ 5000$ 2000121500$ 500$ 5000$ 2000314Database Installation1$ 12,500$ 500$ 720Amount Due $ 12,720SubtotalDiscountТахPayment Details:Bank:Sample BankRouting No:222211Account No:123456789Payment Amount: $ 12,72009/14/2021Payment Date:|More SuggestionsFollow directions provided below to come up with an appropriate Conceptual Model (ERD) forMARX Sample Company Invoice.a) Identify the functional dependencies based on the data shown in the form and also any newattribute that may be required. Draw a dependency diagram.b) Identify the attributes, primary, and foreign keys in final relations.c) Draw Entity-Relationship diagrams (ERDS). Make sure that final ER diagram is up to 3rdNormal Form compliance.d) Provide a list of relations [entities] with attributes, primary, and foreign keys.e) The questions a) – d) uses appropriate diagrams- You will have to develop a conceptual data model based on an application, specifically, a UserInterface (UI). In Assignment1, work processes, tasks, business rules and constraints wereprovided in the case. In this assignment, however, only a user interface is provided (Figure)Based on the data displayed on the UI, you need to come up with ER Diagrams using reverseengineering approach. In other words, you need to develop an ER diagram from a UI.Suggested steps1. Start with the first UI.2. Write down all attributes [data elements] on a piece of paper as if all attributes belong in onebig table.3. Identify any business rules, constraints, additional attributes which will be required to supportForm.4. Create a dependency diagram. Once dependency diagram is formed, you will have an idearegarding entities and their related attributes.5. Apply your knowledge of Determinants and dependencies to divide this big entity [table] intosmaller entities [tables].6. Relate newly created smaller entities [tables] by identifying Primary Keys (PKs) & ForeignКeys (FKs).7. Develop a complete ER diagrams for the UI. Make sure that final ER diagram is up to 3rdNormal Form compliance.

Question

Accepted Answer

The given problem is related to database desiging where the sample tables and sample data is given.…