ERD 8

8) Flipkart 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    |   |    Sold_by       |
                            +---------------+   +-------------------+
                            | order_id (FK) |   | product_id (FK)  |
                            | product_id (FK)|  | seller_id (FK)   |
                            | quantity      |   | quantity_sold    |
                            +---------------+   | price            |
                                                +-------------------+