Sales Database sql

I designed and implemented a database consisting of three related tables that demonstrate the relationship between Salesmen, Customers, and Orders.

Salesman Table: Stores details of each salesman such as ID, name, city, and commission rate.

Customer Table: Stores customer information including ID, name, city, grade, and the salesman responsible for each customer.

Orders Table: Stores order details such as order number, purchase amount, order date, customer ID, and salesman ID.

I created relationships between the tables using Primary Keys and Foreign Keys to represent the connections between salesmen, customers, and their orders.

The final structure demonstrates how sales data can be organized and managed in a systematic way, which can be applied to any sales management or CRM system.