Given the following table for ordering (a), note that each order have one itemproduct) only. Order Number Order Date Product Name Purchase Cost Selling Price Supplier Name Product Quantity 1. 8/3/2021 Runroad 1200 250.95 350.99 Bicyclist's Choice 3 6/2/2021 Runroad 1300 501.11 661.54 Bicyclist's Choice 4 3 5/10/2021 Eagle 1 410.01 574.01 Run-Up Bikes 3 5/13/2021 Runroad 1200 350.99 Bicyclist's Choice 4 250.95 5 5/20/2021 Eagle 2 401.11 561.54 Run-Up Bikes 4 1-As you learned from database chapter what is the problem in the above table ? 2-In order to fix this problem, design database with different entities and put the fields in each entity 3-make primary key(s) and foreign key(s) for each entity if exists to make relation between them. 4-what are the relation type between each entity? send your answers by 27-08-2021. Good luck