Sales Management Database Excel

I designed and organized a sales management database using Excel, which consists of multiple related tables:

1. Customers Table

Stores customer information: CustomerID, full name, phone number, country, money transfer method, and email.

Includes sample records of customers from different countries (Syria, UAE, Saudi Arabia, Egypt, etc.).

2. Orders Table

Contains order details: OrderID, CustomerID, ProductID, quantity, SalesPersonID, order date, status, and total cost.

Links customers, products, and employees through their IDs.

3. Employees Table

Stores employee details: EmployeeID, full name, email, department, employment status (Full-Time, Part-Time, Contract), hire date, salary, and job rating.

4. Products Table

A placeholder for product data (currently empty, but structured to be filled with product information).

Key Points:

Designed a structured database that connects customers, employees, orders, and products.

Established logical relationships using IDs (CustomerID, SalesPersonID, ProductID).

Demonstrates how business sales data can be managed and analyzed effectively.