
Go through this table structure once and let know if any thing missed here
DesignationLevels --> maser data ( 1= CEO, 2= Senior managers, and so on)
Person --> PersonID, Name, DoJ, Address, PhoneNumbe, Email
Product --> Product details
Customer --> CustomerID, Name, address, email, PhoneNum, and so on
SalesPerson --> SalesPersonID ( refer Person table) , Bonus, CommissionPct, SalesYTD, SalesQuarter), SalesPersonLevel ( -->reference of DesignationLevels table)
SalesOrders --> SalesOrderID, ProductID ( refer Product table) , OrderDate, DueDate, ShipDate, OrderQty, UnitPrice, Status, CustomerID, SalesPersonID ( refer SalesPerson table)
Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif
Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator