Read thee scenario given below and answer given questions?

 

Chapter 6 Foundations of Business Intelligence: Databases and Information Management 239 INTERACTIVE SESSION ORGANIZATIONS Databases Where the Data Aren't There On November 5, 2017 Devin Patrick Kelley walked into the First Baptist Church in Sutherland Springs, Texas toting a Ruger AR-556 semi-automatic rifle and fired round after round into the congregation gathered for Sunday morning services. Within a few minutes, he had killed 26 people and injured 20 others. Kelley was later found dead in his SUV with a self-inflicted gunshot wound. The attack was the deadliest mass shooting by an individual in Texas, the fifth-deadliest mass shooting in the United States, as well as the deadliest shooting in an American place of worship in modern history. This tragedy could have been avoided. Kelley was prohibited by law from purchasing or possessing firearms and ammunition due to a 2012 domestic vio- lence conviction in a court martial while he was serv- ing in the U.S. Air Force. The Air Force failed to record the conviction in the Federal Bureau of Investigation (FBI) National Crime Information Center (NCIC) da- tabase, which is used by the National Instant Check System (NICS) to flag prohibited gun purchases. This allowed Kelley to pass background checks and pur- chase four guns, one in each of the past four years. 130 Federally licensed firearm dealers are required to check the credentials of every potential buyer against the NICS system containing millions of crimi- nal history records and protection orders. The sys- tem is supposed to flag any potential gun buyer who falls in various categories prohibiting a sale including fugitives, convicted felons, or those with dishonor- able discharges from the military. The Air Force acknowledged that it did not inform federal authorities about the domestic violence convic- tion, which should have prevented Kelley from buying firearms. Ann Stefanek, an Air Force spokesperson, stated that the Air Force would conduct a comprehen- sive review to ensure records in other cases have been reported correctly. The Defense Department plans to review how all U.S. military services report such cases into the background-check system. Members of the U.S. Senate have called for legislation to improve the completeness of NICS recordkeeping. Individuals familiar with how NICS works ob- served that large gaps in information sharing between the military and the Justice Department have created a blind spot in background checks of veterans, al- lowing those barred from possessing weapons to get clearance. They believed that the failure to flag Kelley more likely reflected a systemic flaw rather than a one-time miss. Robert Belair, a Washington privacy lawyer and expert on the FBI's background-screening system, said the Air Force and other branches of the military seldom submit court-martial records to the FBI's screening database when the offense doesn't lead to a dishonorable discharge because this has never been a priority for the military. According to a 2016 report by the U.S. Government Accountability Office (GAO), the FBI has struggled to collect domestic abuse records for background checks, in part because incomplete or no missing criminal histories make it harder to deter- mine if someone should be banned from obtaining a gun. The GAO focused on reporting by state and local authorities and reported that between 2006 and 2015 about 6,700 firearms were incorrectly trans- ferred to individuals with domestic violence records. Federal law requires federal departments, in- tome be cluding the military branches, to notify the Justice Department at least quarterly about any records they have showing that someone is disqualified from buy- ing a gun. At the state level, however, compliance is voluntary unless specified by state law or federal funding requirements. It isn't known how many court-martial records are submitted to the FBI, which said it couldn't provide the information. Gaps in databases have also affected other aspects of law enforcement, such as sentencing and parole. The decision to parole O.J. Simpson in October 2017 is an example. Before voting to release O.J. Simpson from prison after nine years, the Nevada parole board discussed in detail the robbery that had put him behind bars and his conduct as an inmate. Members of the Nevada Board of Parole Commissioners stated that before Simpson's 2008 conviction for a Las Vegas hotel robbery, Simpson had no history of a criminal conviction. Although Simpson was acquitted in 1995 of the murders of his former wife Nicole Brown Simpson and Ronald Goldman, in 1989 he had pleaded no contest in Los Angeles to misdemeanor battery of Ms. Simpson, who was then his wife. The Nevada parole board did not have that information. The 1989 conviction was not considered when a four-member panel voted unanimously to release him in October 2017.