Reference no: EM13694921
1. Question: A student data, or a student record, which consists of the following set of fields:
o ssid (social security id) is ddd-dd-dddd where d is a digit (0-9).
o name has two fields, fname and lname, each of which is a character string. Both must start with an uppercase letter (A-Z) followed by [1, 12] length of lowercase letter(s), e.g., (fname, lname) = (John Doe).
o major, one of the strings CS, EE, ME, CE, where roughly 50% of students must major in CS.
o scores of
o midterm1, picked from N (60, 12).
o midterm2, picked from N (55, 13). and
o final, picked from N (46, 14).
The data must have the following probabilistic properties:
o values of ssid, fname, lname must be generated at random using specified uniform distributions, i.e., [X, Y] means that some random value between X and Yis chosen for each record by your implementation.
o N (X, Y) means normal distribution, in which X is a mean and Y is a standard deviation, and to generate a random number from normal distribution, visit this site showing the way to generate Gaussian Random Numbers and adapt the sample program found there (obey copyright).
Your program requires reading the number of student records to generate.
All the generated data needs to be shown to a screen.
Output format is free -- wisely compose output layout for easy browsing of the contents.
Answer this question and show each and every step with example.
Write a select statement that returns four columns
: Write a SELECT statement that returns four columns from the Products table: ProductCode, ProductName, ListPrice, and DiscountPercent. Then, run this statement to make sure it works correctly.
|
Draw the structure of the major organic product
: Problem- Draw the structure of the major organic product you would expect from the reaction of 1-bromopropane with NaI.
|
Generate gaussian random numbers
: Generate Gaussian Random Numbers and adapt the sample program found there (obey copyright).
|
Picbasic program
: Comment the function associated with every line of the following PICBASIC program
|
Generate a random number from normal distribution
: lname must be generated at random using specified uniform distributions, i.e., [X, Y] means that some random value between X and Yis chosen for each record by your implementation.
|
What is the final volume of the gas
: Problem- A sample of gas occupies a volume of 74.8 mL. As it expands, it does 116.3 J of work on its surroundings at a constant pressure of 783 torr. What is the final volume of the gas?
|
The half-lives of different radioisotopes
: Problem- The half-lives of different radioisotopes are given in the table below. How long would it take (in minutes) for the amount of argon-44 to decrease from 88.0 mg to 11.0 mg
|
Water at an initial temperature what is final temperature
: If all the energy obtained from burning 1.26 pounds of ethane (fuel value is 11.36 kcal/g) is used to heat 123.0 kg of water at an initial temperature of 22.0 °C, what is the final temperature
|
Two solutions used in atomic absorption measurements
: Problem- Two solutions used in atomic absorption measurements with an acetylene/air flame contain equal concentrations of calcium. For each of the conditions given below, indicate which of the two solutions will yield the higher absorbance value a..
|