I have been asked to create an ERD using MySQL and i have attached a picture. The relationships are Customer$-$Order: A Customer can place multiple Orders $(1$:M$).$

Order$-$Product: An Order can contain multiple Products, and each Product can appear in many Orders $($M:N$).$

Product$-$Category: A Product belongs to one Category, and each Category can contain many Products $($M:$1).$

Order$-$PaymentMethod: An Order is associated with one Payment Method, and each Payment Method can be used for many Orders $(1$:M$).$

Customer$-$Review: A Customer can give multiple Reviews, and each Review belongs to one Product $($M:N$).$

Please also tell me if any relationships are identifying relationships so with the solid line instead of dotted and if they are mandatory or not mandatory so it adds an open circle to the relationship on my sql$.$