Question 6 10 Points In a pharmacy management system, there are three tables: Patient, Customer, Order, and Product. Patient contains these attributes (ID, Name, Address, Email, and phoneNumber). Order contains these attributes (Orderld, Order_Date, TotalPayment) Product contains these attributes (productID, Description, QuantityInStock, Price) One Customer can make many orders. Order contains many products this relation is called Order Deails that contain these attributes (orderID, productID, and quantity of each item in the order). Draw the ER diagram of the above scenario. Use the editor to format your