Question

Create a data file with 1000 lines. Each line in the file consists of an employee’s first name, last name, position rank, and salary. The employee’s first name and last name for the i- th line are FirstName and LastName. The position rank is randomly generated as a clerk, supervisor, manager, director.

The salary is randomly generated as a number with two digits after the decimal point. The Salary for a clerk should be in the range from 40,000 to 50,000, for supervisor from 60,000 to 80,000, and manager from 75,000 to 90,000, and director from 85,000 to 120,000. 

Answer 1

First of all we will create a table employeee with id,first name,last name,position_rank,salary

then we will create a procedure .........

declare @id int

select @id = 1

while @id >=1 and @id <= 1000

begin

insert into employeee values(@id, 'First Name' ,'Last Name',(RAND()('Clerk','Supervisor','Manager','director')),(RAND()(120000-40000+1)+120000);

if @position_rank=='clerk'

begin

set @salary=floor(RAND()(50000-40000+1)+50000)

end

if @position_rank=='supervisor'

begin

set @salary=floor(RAND()(80000-60000+1)+80000)

end

if @position_rank=='manager'

begin

set @salary=floor(RAND()(90000-75000+1)+90000)

end

if @position_rank=='director'

begin

set @salary=floor(RAND()(120000-85000+1)+120000)

end

select @id = @id + 1

end