how to write a data table structure for the following scenario [Resolved]

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

For Primary Key (PK) creation

DesignationLevels -->  ID Primary Key, Level {  maser data ( 1= CEO, 2= Senior managers, and so on) }
Person --> PersonID ( PK) , Name, DoJ, Address, PhoneNumbe, Email
Product --> Product details { ProductID (PK), Name, UnitPrice }
Customer --> CustomerID (PK) , Name, address, email, PhoneNum, and so on
SalesPerson -->  SalesPersonID (PK) ( refer Person table) , Bonus, CommissionPct, SalesYTD, SalesQuarter), SalesPersonLevel ( -->reference of DesignationLevels table)
SalesOrders --> SalesOrderID (PK) , 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

Hi,

For which table we need to create a primary key and how to calculate bonus for quarter and half and yearly and how to write a query on the bais of sales.

Regards,
Sudheep.G.

Best,
Sudheep.

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator