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.

مهارات العمل
شارك
بطاقة العمل
تاريخ النشر
منذ 3 أسابيع
المشاهدات
23
المستقل
Shams Mahmoud
Shams Mahmoud
محلل بيانات
طلب عمل مماثل
مهارات العمل
شارك
مركز المساعدة