Manufacturers

IDName
1Bonners Music
2Yamaha
3Fender

Guitars

IDModel_NamePriceQuantityManufacturerID
(→ Manufacturers.ID)
1Epiphone Les Paul600.0201
2Fender Stratocaster900.0153
3Gibson SG800.0103
4PRS McCarty3000.052
5Martin D-283500.072

Pianos

IDModel_NamePriceQuantityManufacturerID
(→ Manufacturers.ID)
1Yamaha CP4 Stage Piano2000.0102
2Casio Privia PX-560BK1000.0153
3Roland FP-10 Digital Piano700.0203
4Kawai ES110 Portable Keyboard500.0102
5Nord Stage 34000.051

Customers

CustomerIDFirst_nameLast_nameEmailPhone
1JohnDoejohn@example.com+1234567890
2JaneSmithjane@example.com+9876543210
3MichaelJacksonmichael@example.com+1112223330
4EmilyDavisemily@example.com+2223334440
5DavidBrowndavid@example.com+3334445550

Orders

OrderIDCustomerIDOrderDateTotalAmount
(→ Customers.CustomerID)
112024-03-13 17:07:27600.0
222024-03-13 17:07:27900.0
332024-03-13 17:07:27800.0
442024-03-13 17:07:273000.0
552024-03-13 17:07:273500.0

OrderDetails

OrderDetailIDOrderIDProductIDQuantityUnitPrice
(→ Orders.OrderID)(→ Products.ProductID)
1112600.0
2122900.0
3231800.0
42413000.0
53513500.0