Can U Give Me The Solution For These?

You have to design a database for retail company that manufactures products and sells it directly to their customers through sales agents. The tables should capture information related to the company, products, inventory, salesmen, customers and transactions. Once the database is ready with some minimal test data, write queries to generate following results:
– List the number of different products sold by each salesman
– List number of products that are purchased by each customer
– List each salesman is selling products to how many customers
– How many products are below reorder level
– List the total(Amount) purchases done by each customer
– List Month wise units sold for each Product
– List the profit (SP-CP) generated by each salesman after discounts

Both comments and pings are currently closed.

One Response to “Can U Give Me The Solution For These?”

  1. Mitchell says:


Powered by WordPress | Designed by: free css template | Thanks to hostgator coupon and web hosting reviews