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.

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

Answered: You will have to develop a conceptual…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

can you help me with my assignment?

Transcribed Image Text:Figure: MARX Sample Company Invoice MRAX Invoice Invoice No: M1234 Date: 09/01/2021 Company Name MARX Sample Company 4567 Broad St Chicago, IL 45678 BILL TO John Doe 123 Main Street Kalamazoo, MI 12345 Email: jdoe@gmail.com marxs@gmail.com Email: Description Web Design Logo Design Database Design No Qty Unit Cost Amount $ 3000 $ 2500 $ 5000 $ 2000 1 2 1500 $ 500 $ 5000 $ 2000 3 1 4 Database Installation 1 $ 12,500 $ 500 $ 720 Amount Due $ 12,720 Subtotal Discount Тах Payment Details: Bank: Sample Bank Routing No: 222211 Account No: 123456789 Payment Amount: $ 12,720 09/14/2021 Payment Date: | More Suggestions Follow directions provided below to come up with an appropriate Conceptual Model (ERD) for MARX Sample Company Invoice. a) Identify the functional dependencies based on the data shown in the form and also any new attribute 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 3rd Normal Form compliance. d) Provide a list of relations [entities] with attributes, primary, and foreign keys. e) The questions a) – d) uses appropriate diagrams -