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

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 22:00
Which is produced by the endocrine system to control how cells and organs function
Answers: 2
question
Computers and Technology, 22.06.2019 20:00
What statement best describes operating systems? it’s possible for modern computers to function without operating systems. most operating systems are free or very inexpensive. operating systems are managed by the computer’s microprocessor (cpu). operating systems manage the computer’s random access memory (ram).
Answers: 1
question
Computers and Technology, 23.06.2019 01:50
Free points just awnser this. what should i watch on netflix
Answers: 2
question
Computers and Technology, 23.06.2019 13:30
Jace needs to answer a question on square roots to win a quiz. how can he use a spreadsheet to find the square root of 786? a. use the functions round and count b. create a table and chart c. use the function sqrt d. use the function now
Answers: 3
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
question
Health, 09.03.2021 06:20
question
Mathematics, 09.03.2021 06:20
question
Mathematics, 09.03.2021 06:20
question
Mathematics, 09.03.2021 06:20
question
Mathematics, 09.03.2021 06:20
Questions on the website: 13722362