CustomerID | FirstName | LastName | Phone | |
---|---|---|---|---|
1 | John | Doe | johndoe@example.com | 123-456-7890 |
2 | Jane | Smith | janesmith@example.com | 987-654-3210 |
ProductID | ProductName | Price | StockQuantity |
---|---|---|---|
1 | Laptop | 999.99 | 10 |
2 | Smartphone | 699.99 | 20 |
3 | Headphones | 99.99 | 50 |
OrderID | CustomerID | ProductID | OrderDate | Quantity |
---|---|---|---|---|
1 | 1 | 1 | 2024-05-01 | 1 |
2 | 2 | 2 | 2024-05-02 | 2 |