Consider a retail store system that must be designed to manage customers, products, and orders. The system should be designed to capture the following requirements:

Every customer has a unique customer ID$,$ name, and contact number.

Every product has a unique product ID$,$ name, description, and price.

Each order has a unique order ID$,$ date, and total amount.

Customers can place several orders.

Each order can contain multiple products

Carefully consider the relationships that exist between customers and orders, and products and orders.

Design an ER diagram that captures the relationships above. Be sure to capture all entities, relationships, and cardinalities.