Question: You need to generate 100 rows of random test data. The data should have the following columns: Field Name CustomerID FirstName LastName CreditLimit CustomerSince EmailAddress

You need to generate 100 rows of random test data. The data should have the following columns:

Field Name CustomerID FirstName LastName CreditLimit CustomerSince EmailAddress InterestRate State Data Type

Field Name CustomerID FirstName LastName CreditLimit CustomerSince EmailAddress InterestRate State Data Type Integer String String Floating Point Number Date String Floating Point Number String Range Random (50-5500) Valid Name - 2 to 20 characters in length Valid Last Name - 2 to 40 characters in length. Currency Format from 100.00 to 10000.00 Random Date from July 1, 2015 - Today prefix@domain Random (0.00 to 15.00) Format Standard Integer Most of the names should be first letter upper case. It can be multiple names, hyphenated, mixed case, and include ' in the name. Random MD, DE PA, or VA 99999.99 format 2015-11-25 Valid email address 99.99 format XX

Step by Step Solution

3.39 Rating (143 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!