ER 10

10) Online Medical Store ER Diagram:

                                    +-------------+
                                    |   Customer  |
                                    +-------------+
                                    | customer_id (PK)
                                    | name
                                    | email
                                    | address
                                    +-------------+
                                            |
                                            |
                                  +---------+---------+
                                  |                   |
                          +-------+-------+   +-------+-------+
                          |     Places    |   |     Product   |
                          |    Order      |   +---------------+
                          +---------------+   | product_id (PK)|
                          | order_id (PK) |   | name          |
                          | customer_id (FK)|  | price         |
                          | order_date    |   | description   |
                          | status        |   +---------------+
                          +---------------+
                                                |
                                                |
                                    +-----------+-----------+
                                    |                       |
                            +-------+-------+   +-----------+-------+
                            |   Contains    |   |    Sourced_from  |
                            +---------------+   +-------------------+
                            | order_id (FK) |   | product_id (FK)  |
                            | product_id (FK)|  | pharmacy_id (FK) |
                            | quantity      |   +-------------------+
                            +---------------+