Computers and Technology

You recently started work as a researcher for a college. The job's main responsibility is to query data from the college's database and produce reports. The first report you have been asked to create involves student demographic data (age, race, ethnicity, gender, etc.) After doing some digging around the database you locate which tables you need to query to generate the report. You break the report into age ranges of: under 18, 18 to 24, 25 to 39, 40 to 65, 65 to 99, 100+. You then release the report to your boss to distribute it to the college executives. A few days later the college president stops by your office. He is impressed with your work but had a few questions. He noticed that the college has 5 students who are over 100 years old. He wants to do something special for their birthdays to show his appreciation and maybe use the occasion to generate some good publicity for the college. He asks you to pull up the addresses and birthdays for those 5 students. After he leaves you quickly get to work. You find the correct fields in the database and generate a report. Looking over the report you notice that all five students have the same birthday 1/11/1911. You decide to make some phone calls and find out what’s going on. To make a long story shorter you discover that the "Date of birth" field is a required field when registering students but some of the remote sites put 1/11/1911 in this field when students fail to provide a date of birth or the one provided is clearly wrong (for example when they put in today’s date).

Based on this information prepare a post that addresses the following:

a. What do you think should be done to address the data integrity issue of dummy values?
b. What should you always check for when creating a report to list ages?
c. Is there anything else you can do to detect bad date of births besides looking for 1/11/1911?

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 18:20, dinosaur10
Geneva’s manager would like to see some additional information to make sales decisions. enter a formula in cell j4 using the if function to it whether or not the item beaded earrings should go on sale. it will go on sale if its current sales rank (in cell g4) is 8th or lower. (hint: if the cell value is greater than or equal to 8, it will go on sale.)if this condition is true, the item will go on sale. (hint: the if_true value should be “yes”.)if this condition is false, the item doesn’t need to go on sale. (hint: the if_false value should be “-”.)copy the formula created in cell j4 to the range j5: j14
Answers: 2
image
Computers and Technology, 22.06.2019 06:00, wbrandi118
What role do chromosomes play in inheritance?
Answers: 1
image
Computers and Technology, 23.06.2019 01:20, shiann2002
Me with this program in c++ ! computers represent color by combining sub-colors red, green, and blue (rgb). each sub-color's value can range from 0 to 255. thus (255, 0, 0) is bright red. (130, 0, 130) is a medium purple. (0, 0, 0) is black, (255, 255, 255) is white, and (40, 40, 40) is a dark gray. (130, 50, 130) is a faded purple, due to the (50, 50, 50) gray part. (in other word, equal amounts of red, green, blue yield gray).given values for red, green, and blue, remove the gray part. ex: if the input is 130 50 130, the output is: 80 0 80. thus, find the smallest value, and then subtract it from all three values, thus removing the gray.
Answers: 3
image
Computers and Technology, 23.06.2019 02:30, chaaaa
People with high self-esteem: accept their strengths and weaknesses. believe that failed experiences are failures of their whole self. feel good about who they are only when they reach total success. need positive external experiences to counteract negative feelings that constantly plague them.
Answers: 1
Do you know the correct answer?
You recently started work as a researcher for a college. The job's main responsibility is to query d...

Questions in other subjects:

Konu
English, 08.07.2020 14:01