6. Given the dependency diagram shown in Figure Q6.6, answer Items 6a-6c.

a. Identify and discuss each of the indicated dependencies.

b. Create a database whose tables are at least in 2NF, showing the dependency dia- grams for each table.

c. Create a database whose tables are at least in 3NF, showing the dependency dia- grams for each table.

1)On average, 20 percent of the emergency room patients at Bedford hospital lack health insurance. In a random sample of 8 patients what is the probability that 2 will be uninsured?

Read “Management in Action” “Blue Bell is Accused of 'Recall Creep' in Its Handling of Ice Cream Contamination” on pages 101 and 102 in your textbook.

Answer questions 2, 3, 4, 5, and 6 at the end of the reading. Write out each question and the follow with your responses.

Blue Bell Is Accused of “Recall Creep” in Its Handling of Ice Cream Contamination In March, the listeria problem grew. Listeria was linked to a chocolate ice cream cup made in Oklahoma. The company recalled the ice cream cups In April, Blue Bell then suspended all operations in Oklahoma after the CDC linked the bacteria in the chocolate cup with five more listeria cases as far back as 2010. The company vowed to find the source of the C Blue Bell is the nation's third largest ice cream maker, behind Nestlé, which produces Edy's, and Unilever PLC, which makes Ben & Jerry's. Blue Bell started its business in Brenhaman, Texas, in 1911. It grew to hav- ing manufacturing operations in Texas, Oklahoma, and Alabama, employing around 3,900 employees. The company's products have been sold in 23 states. Blue Bell faced a major listeria contamination prob- lem across all of its three major plants in 2015 The problem gained attention in 2015 when inspec- tors from South Carolina found Listeria monocyto- genes in two products that were made in Blue Bell's Brenham plant. The situation got worse once the Cen- ters for Disease Control (CDC) “matched the Blue Bell bug to listeria strains blamed for an unsolved 2014 outbreak at a Wichita hospital: Five patients, al- ready hospitalized with serious illnesses, had been in- fected; three died. Investigators later confirmed that four drank milkshakes with Blue Bell ice cream. Fur ther testing would link the company to 10 listeriosis cases dating back to 2010.”190 Blue Bell learned about the South Carolina findings in February 2015. The company responded by retriev- ing 10 different products produced on the factory line in question. It made no statement to consumers. About one month later the company learned about the Wichita deaths. This led to a decision of stopping production on the tainted production line. Ultimately, the line was shut down permanently. contamination, and it announced a recall of seven more flavors. In April, another link was found between listeria in containers of chocolate chip cookie dough ice cream that were produced in Brenham. This led CEO Paul Kruse to publicly apologize and recall all of its products-eight million gallons of ice cream. The company ended up laying off 37% of its 3,900 employ- ees while also furloughing 1,400 more. Employees interviewed by CBS contend that poor manufacturing practices problem. Two employees “described antiquated ma chinery run amuck, oil dripping into the food mix, and melted ice cream left pooling on the factory floor be- cause supervisors didn't want to slow production. Terry Schultz, an employee who worked on the con- potential causes of the were taminated line in Brenhan, told CBS “A lot of time, I walked in there, and there was just ice cream all over the floor. Sometimes these machines, they would just go haywire, and it would just, the product would just continually just drop right onto the floor.” This was bad because moisture provides a good environment for bacteria to run through the conveyor belt, and it would grow The contamination crisis and its effects on Blue Schultz said that he complained to a and was told “Is that all you're going to do is come in here and bitch every afternoon?” He concluded that “Production was probably more important than cleanliness.” supervisor Bell almost led to the company's demise. The com pany was saved by a loan of up to $125 million from Texas billionaire Sid Bass. The Bass family now owns one-third of the company In January 2016, a CNN report indicated that “en- hanced testing of its [Blue Bell] facilities has found locations where suspected listeria may be present. This is good news in that the new testing procedures are finding potential problem areas, which then en ables the company to clean and sanitize them. The company notes that “We have tested and will continue to test every batch of ice cream produced. No products produced have tested positive (for listeria). No prod- ucts are shipped to stores until tests confirm they are safe. We will continue to work closely with our regula tory agencies, as we have throughout this process.” As of January 2016, Blue Bell is shipping product to 15 states and plans to use a phased approach for shipping ice cream to its remaining markets. оre The second employee interviewed, Gerald Bland, told CBS that “he was instructed to pour ice cream and fruit juice dripping off the machine throughout the day into barrels of ice cream mix.” He also noted that “You'd see oil on top from the fruit feeder leaking that would still go right into the barrel.” This practice was discontinued about a year before the plant was shutdown.191 Although Blue Bell executives would not respond to CBS's request for an interview, the company told a Fortune reporter that “isolated views expressed by two former Blue Bell employees on CBS News do not re- flect the experience of the vast majority of our em ployees . . . Our top priority and commitment is to produce high quality, safe, delicious ice cream for our 195 customers 192 Consider this statement in light of an FDA inspec- tion report from 2015. The FDA reported finding bac- teria in Blue Bell's Oklahoma plant on 17 occasions beginning in March 2013. In spite of this finding, the FDA noted that Blue Bell did not follow up “to iden tify sanitation failures and possible food contamina tion,' taken proper steps to root out the problem, or informed the agency of its findings.”193 One reporter concluded that “Blue Bell failed to follow practices recommended by government and industry groups that might have prevented listeria contamination of ice cream at all three of its main FOR DISCUSSION 1. How did Blue Bell's response to the contamination at its plants impact the triple bottom line? 2. Which of Blue Bell's internal and external stake- holders were positively and negatively affected by the contamination crisis? Be specific. 3. Which of the six general environmental forces influ- enced the manner in which Blue Bell responded to this crisis? 4. To what extent did Blue Bell respond ethically to the contamination problem? Explain. plants.” In response to this, a company spokesperson said, “We thought our cleaning process took care of any problems, but in hindsight, it was not adequate.” He then stated that the company “would immedi- ately clean the surfaces and swab until the tests were negative.”194 5. To what extent was Blue Bell's approach toward the contamination problem consistent with the four approaches to deciding ethical dilemmas? Explain 6. Evaluate Blue Bell's approach to solving this crisis against Carroll's model of social responsibility shown in Figure 3.2 C

Task 1

Read and analyse the following specification of a sample database domain.

A transportation company would like to create a database to record some of its operations. The company owns and uses several busses to implement transportation services between the cities.

The company employs administration staff members, drivers and mechanics. A common description of an employee consists of a unique employee number, first name last name and date of birth. Additionally, drivers are described by a unique driving licence number and category of a driving licence. Mechanics are also described by a list of qualifications acquired in the past together with a date when each qualification has been acquired.

The company supports a number of transportation services. A service starts at a city, passes through a number of intermediate stops and ends in another or the same city. An origin location, a sequence of intermediate stops, and a destination location of a service are described by unique addresses. An address consists of city name, street name and building number. Each intermediate stop has a unique number in a sequence of intermediate stops within a transportation service.

Attachments:

DPIT115-Assig….docx