ID | Name |
---|---|
1 | Bonners Music |
2 | Yamaha |
3 | Fender |
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 |
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 |
CustomerID | First_name | Last_name | 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 |
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 |
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 |