tags:

views:

88

answers:

0

Hi all,

I have the following table

select * from consumer6;

Service_ID | Service_Type | consumer_feedback |

     93           Computing                            1 
     93           Computing                            1 
     93           Computing                            1 
     93          Computing                             1 
     93          Computing                             1 
     93          Computing                             1 
     93          Computing                             1 
     93          Computing                             1 
     93         Computing                              1 
     93          Computing                             1 
     93          Computing                             1 
     93          Computing                             1 
     93        Computing                               1
     93          Computing                             1 
     93           Computing                            1 
     93          Computing                             1                   
     93          Computing                             1 
     93          Computing                             1 
     93         Computing                              1            
     93       Computing                                1 
     70           Data                                     

select * from consumer5;

Service_ID         Service_Type                consumer_feedback 
     89         Computing                        -1 

I want to create 100 tables for my project.I have Service_Types(data,computing,printer).I am using the random functions

int min1=31;//printer
    int  max1=40;
    int min2=41;//data
    int max2 =70;   
    int min3=71; //computing
    int max3=75;
    int min = 1;
int max = 9;
    int min4=1;
    int max4=30;   //consumer

    int min5 = -1;
    int max5 =1;

   int feedback = (int) (Math.random() * (max5 - min5 + 1) ) + min5;


    int number = (int) (Math.random() * (max - min + 1) ) + min;    

    int provider1 = (int) (Math.random() * (max1 - min1 + 1) ) + min1;

    int provider2 = (int) (Math.random() * (max2 - min2 + 1) ) + min2;
    int provider3 = (int) (Math.random() * (max3 - min3 + 1) ) + min3;
   int consumer=   (int) (Math.random() * (max4 - min4 + 1) ) + min4;

I need the Service types to be distributed in 100 tables such that all the providers (31-40 printer,41-70 data,71-75 Computing to be distributed uniformly with feedback values generating 1 most number of times.Please help me.Thanks a lot