A survey was done to observe how students use transportation…

A survey was done to observe how students use transportation (if at all) to travel to and from campus. Since some people do not own cars, for the “How many days do you use your personal vehicle?” question, some students left that question blank. Now that you have access to that dataset of survey results, you encounter a lot of null values that make the dataset hard to work with. Which of these queries fills in those NULL values with non-null data?

We have done a giveaway to promote our new rewards program….

We have done a giveaway to promote our new rewards program. The giveaway was designed to give the postal code with the most activity Elite status while all other postal codes would begin as Standard. Postal code 33111 won our giveaway and we would like to now add the customer status attribute to the customers table. Which of the following queries will accomplish this goal? Note, we are assuming postal code is a character attribute.

Sam Stein (P) makes his weekly shopping trip to HEB (D).  He…

Sam Stein (P) makes his weekly shopping trip to HEB (D).  He gets a cart and heads toward the baking aisle so that he can get ingredients to make a cake for his wife’s birthday.  Unbeknownst to Sam, a few minutes earlier another customer accidentally knocked a glass jar off the shelf, spilling cooking oil all over the floor.  Sam does not see the puddle and slips, badly injuring his right leg.  A HEB employee comes to Sam’s aid and calls the paramedics.  Sam is taken to the emergency room, where the doctor correctly decides that Sam’s right leg must be amputated.  Because the emergency room is so busy, however, the doctor loses concentration and mistakenly amputates Sam’s left leg.  Sam loses both legs and must spend the rest of his life confined to a wheelchair. Sam hires a lawyer, who promptly files a lawsuit against HEB seeking millions in damages for Sam being wheelchair-bound.  HEB gets a copy of the complaint.  HEB’s lawyer files a motion to dismiss the lawsuit.  He tells the judge, “Your Honor, this is ridiculous.  Sam should have been more careful.  There is no evidence that any HEB employee knew about the cooking oil spill and so HEB cannot be liable.”  He goes on: “My client HEB also cannot be liable for Sam losing both of his legs!”  Is HEB’s lawyer correct?  Please analyze using the IRAC method.