## Manufacturers

ID | Name
--- | ---
1 | Bonners Music
2 | Yamaha
3 | Fender

## Guitars

ID | Model_Name | Price | Quantity | ManufacturerID
--- | --- | --- | --- | ---
|  |  |  | (→ Manufacturers.ID)
1 | Epiphone Les Paul | 600.0 | 20 | 1
2 | Fender Stratocaster | 900.0 | 15 | 3
3 | Gibson SG | 800.0 | 10 | 3
4 | PRS McCarty | 3000.0 | 5 | 2
5 | Martin D-28 | 3500.0 | 7 | 2

## Pianos

ID | Model_Name | Price | Quantity | ManufacturerID
--- | --- | --- | --- | ---
|  |  |  | (→ Manufacturers.ID)
1 | Yamaha CP4 Stage Piano | 2000.0 | 10 | 2
2 | Casio Privia PX-560BK | 1000.0 | 15 | 3
3 | Roland FP-10 Digital Piano | 700.0 | 20 | 3
4 | Kawai ES110 Portable Keyboard | 500.0 | 10 | 2
5 | Nord Stage 3 | 4000.0 | 5 | 1

## Customers

CustomerID | First_name | Last_name | Email | Phone
--- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +1234567890
2 | Jane | Smith | jane@example.com | +9876543210
3 | Michael | Jackson | michael@example.com | +1112223330
4 | Emily | Davis | emily@example.com | +2223334440
5 | David | Brown | david@example.com | +3334445550

## Orders

OrderID | CustomerID | OrderDate | TotalAmount
--- | --- | --- | ---
| (→ Customers.CustomerID) |  |
1 | 1 | 2024-03-13 17:07:27 | 600.0
2 | 2 | 2024-03-13 17:07:27 | 900.0
3 | 3 | 2024-03-13 17:07:27 | 800.0
4 | 4 | 2024-03-13 17:07:27 | 3000.0
5 | 5 | 2024-03-13 17:07:27 | 3500.0

## OrderDetails

OrderDetailID | OrderID | ProductID | Quantity | UnitPrice
--- | --- | --- | --- | ---
| (→ Orders.OrderID) | (→ Products.ProductID) |  |
1 | 1 | 1 | 2 | 600.0
2 | 1 | 2 | 2 | 900.0
3 | 2 | 3 | 1 | 800.0
4 | 2 | 4 | 1 | 3000.0
5 | 3 | 5 | 1 | 3500.0