Relational Database System

Customers Table

CustomerID FirstName LastName Email Phone
1 John Doe johndoe@example.com 123-456-7890
2 Jane Smith janesmith@example.com 987-654-3210

Products Table

ProductID ProductName Price StockQuantity
1 Laptop 999.99 10
2 Smartphone 699.99 20
3 Headphones 99.99 50

Orders Table

OrderID CustomerID ProductID OrderDate Quantity
1 1 1 2024-05-01 1
2 2 2 2024-05-02 2