Company Asked : This question was asked in RBS India Technical round.
There is the retail store with different products. A costumer can place multiple orders and one order one order can contain multiple products. Product comes through a supplier.
For this business model you need to create the most accurate Data model (database diagrams) with following details and there reason.
1. Tables and there nature
2. Keys in tables.
3. Index column.
SQL Server Quest 