subject

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?

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 10:20, vuqepete4528
Shown below is the start of a coding region within the fist exon of a gene. 5'--3' 3'--5' how many cas9 pam sequences are present?
Answers: 1
image
Computers and Technology, 22.06.2019 16:50, Tyrant4life
Consider a slotted aloha system, where the time slot equals the fixed duration of each packet. assume that there are 4 stations a, b,c, d sharing the medium. (a) stations a, b,c, d receive one packet each from higher layers at times 1.3, 1.5, 2.6,5.7 respectively. show which transmissions take place when, according to the slottedaloha protocol; describe all transmissions until all four packets have been successful. when needed, each station has access to the following sequence of random number, provided by a random number generator and drawn uniformly between 0 and 1: (1) station a draws numbers: 0.31, 0.27, 0.78, 0.9, 0.9, 0.11, 0. (2) station b draws numbers: 0.45, 0.28, 0.11, 0.83, 0.37, 0.22, 0. (3)station c draws numbers: 0.1, 0.2, 0.3, 0.4, 0. (4) station d draws numbers: 0.36, 0.77, 0.9, 0.1, 0.1, 0.1, 0.1, 0. (b) in slotted aloha, a station transmits in each time slot with a given probability. what probabilities would you assign to each of the four stations so as to: (i) maximize the efficiency of the protocol? (ii) maximize fairness among the four stations? (c) will the efficiency increase or decrease if we modify slotted aloha as follows: (i) get rid of slots and allow stations to transmit immediately? (ii) implement carrier sensing? (iii) implement collision detection? (iv) implement collision avoidance?
Answers: 3
image
Computers and Technology, 24.06.2019 12:30, stephanieanaya7
Why does the pc send out a broadcast arp prior
Answers: 1
image
Computers and Technology, 24.06.2019 16:50, genyjoannerubiera
Ramp charts are generally created in wordlotusexcelpowerpoint
Answers: 1
You know the right 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
Chemistry, 23.01.2020 17:31