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 |
+-------------------+
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter