please identify the primary keys and relationships between tables (one to many, many to many, etc):

I need this table to go from normalized form to final form example below:

6. Design the Entity-Relationship Diagram for the database we need for new system. Make sure to include necessary entities and attributes and specify the key fields and relationships. Imagine that we have collected some sample data. In our scenario, a technician from the service department will be assigned to a customer for different jobs. Then, the customer rate the performance for each completed job. Below is a table that shows our collected data. Design the database. Make sure to specify all tables and their attributes. Also, make sure to design the ERD for this database. If you want to assume a larger database with additional fields and tables, you can expand your ERD. The standard notation method for an unnormalized design: - NAME (FIELD 1, FIELD 2, FIELD 3, (REPEATING FIELD 1, REPEATING FIELD 2)) - ORDER (ORDER, DATE, (PRODUCT NUMBER, DESCRIPTION, NUMBER ORDERED, SUPPLIER NUMBER, SUPPLIER NAME, ISO)) Our Final result: ORDER LINE in 2NF SUPPLIER in 3NF Systems Analysis Design, 12th Edition. @2020 Cengage. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use