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