Example.xlsx
Sales
| ProductNameID | ProductName | ProductDescription | | ProductTypeID | ProductType | Description |
| 1 | Dell Desktop Tower | dummydata | | 1 | Desktop Tower | dummydata |
| 2 | Asus Monitor | dummydata | | 2 | Monitor | dummydata | | Color Key |
| 3 | Microsoft Keyboard | dummydata | | 3 | Keyboard | dummydata | | Primary |
| 4 | Logitech Mouse | dummydata | | 4 | Mouse | dummydata | | Foreign |
| | ProductID | ProductNameID | ProductTypeID | DateListed | MerchantID | QuantityInStock | Price | SalesTypeID | IsAvailable |
| | 1 | 1 | 1 | 9/19/20 | 1 | 50 | 500 | 1 | T |
| | 2 | 2 | 2 | 9/18/20 | 2 | 40 | 200 | 1 | T |
| | 3 | 3 | 3 | 9/17/20 | 3 | 70 | 50 | 2 | T |
| | 4 | 4 | 4 | 9/16/20 | 4 | 0 | 30 | 2 | F |
| MerchantID | Merchant Name | | ServicesNameID | ServiceName | Description | | SalesTypeID | Type | Description |
| 1 | Dell | | 1 | Amazon Music | dummydata | | 1 | In Person | dummydata |
| 2 | Asus | | 2 | Netflix | dummydata | | 2 | Online | dummydata |
| 3 | Microsoft | | 3 | Google Work | dummydata |
| 4 | Logitech | | 4 | OneDrive | dummydata |
| 5 | Amazon | | | | | | SubscritionTypeID | Type | Description |
| 6 | Netflix | | | | | | 1 | Monthly | dummydata |
| 7 | Google | | | | | | 2 | Annual | dummydata |
| | ServiceID | ServiceNameID | ServiceTypeID | MerchantID | IsAvailable | DateAvailable | Price | SubscritionTypeID |
| | 1 | 1 | 1 | 5 | T | 8/1/20 | 2.99 | 1 |
| | 2 | 2 | 2 | 6 | T | 10/31/20 | 12.99 | 1 |
| | 3 | 3 | 3 | 7 | T | 2/1/20 | 100 | 2 |
| | 4 | 4 | 4 | 3 | T | 7/31/20 | 130 | 2 |
| | | | | ServicesTypeID | ServiceType | Description |
| | | | | 1 | Music Streaming | dummydata |
| | | | | 2 | Video Streaming | dummydata |
| | | | | 3 | Productivity | dummydata |
| | | | | 4 | Storage | dummydata |
daven9947
