For testing the effectiveness of SODIS the material that was used were a sola reflector,

Material and Method

For testing the effectiveness of SODIS the material that was used were a sola reflector, 9 clean 500ml PET water bottles, and Versoix River Water from La Batie. The method used to conduct eh experiment is as elaborated bellow.

First, the nine 500 ml PET water bottles were each filled with Versoix River water from La Batie. Each of the bottles was filled up to its ¾ marks and shake for twenty seconds. After the shaking, all the bottles were completely filled and sealed. Then one of the nine bottles was drawn and taken to the lab of for the initial E.Coil count of the raw water sample. The rest of the bottles were able with a number, and a number and a letter as follows; 1. 1F, 2, 2F, 3, 3F, 4, 4F. The numbers indicate the numbers of days the bottle were exposed to sunlight and heat. F stand for the foil, in which the bottles labelled F were wrapped to prevent exposure of its contents from sunlight, but only expose them to the heat. The bottles were drawn in correspondence with the labelled number of days, one at a time from the first day to the fourth day. After the first day of exposure, the bottles labelled 1 and 1F were drawn and taken to the lab for E.Coil analysis. This was repeated on the second day 2 and 2F, on the third day 3 and 3F and the fourth day for 4 and 4F. There were two control treatments. The first control treatment was the water in the first bottle with raw water that was not exposed to sunlight or heat and the second was water without exposure to sunlight but exposure to heat through the solar reflector. They offered a difference from the bottle that were exposed to both the suns UV-A and heat which had the condition necessary for SODIS to work

Results

Observation from the SODIS experiments

On the first day the experiment was conducted outside for 2h 13min (from 12:17pm to 2:30pm.) They sky was cloudy and with light snow furies. There was the sun albeit limited. From 1pm to 1:40 pm, the opening was covered with a cling wrap to prevent to inhibit snow from getting into the sola reflector. The cling wrap was removed after its interior surface steamed. This day had snow furies.

On the second day the experiment was conducted behind glass in a house, since it was snowy outside. It was conducted for 2h 12mins between 12:28pm and 4:40pm. On this day it was snowing and there was no direct sunlight.

On the third day the experiment was conducted behind glass, in a car. From 11am to 1pm, the sky was cloudy and the experiment did not face direct sunlight since the direction of the sun could not be determined. From 1pm to 1:30pm, the sun came out briefly and the experiment was adjusted to face direct sun. At 3:30 the experiment was stopped since it was raining heavily. The whether was cloudy, then sunny and then rainy.

On the fourth day, the experiment was conducted between 12:30 pm to 4: 30pm behind glass in the houses because it was lightly snowy outside. There was a lot of snow on the ground and although it was bright, there was no direct sunlight. The bottle had a brown/green sediment, which was denser than water, but did not adhere to the bottle. This day was snowy.

Lab results

Days   1 & 1F 2 & 2F 3 & 3F 4 & 4F

E.Coli Experiment UFC/100ml 202 95 96 18

Contrôle UFC/100ml 427 418 205 241

EMBED Excel.Chart.8 s

For the corporation that has acquired another company, merged with another company

For the corporation that has acquired another company, merged with another company, or been acquired by another company, evaluate the strategy that led to the merger or acquisition to determine whether or not this merger or acquisition was a wise choice. Justify your opinion.

Procter and Gamble is an international corporation that produces detergents, soaps and beauty cosmetics. Recently, the corporation merged with Gillette a leading firm in producing men shaving products. By Procter and Gamble merging with other beauty and cosmetics corporations such as Gillette, it has assisted it in improving the corporation performance by putting the top managers into pressure of improving the governance of the corporation. By merging, the corporation may increase their stock selling. Through these merges, usage of men and women beauty cosmetics have intensely increased in many countries worldwide and have enabled more men to value the necessity of making themselves look attractive. On the other hand, Procter and Gamble merged with this other corporation so that it may correct the problems that arise in the cosmetics industry. Gillette provided good and quality shavers to be used by men efficiently (Isidore, 2005).

This merging shows the importance of the worldwide segment of the external environs with which Procter and Gamble and the merged firms have to put into considerations when dealing with scarce reserves (Isidore, 2005). Additionally, merging has enabled Procter and Gamble to acquire more information on its competitors, stakeholders and customers. This enables the corporation in building their own base of capabilities and knowledge. The reason that led to this merging was the fact that Procter and Gamble was good in innovating products and knew how to nurture various brands.

On the other hand, Gillette was good in technology and had the ability in rolling out new products often. For Procter and Gamble to maximize its profit, it needs to employ a lot of business and corporate level strategies. This will depend mostly on the countries the company is dealing with, the consumers being sold the products and the type of industry Procter and Gamble is working in (Isidore, 2005).

First of all, Procter and Gamble will have to focus on the first world countries in order to sell their products. Then, it will have to focus on the third world countries which will manufacture these products for them. This will enable Procter and Gamble to capitalize on its profits by reducing the inputs costs of a commodity (Isidore, 2005). This strategy is implemented when the company gets cheap commodities and services from a poor country then sells the finished commodity to a wealthier country. Procter and Gamble will alter its image depending on the values and demands of its customers. For instance, as this company serves its markets by producing detergents and beauty cosmetics, it will need to put more consumer tastes on their commodities e.g. smell and color on the commodities. This is just one of the ways of appealing its customers.

For the corporation that has not been involved in any mergers or acquisitions, identify one (1) company that would be a profitable candidate for the corporation to acquire or merge with and explain why this company would be a profitable target.

United Refining Company is locally based in the United States. British petroleum (BP) would be the suitable company in merging with the latter company. The strategic actions that United Refining Oil Company would take relative to the disaster that occurred in the Gulf of Mexico by BP and to the future of the success of this corporation are to be influenced by the pressure the corporation is getting from its external environment. A main challenge that the corporation’s strategic leader is supposed to understand is the effects of the external environment on the corporation. On the other hand, the strategic leader is supposed to forecast how its forthcoming strategic plans and actions may lead the corporation to success.

In the future, United Refining Oil Company and the additional oil and gas firms focusing on extracting fuels, have to expect regulatory changes in the legal or political segments of the environment generally. A report issued on the disaster showed that the practices conducted by the oil companies need to improve intensely. Since the disaster happened, the government agencies in charge of inspecting drilling platforms are supposed to intensify the drilling permits to the oil and gas corporations. United Refining Oil Company has tried in rectifying the Gulf of Mexico problems by forming extra joint ventures in the worldwide arena.

It has proposed ventures with Rosneft Corporation, British petroleum (BP) and a certain Russian corporation so that it may improve its performances. Incase the deal with Rosneft corporation goes through; National Iranian Oil Company would assist Rosneft and British petroleum (BP) in exploring opportunities in the arctic region. Rosneft Corporation maintained on a shared swap giving them a five percent stake in British Petroleum (BP). Additionally, British petroleum (BP) together with an Indian partner Reliance industry formed a 7.2 billion dollars investment.

It gave the corporation a thirty percent stake in the field of oil and gas off the east coast. These deals show how British petroleum (BP) together with United Refining Oil Company will improve in the future the necessity of the global segments. The oil and gas reserves in Russia are ten years away from producing. British petroleum (BP) needs together with United Refining Oil Company needs to source energy worldwide.

By doing so, it needs to transport the product, refine it and then distribute it over and done with global partnerships. These global partnerships may be internal and external to United Refining Oil Company. In ensuring for any success in a corporation, assessing the external environment influences is important. This assists energy corporations mostly.

This is because these energy corporations are part of the worldwide incorporated process of energy extraction, refining into different products and distributing the products worldwide. British petroleum tactical actions are mainly affected by the conditions that arise in the other segments of the corporation’s general environment. These segments may be political, physical and social environment.

3. For the corporation that operates internationally, briefly evaluate its international business-level strategy and international corporate-level strategy and make recommendations for improvement.

Procter and Gamble is an internationally recognized corporation worldwide for the steady consumer brands it has. The corporation is organized into two international business units. These are the household care unit and the beauty and grooming unit. Additionally, the firm has a lot of products that are produced in different parts of the world. Some of these products are Ivory, Herbal Essences, Cover Girl, Crest, Bounce and Bold.

Twenty four of the Procter and Gamble corporation product lines produce nearly 1billion dollars in their yearly sales. Estimates done reveal that nearly everyone in the world spends 12 dollars yearly in buying Procter and Gamble products. The new chief executive officer of Procter and Gamble Corporation wants to make this yearly average expenditure to 14 dollars a person before 2015 (Bryon, 2011).

Additionally, the chief executive officer wants the firm’s annual report sales revenues to rise up to 100 billion dollars from today’s roughly 80 billion dollar mark, and for the number of Procter and Gamble customers to increase 5 billion dollars from the current 4.2 billion. The corporation has implemented various strategies in meeting these objectives. According to the corporation officials and analysts, these objectives issued are to be reached through plans that are now in place to move quickly and broadly into developing countries such as China and India. Furthermore, the objectives are to produce products that will be appealing to new but lower income customers.

Efforts will simultaneously continue to satisfy the needs of Procter and Gamble’s huge stable of its current customers. These intended actions appear to support the view that Procter and Gamble likes to use its capabilities and competencies to grow organically rather than through mergers and acquisitions or through cooperative relationships. In the words of the previous Procter and Gamble CEO, he asserted that organic growth in a corporation is more vital as it is developed from the corporation’s competencies.

He went on to state that organic growth exercises the innovation muscles of the corporation (Bryon, 2011). Moreover, he said that if the corporation implemented organic growth, it would become stronger in the market. Cutting edge technology, supply chain management skills, advertising expertise and marketing research and development skills in regards to fat and oils, a broad portfolio and emulsifiers are a few of Procter and Gambler’s highly regarded competencies. All of these competencies, which are as result of the combination of the firms tangible and intangible resources allow Procter and Gamble to perform the tasks that must be completed to produce, sell, distribute and service its branded goods.

By the corporation implementing these strategies, it is a step further as it discovers that these competencies contribute to the firm’s five core competencies or fundamental strengths. For instance, R&D capabilities are foundational to Procter and Gamble’s innovation which is the core competence. Similarly, Procter and Gamble marketing and advertising skills contribute to its brand building core competencies and customer understanding. The supply chain management capability is critical to the go-market core competence.

This competency allows Procter and Gamble to be efficient in its productions and retain its customers as a result. Thus, some of the Procter and Gamble’s competencies are seen how they are joined to the competencies of other corporations. From an operational perspective, these core competencies are activities Procter and Gamble carries out especially well relative to competitors and through which the firm is able to create unique value for its customers (Bryon, 2011).

4. For the corporation that does not operate internationally, propose one business-level strategy and one corporate-level strategy that you would suggest the corporation consider. Justify your proposals.

The corporation’s external environment factors lead to the threats and opportunities of a corporation. For instance, the opportunities United Refining Oil Company gets when it enters the worldwide markets and the possibilities of the additional regulations in the market, British petroleum (BP) conducts reducing opportunities in extracting oil and gas. Cooperatively, threats and opportunities affect the strategic actions of a corporation. The external environment influences the corporation when they are seeking for the above average returns in revenue and strategic competitiveness.

How this oil corporation presents global economy is different from the historical conditions. For instance, changes in technology increased the corporation need in developing competitive actions that are competitive. British petroleum (BP) would assist United Refinery Oil Company in its growth. This is because British petroleum Company is a multinational company well recognized and carries out different oil drilling practices. Moreover, British petroleum (BP) has well trained employees with a lot of expertise in the oil, coal extraction field.

A business level strategy to be considered by this corporation is to be determined by the people the corporation will serve and the needs needed to be satisfied by the customers. One of the business strategies to be implemented is strengthening the relationships of the customers by presenting to them superior values. The customers are supposed to be assisted in developing new competitive advantages. On the other hand, the corporation should enhance the values of the competitive advantage that are in existence. In addition, the company needs to implement actions that are mainly designed in producing or the goods and services by using the lowest costs available (Ford & Ford, 2010).

These costs must be relative to the corporation’s competitors, having acceptable features to the customers. This is by issuing good features that customers will accept, put a low competitive price in their products and standardize the products they offer. In order for the corporation to fulfill this strategy, it needs to minimize its costs of sale, build manufacturing facilities that are efficient, control production costs tightly and observe the costs of activities delivered by the outsiders.

Additionally, a corporate level strategy required by this corporation is product advertisement (Ford & Ford, 2010). This will assist the corporation in convincing their customers and new entrants that the products they offer are distinctive. By a customer valuing the uniqueness of a product, he or she tends to be loyal to the corporation and the product itself. Advertisements help the corporation at large by extending their reach to great number of people. Additionally, the United Refinery Oil Company should look for acquisitions and mergers.

This will be effective for the company’s growth at the corporate level. In order to increase its market share, this company can merge with other bigger recognized companies. For this merging to be profitable to the United Refinery Oil Company, it needs to control all the costs such as training of new employees and streamlining procedures costs. On the other hand, the company grows after merging with other firms of the same industry.

References

Ford, J. D. & Ford, L.W. (2010). Stop blaming resistance to change and start using it, Organizational Dynamics, 39:24–36.

Bryon, E. (2011). At P&G beauty makeover needs to prove it has legs, Wall Street Journal, January 26, B1.

Isidore, C. (2005). P&G to buy Gillette for $57B. Stock merger would link some of the world’s best-known household brands, could spur more deals. Retrieved 19 Feb. 2013 from http://money.cnn.com/2005/01/28/news/fortune500/pg_gillette/index.htm

For the data given we need to create two tables as follows

Name

Lecturer

Course

Date

Exercise 8:

For the data given we need to create two tables as follows:

Employees Table

CREATE TABLE IF NOT EXISTS `employee_t` ( `Employee_ID` int(2) NOT NULL AUTO_INCREMENT, `Employee_Name` varchar(9) DEFAULT NULL, `Employee_Level` varchar(10) DEFAULT NULL, `Employee_Department` varchar(25) DEFAULT NULL, `Reports_to` varchar(8) DEFAULT NULL, PRIMARY KEY (`Employee_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

Explanation

Here we used the SQL DDL Command “CREATE”, which is referred to us create table construct in proper SQL language, in order to create the table ‘employee_t’ to represent employees with the five columns as shown above. We use the first column ‘Employee_ID’ as our primary key so that it can be joined with the second table below.

Dependents Table

CREATE TABLE IF NOT EXISTS `dependents_t` ( `Employee_ID` int(2) NOT NULL, `Dependents` varchar(10) DEFAULT NULL, `Dependent_Type` varchar(8) DEFAULT NULL, KEY `Employee_ID` (`Employee_ID`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Explanation

First I executed the above MYSQL DDL command of ‘CREATE’ to create the dependents table with three headings namely; ” Employee_ID, Dependents and Dependent Type. In order to link the ‘dependents_t” table with the employees table I used the MYSQL DDL COMMAND ‘ALTER’ as follows:

ALTER TABLE `dependents_t`

ADD CONSTRAINT FOREIGN KEY (`Employee_ID`)

REFERENCES employee_t(`Employee_ID`)

This creates a constraint under the Employee_ID column and makes it the foreign key in our table.

Exercise 9:

1st Part:

The Course Project Data Table 1 is NOT 1st normal form. 1st normal form (1NF) is used as a property for a relation in a relational database like Access or MYSQL. The relation is considered to be in 1NF if each attribute’s domain contains atomic values only, and each attribute’s value contains only one value from the said domain. From our data table we find out that some employees have more than one dependent thus the need to add more rows for the said employees in our table.

This can be changed into 1st normal from by creating two tables as shown in exercise 8 above. The first table will capture the first 5 columns of our information and use Employee_ID as the primary key as this is used to uniquely identify each employee. The second table will have the last two column information and to join it with the first table we use the Employee_ID column as the FOREIGN KEY.

The date above in the 1st Normal Form is NOT WELL STRUCTURED. This is because in our table we have several repeated values under the following table headings “Employee_Level”, “Employee_Department” and “Reports_to”. To keep the data “well structured” we need further normalize the tables by creating a further three tables to represent each of the columns above and represent their unique attributes with numerical digits e.g. for Employee_Level we can have the following representation: Employee to be represented by 1 and Supervisor by2, thus replacing all table data with just numerical digits.

Lastly, for a “well structured” table a single table must show one subject at a particular time and have distinct fields that can accommodate the data at its absolute minim, to do this we use fields having unique values. Advantages of “well structured” tables:1. It has the capability to support both planned and unplanned retrieval of information. 2. It should be scalable and cater for future expansion of the database. 3. Saves the time in future redesign and re organization of the data.

2nd Part:

The SQL code for the Tables is as follows:

Employee Table.

— Database: `employee_db`

— Table structure for table `employee_t`

CREATE TABLE IF NOT EXISTS `employee_t` ( `Employee_ID` int(2) NOT NULL AUTO_INCREMENT, `Employee_Name` varchar(9) DEFAULT NULL, `Employee_Level` varchar(10) DEFAULT NULL, `Employee_Department` varchar(25) DEFAULT NULL, `Reports_to` varchar(8) DEFAULT NULL, PRIMARY KEY (`Employee_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

— Dumping data for table `employee_t`

INSERT INTO `employee_t` (`Employee_ID`, `Employee_Name`, `Employee_Level`, `Employee_Department`, `Reports_to`) VALUES (1, ‘John’, ‘Employee’, ‘Sales’, ‘Sally’), (2, ‘Jason’, ‘Employee’, ‘Manufacturing’, ‘George’), (3, ‘George’, ‘Supervisor’, ‘Manufacturing’, ‘Basil’), (4, ‘Sally’, ‘Supervisor’, ‘Sales’, ‘Basil’), (5, ‘Jennifer’, ‘Manager’, ‘Management’, NULL), (6, ‘Basil’, ‘Manager’, ‘Management’, NULL), (7, ‘Chris’, ‘Employee’, ‘Sales’, ‘Sally’), (8, ‘David’, ‘Employee’, ‘Sales’, ‘Sally’), (9, ‘Hana’, ‘Manager’, ‘Management’, NULL), (10, ‘Lana’, ‘Employee’, ‘Sales’, ‘Sally’), (11, ‘Robert’, ‘Employee’, ‘Manufacturing’, ‘George’), (12, ‘Charles’, ‘Employee’, ‘Manufacturing’, ‘George’), (13, ‘Rebecca’, ‘Employee’, ‘Sales’, ‘Sally’), (14, ‘Abi’, ‘Employee’, ‘Sales’, ‘Sally’), (15, ‘Abdul’, ‘Employee’, ‘Finance and Accounting’, ‘Lucas’), (16, ‘Cyrus’, ‘Employee’, ‘Manufacturing’, ‘George’), (17, ‘Harvey’, ‘Employee’, ‘Finance and Accounting’, ‘Lucas’), (18, ‘Lucas’, ‘Supervisor’, ‘Finance and Accounting’, ‘Jennifer’), (19, ‘Marco’, ‘Employee’, ‘Manufacturing’, ‘George’), (20, ‘Andrew’, ‘Employee’, ‘Finance and Accounting’, ‘Lucas’), (21, ‘Isabella’, ‘Employee’, ‘Finance and Accounting’, ‘Lucas’), (22, ‘Ian’, ‘Employee’, ‘Sales’, ‘Sally’), (23, ‘Claire’, ‘Supervisor’, ‘Logistics and Warehousing’, ‘Jennifer’), (24, ‘Anthony’, ‘Employee’, ‘Finance and Accounting’, ‘Lucas’), (25, ‘Alice’, ‘Employee’, ‘Logistics and Warehousing’, ‘Claire’), (26, ‘Rhonda’, ‘Employee’, ‘Logistics and Warehousing’, ‘Claire’), (27, ‘Darryl’, ‘Employee’, ‘Manufacturing’, ‘George’), (28, ‘Daniel’, ‘Employee’, ‘Sales’, ‘Sally’), (29, ‘Ryan’, ‘Employee’, ‘Logistics and Warehousing’, ‘Claire’), (30, ‘Sabrina’, ‘Employee’, ‘Manufacturing’, ‘George’), (31, ‘Harry’, ‘Employee’, ‘Logistics and Warehousing’, ‘Claire’), (32, ‘Henry’, ‘Employee’, ‘Logistics and Warehousing’, ‘Claire’), (33, ‘Alexandra’, ‘Employee’, ‘Finance and Accounting’, ‘Lucas’), (34, ‘Aziz’, ‘Employee’, ‘Logistics and Warehousing’, ‘Claire’);

Dependents Table

— Table structure for table `dependents_t`

CREATE TABLE IF NOT EXISTS `dependents_t` ( `Employee_ID` int(2) NOT NULL,`Dependents` varchar(10) DEFAULT NULL,`Dependent_Type` varchar(8) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `dependents_t` (`Employee_ID`, `Dependents`, `Dependent_Type`) VALUES (1, ‘Mary’, ‘Spouse’), (1, ‘Jane’, ‘Daughter’), (2, NULL, NULL), (3, ‘Dorothy’, ‘Spouse’), (3, ‘Michael’, ‘Son’), (3, ‘Sarah’, ‘Daughter’), (4, ‘Hector’, ‘Spouse’), (4, ‘Isabel’, ‘Daughter’), (4, ‘Manuel’, ‘Son’), (5, ‘John’, ‘Spouse’), (6, NULL, NULL), (7, NULL, NULL), (8, ‘Christine’, ‘Spouse’), (8, ‘Joanne’, ‘Daughter’), (8, ‘Jill’, ‘Daughter’), (9, ‘Salah’, ‘Spouse’), (10, ‘Demetrius’, ‘Spouse’), (10, ‘Derrick’, ‘Son’), (10, ‘Danielle’, ‘Daughter’), (11, ‘Lynda’, ‘Spouse’), (11, ‘Jacqueline’, ‘Daughter’), (11, ‘Claudia’, ‘Daughter’),(11, ‘Alice’, ‘Daughter’), (11, ‘James’, ‘Son’), (12, ‘Alison’, ‘Spouse’), (12, ‘George’, ‘Son’), (13, ‘Mark’, ‘Spouse’), (14, ‘Malcolm’, ‘Spouse’), (15, ‘Falak’, ‘Spouse’), (15, ‘Hana’, ‘Daughter’), (16, ‘Rosemary’, ‘Spouse’), (17, NULL, NULL), (18, ‘Mabel’, ‘Spouse’), (18, ‘George’, ‘Son’), (18, ‘Michael’, ‘Son’), (19, ‘Alicia’, ‘Spouse’), (19, ‘David’, ‘Son’), (19, ‘Andrew’, ‘Son’), (19, ‘Russell’, ‘Son’), (20, ‘Anne’, ‘Spouse’), (21, ‘Charles’, ‘Spouse’), (21, ‘Lydia’, ‘Daughter’), (22, ‘Blaine’, ‘Spoues’), (22, ‘Sean’, ‘Son’), (22, ‘Conor’, ‘Son’), (23, ‘Russell’, ‘Spouse’), (24, ‘Jane’, ‘Spouse’), (24, ‘Maria’, ‘Daughter’), (24, ‘Teresa’, ‘Daughter’), (24, ‘Mario’, ‘Son’), (24, ‘Michele’, ‘Daughter’), (25, ‘Carlo’, ‘Spouse’), (25, ‘Angelo’, ‘Son’), (25, ‘Sergio’, ‘Son’), (26, ‘Hiroto’, ‘Spouse’), (26, ‘Miu’, ‘Daughter’), (27, ‘Sofia’, ‘Spouse’), (27, ‘Paula’, ‘Daughter’), (27, ‘Nicole’, ‘Daughter’), (27, ‘Maria’, ‘Daughter’), (27, ‘Emilio’, ‘Son’), (27, ‘Miranda’, ‘Daughter’), (28, NULL, NULL), (29, NULL, NULL), (30, ‘Alan’, ‘Spouse’), (30, ‘Matthew’, ‘Son’), (31, ‘Laura’, ‘Spouse’), (31, ‘Alex’, ‘Son’), (32, ‘Olivia’, ‘Spouse’), (33, ‘Howard’, ‘Spouse’), (34, ‘Karam’, ‘Spouse’), (34, ‘Maram’, ‘Daughter’), (34, ‘Basil’, ‘Son’);

Exercise 9:

The SQL Query to list managers’ names and then who reports to each manager is as follows:

SELECT Employee_name AS Employee, Reports_to AS Manager FROM employee_t

WHERE Reports_to=’Jennifer’OR Reports_to=’Basil’ OR Reports_to=’Hana’ order by Reports_to

The following table is an extract of how the report looks like:

HYPERLINK “http://127.0.0.1/phpmyadmin/sql.php?db=employee_db&table=employee_t&sql_query=SELECT+Employee_name+AS+Employee%2C+Reports_to+AS+Manager+FROM+employee_t%0AWHERE+Reports_to%3D%27Jennifer%27OR+Reports_to%3D%27Basil%27+OR+Reports_to%3D%27Hana%27+ORDER+BY+%60employee_t%60.%60Employee%60+ASC&token=40d847311dfb6227a36350aa27ca2a3d” o “Sort”Employee HYPERLINK “http://127.0.0.1/phpmyadmin/sql.php?db=employee_db&table=employee_t&sql_query=SELECT+Employee_name+AS+Employee%2C+Reports_to+AS+Manager+FROM+employee_t%0AWHERE+Reports_to%3D%27Jennifer%27OR+Reports_to%3D%27Basil%27+OR+Reports_to%3D%27Hana%27+ORDER+BY+%60employee_t%60.%60Manager%60+ASC&token=40d847311dfb6227a36350aa27ca2a3d” o “Sort”Manager

George Basil

Sally Basil

Lucas Jennifer

Claire Jennifer

The SQL script to show the supervisors’ names followed by who reports to each supervisor is shown below:

SELECT Employee_name AS Employee, Reports_to AS Supervisor FROM employee_t

WHERE Reports_to=’George’OR Reports_to=’Sally’ OR Reports_to=’Lucas’ OR Reports_to=’Claire’ order by Reports_to;

The following data will be extracted.

Employee_Name Reports_to

Alice Claire

Rhonda Claire

Ryan Claire

Harry Claire

Henry Claire

Aziz Claire

Jason George

Robert George

Charles George

Cyrus George

Marco George

Darryl George

Sabrina George

Abdul Lucas

Harvey Lucas

Andrew Lucas

Isabella Lucas

Anthony Lucas

Alexandra Lucas

John Sally

Chris Sally

David Sally

Lana Sally

Rebecca Sally

Abi Sally

Ian Sally

Daniel Sally

Exercise 11:

SELECT O.Order_ID, Customer_name, O.Order_Date,

O.Quantity, Sum([unit_Price]*[Quantity]) AS [Order Cost] , O.Mode_Payment

FROM Customer_t  C, Order_line_t OL, Order_t  O, Product_t P

WHERE O.Order_ID = 26

AND O.Order_ID = OL.Order_I

AND P.Product_ID = OL.Product_ID

GROUP BY O.Order_Date, C.Customer_name, O.Order_ID ;

This will give us the following view for Order Number 26 with two lines of items.

The result is as follows:

Order_ID Customer_name Order_Date Quantity Order Cost Mode_Payment

26 Battle Creek Furniture 10/30/1998 7 $1,875.00 check

26 California Classics 10/21/1998 3 $2,000.00 cash

Exercise 12:

It will be better to use a view and the following are some of the benefits of using a database View:

1. Views Hide Complexity

For queries that require joining several tables, or that have complex calculations/logic, it’s possible to code that logic to a view, and select your options from the view like you would do for a table.

2. Security Mechanism

A view can be used to select certain rows and/or columns from a table, and permissions can then be set on the developed view instead of the tables themselves. This allows a user to surface only the data that he needs to see.

3. Views Do Simplify the Supporting Legacy Code

You can replace a table with a view with the same name, when you need to refactor a table needs a lot of code. The view will provide exactly the same schema like the original table, but instead the actual schema would already have changed. This prevents the legacy code referencing the table from breaking, allowing for changing the legacy code the users will.

The SQL View for Our Query is as Follows

SELECT O.Order_ID, Customer_name, O.Order_Date,  Sum([Order_Quantity]*[Product_Price]) AS [Order Cost], Sum([Ordered Product].Order_Quantity) AS Total_Order_Quantity, Product.Product_Line_Name

Customer_t  C, Order_line_t OL, Order_t  O, Product_t P

WHERE O.Order_ID = 26

AND O.Order_ID = OL.Order_I

AND P.Product_ID = OL.Product_ID GROUP BY O.Order_Date, C.Customer_name, O.Order_ID ;

For Widows

For Widows, Life After Loss

In some cultures, the death of a husband has meant exile, vulnerability, and abuse. But bereaved women are beginning to fight back.  

By Cynthia Gorney

Photographs by Amy Toensing

Video by Amy Toensing and Kathryn Carlson

By Cynthia Gorney

Photographs by Amy Toensing

Video by Amy Toensing and Kathryn Carlson

This story appears in the HYPERLINK “http://www.nationalgeographic.com/magazine/2017/02/” February 2017 issue of National Geographic magazine. The Pulitzer Center on Crisis Reporting provided a grant to support this story. View its related HYPERLINK “http://pulitzercenter.org/builder/lesson/20653?referer=community” lesson plan here.

1. RETURNING TO LIFE, Vrindavan, India

Long before sunrise the widows of Vrindavan hurried along dark, unpaved alleys, trying to sidestep mud puddles and fresh cow dung. There’s a certain broken sidewalk on which volunteers set out a big propane burner every morning and brew a bathtub-size vat of tea. The widows know they must arrive very early, taking their place on rag mats, lifting their sari hems from the dirt, resting elbows on their knees as they wait. If they come too late, the tea might be gone. Or the puffed rice might be running out at the next charity’s spot, many alleys away. “I can’t rush in the morning—I’m not well,” a widow complained. “But we have to rush. You don’t know what you will miss.”

It was 5:30 a.m., a cool dawn, a sliver moon. A few widows had wrapped themselves in colorful saris, but most wore white, in India the surest signifier of a woman whose husband has died, perhaps recently, perhaps decades ago. In the dim light they moved like schools of fish, still hurrying together, pouring around street corners, a dozen here, two dozen there.

No one has reliably counted the number of widows in Vrindavan. Some reports estimate two or three thousand, others 10,000 or more; the city and its neighboring towns are a spiritual center, crowded with temples to the Hindu god Krishna and ashrams in which bhajans—devotional songs—are chanted all day long by impoverished widows who crowd side by side on the floor. The sanctity of bhajan ashrams is sustained by steady chanting, and although this is nominally the role of pilgrims and priests, the widows earn hot meals, and perhaps nighttime sleeping mats, by singing these chants over and over, sometimes three or four hours at a time.

They live in shelters too, and in shared rental rooms, and under roadside tarps when no indoor accommodation will admit them. Vrindavan is about 100 miles south of Delhi, but the widows come here from all over India, particularly the state of West Bengal, where allegiance to Krishna is intense. Sometimes they arrive accompanied by gurus they trust. Sometimes their relatives bring them, depositing the family widow in an ashram or on a street corner and driving away.

Even relatives who don’t literally drive a widow from the family home can make it plain every day that her role among them has ended—that a widow in India, forever burdened by the misfortune of having outlived her husband, is “physically alive but socially dead,” in the words of Delhi psychologist Vasantha Patri, who has written about the plight of India’s widows. So, because Vrindavan is known as a “city of widows,” a possible source of hot meals and companionship and purpose, they also come alone, on buses or trains, as they have for generations. “None of us wants to go back to our families,” a spidery woman named Kanaklata Adhikari declared in firm Bengali from her bed in the shelter room she shares with seven other widows. “We never talk to our families. We are our family.”

She sat cross-legged atop the bedsheet, even though her limbs were contorted by age and disease and she was able to walk only by bending over almost double and shuffling. Her white sari was draped loosely over the top of her head; in India the shearing of a new widow’s hair was once common practice, to announce the end of her womanly appeal, and the widow Adhikari appeared to have been recently reshorn. “I keep it this way because my hair was his,” she said, and squinted at her guests, the foreigner and the young interpreter, as though perplexed by the question. “A barber comes and cuts it for me. A woman’s greatest beauty is in her hair and her clothes. Once my husband was not there, what would I do with it?”

How old was she now? “Ninety-six.”

And how old when her husband died?

“Seventeen.”

I was in Vrindavan because photographer Amy Toensing and I were visiting extraordinary communities of widows, over the course of a year, in three very different parts of the world. It was not private grieving we set out to explore, but rather the way societies can force a jarring new identity on a woman whose husband has died: pariah, exile, nuisance, martyr, prey.

When the United Nations in 2011 designated June 23 as International Widows’ Day, the official explanation was a somber one: that in many cultures widows are so vulnerable—to abusive traditions, to poverty, to the aftermath of the wars that killed their husbands—that widowhood itself must be regarded as a potential human rights calamity. The women Toensing and I met, like the caseworkers and volunteers trying to help them, became our teachers in the minutiae of special cruelties. In Bosnia and Herzegovina we spent a month with one of history’s singular concentrations of war widows, women who have spent two decades searching for and burying the scattered remains of more than 7,000 slaughtered men. In Uganda we learned the phrase “widow inheritance,” which for Ugandans does not mean the estate a widow receives; it means that the in-laws illegally seizing all her inherited property assume they are inheriting her too, as sex partner or wife for whichever relative they choose.

And in Vrindavan, listening to a social worker named Laxmi Gautam describe with fury the widows she has found begging because their families sent them away, we asked whether Gautam had ever imagined what she would change if she were given the power to protect women from these kinds of indignities. As it turned out, she had. “I would remove the word ‘widow’ from the dictionary,” she said. “As soon as a woman’s husband is gone, she gets this name. This word. And when it attaches, her life’s troubles start.”

The charitable organization of an Indian-born British business magnate, Raj Loomba, prodded the UN into sanctioning an annual widows’ day. Isolation and invisibility make it hard even to figure out how many widows there are in the world; the most ambitious data gathering has come from the Loomba Foundation, which provides widows support internationally and recently estimated the total number at around 259 million, with caveats about how poorly many countries track their own widows’ presence and needs. The June 23 date was Loomba’s idea too. This was the day his father died in India, Loomba has written, and although more than 60 years have passed since then, the kinds of stories he tells about what happened next—his widowed mother shunned as “inauspicious” at celebratory events, marked for life as an omen of bad fortune—were repeated every day by Vrindavan women Toensing and I met.

A widow must not dress in colors or make herself pretty, because that would be inappropriate to her new role as eternally diminished mourner. A widow must eat only bland food, in small portions, because richness and spice would stir passions she should never again experience. These are fading Hindu rules, largely dismissed by educated Indians as relics of another century, but they are still taken seriously in some villages and conservative families. Meera Khanna, a Delhi writer who works for a widows’ advocacy organization called Guild for Service, observes that the stigmatizing of widows comes not from the Vedas, the Hindu scriptures, but from generations of repressive tradition.

“In the Vedas nowhere is it ever said the widow has to live a life of austerity,” she told me. “There’s a line that says: You, woman. Why are you crying for the man who’s no more? Get up, take the hand of a living man, and start life anew.”

We planned our visits to Vrindavan, and Varanasi, a city northwest of Kolkata that also draws thousands of widows, to coincide with a simple campaign: making it possible, during celebratory festivals, for widowed women to join in. This is more subversive than it might seem. All over India the holidays of Diwali and Holi are occasions of public joy and merriment. Diwali includes gifts, bright lights, and fireworks; Holi is carried into the streets so people can “play Holi,” as Indians say, flinging brilliant powders and water at each other.

For a woman expected to live out her remaining years in muffled dignity, nothing about this kind of exuberance used to be consideredacceptable. “Once you become widowed, they say you are not allowed to do any festivals,” a charity worker named Vinita Verma told me. “But we want these ladies to be a part of society. They have a full right to live their lives.”

Verma is vice president of Sulabh International, an Indian organization that provides support services and small monthly stipends to widows in shelters in Vrindavan and Varanasi. A few years ago—tentatively at first and then on a bolder scale—Sulabh began arranging Diwali and Holi events for widows in the two cities. Even in private, indoors, some of the women needed time to learn to relax among holiday flowers and Holi powders, Verma said. “They felt, ‘If I touch this red color, some bad thing will happen to me.’ ”

But by 2015 the holiday festivities in the “cities of widows,” as Vrindavan and Varanasi are sometimes labeled in the media, were moving purposefully outdoors. No denunciations appeared in the Indian media, and when Toensing and I were in India, the only complaint we heard about plans for the widows’ festivities was that they made for photogenic show with little substance—that what the widows really need are more comfortable lodgings, meals they don’t have to sing for, families that will take them home, communities that won’t label widowed women useless and inauspicious.

“The real change has to come from the societies that produced them,” said Gautam, the social worker who would like to strike “widow” from the dictionary. Gautam’s home usually houses a few widows unable to find lodging, and when I asked what labels might suit these women better, it was obvious she’d considered this before too. “Mother,” she said. “If she’s not a mother, she’s a daughter, perhaps a sister. She’s also a wife. It’s just that her husband is not alive.”

It seems important to remember too: The Vrindavan widows can be fierce. It takes stamina to chant for three hours without break, to squat on a hard temple floor, to bustle through unlit muddy streets in search of the next meal and hot tea. When I arrived, in November 2015, Diwali was about to begin, and one afternoon I followed Verma as she prepared for the Sulabh events, which would include a boisterous outdoor procession, fireworks on the river, and a thousand new saris for the widows to wear and keep as their own—in any colors they might fancy. The saris were a gift from Sulabh, and a Vrindavan store had them stacked on display; widows in the charity’s stipend program were to arrive in groups over the course of a few hours, examining and choosing as skillful Indian sari-shoppers do.

Inside the sari store my interpreter and I watched the first widows push their way toward the stack, study the saris, and summon the shopkeeper. “I like those on that other rack better,” a woman said. “Can’t we choose from those?”

No, the shopkeeper explained, those were for sale. “Humph,” a widow said. She fingered the cloth of a charity sari. “Not especially good quality,” another widow said. “Could you please move over?” another widow said, and the widow she was elbowing said, Why should she—there was already enough space, and another widow said the breath of the widow beside her smelled foul, that she smoked too many bidis, the strong Indian cigarettes tied together with string. It took longer than expected to get everybody attended to, and I watched one quartet of widows walk out without new saris, harrumphing to each other. “As if our time had no value,” one said.

The Diwali procession and riverside fireworks would prove very grand, full of singing and sparklers and saris both white and colored—astonishing colors, to an outsider’s eye: sapphire, scarlet, lime, magenta, saffron. Many Indian news photographers came. Smoke swirled, fireworks lit the river pink, floating oil lamps made glowing circles in the moving water, and in spite of this my sharpest Vrindavan memory is of those four dignified widows disdaining their gift saris and marching out the door. They stayed close to each other, wrapped in widow white, chuckling, and when they stepped off the sidewalk together to cross the busy street, the traffic stopped to let them pass.

2. BURYING THE PAST, Tuzla, Bosnia and Herzegovina

When the first call came from the forensic identification center, Mirsada Uzunović was home with her 13-year-old son and so willed herself to stay calm. The voice on the other end was gentle. Remains of Uzunović’s husband, Ekrem, had been identified by laboratory testing, the voice said. The remains were … small. A partial skull. Nothing else. If Uzunović wished a burial, in the new memorial cemetery, that could be arranged.

No.

For three months she told no one. “In the nighttime, that was the difficult part. I was alone with my thoughts. From the big man I knew, only a piece of skull. I couldn’t imagine. OK, they killed him. But why didn’t they bury him? He was scattered around. I didn’t know where. Where were those bones? Where was he?”

That initial call came in 2005, a decade after Bosnian Serb forces killed more than 7,000 Bosnian Muslim men—the number remains in dispute, but this is the figure on record at the International Court of Justice—during a single week of the three-year Bosnian war. From July 11 to July 19, 1995, the men were killed in and near the town of Srebrenica, on the eastern edge of the Balkan nation of Bosnia and Herzegovina. Some were forcibly separated from their families and bused to execution sites; most were shot as they tried to escape to safer Bosnian Army–held territory. Ekrem Uzunović, whom Mirsada had loved since they met at a village dance when she was 15, was wearing black trousers and a T-shirt the last time she saw him, and in his backpack carried a loaf of bread she had baked that morning. He bent down to kiss their son, turned away, and ran. He thought he might escape by hiding in the woods.

Their son was two. Ekrem was 27. In Tuzla, the city in which Uzunović and many other Srebrenica war widows were resettled, there is today a two-room office whose inside walls are covered to the ceiling with photos of dark-haired Bosnian men like Ekrem, all dead or presumed dead. Stacked albums hold thousands more, and in the photos the men are smiling or smoking or looking celebratory with drinks held out mid-toast. The photos also show boys barely in their teens and men old enough to have been Ekrem’s grandfather. Uzunović: “In every yard there was the same scene—the men running out of their houses. Women and families were crying for them, and the men didn’t react or anything; they were walking toward the woods, not looking back. There was this blackness, with the forest behind it. A river of men. Yes, I have had nightmares, especially during this time of the year. After my psychotherapy it didn’t get easier. But my doctor gave me pills, for July, so I can cope. I still have dreams. But it’s better, because of the pills.”

When we met, inside the hillside Tuzla house where Uzunović and her son still live, it was July. Every July 11, in large part because of the relentless efforts of a network of bereaved Bosnian women, a group funeral—the coffin-by-coffin burial of remains identified during the previous year and approved by families for interment—takes place at a vast hillside cemetery established solely for the Srebrenica dead. The cemetery is in a village called Potočari, a few miles from Srebrenica; the first 600 coffins were buried in 2003, as investigators and DNA examiners were learning the full horror of what had happened to the bodies of the dead.

Now, in the first week of July 2015, the 20th anniversary was a few days away. Former U.S. president Bill Clinton was coming, Uzunović had been told, along with other international dignitaries. Uzunović was 41 now and regrettably familiar with the cemetery in midsummer, its beautiful green undulations, its exhausting rows of headstones, its open grass for gravesites not yet dug. She had sat through many July 11 Potočari burials already: her brother, her grandfather, three uncles, four cousins, men from Ekrem’s family, husbands of other widows. Every year until this one she had said not Ekrem, not yet; when the forensic center telephoned a second time, in 2007, and informed her that her husband’s hip and femur bones had been identified, Uzunović had declined again to proceed with a funeral. There was still not enough of him.

“But I have been carrying such heavy baggage on my shoulders,” Uzunović said to me and my interpreter, pouring thick Bosnian coffee into our cups. She had been painting a wall that morning and wore a paint-splattered sweatshirt and blue jeans, her black hair pulled into a ponytail. She looked drained and composed. “I’ve waited too long,” Uzunović said. “I need to close the chapter. I cannot wait anymore.” This year, at the Potočari ceremonies, she would bury her husband.

In Bosnian the word for widows is udovice. In the names of the collaborative organizations they built, though, the Bosnian war’s female bereaved are called žene, women. Snaga Žene, for example: Women Power. During that 1995 summer, people passing the Tuzla sports center could spot at once the Srebrenica žene who had been removed to Tuzla by the truckload while their husbands, sons, brothers, and fathers were being shot. Men had said: When I escape, I will get to the sports center; meet me there—and for weeks women kept standing just outside, hoping. “It was unimaginable for them,” Snaga Žene’s president, Branka Antić-Štauber, a Tuzla physician, told me. “To realize the scope, that this huge of a number of people had been killed over just a few days. And then the parts, from individuals, began to be found in separate graves. That was unimaginable for everybody.”

Bosnian Serb leaders, worried that the mass graves would be discovered, ordered thousands of corpses dug up and reburied around the countryside. Earthmoving equipment, disinterring and hauling and dumping, broke the decomposing bodies apart. Thus to the terrible residue traditionally left for widows in the world’s conflict zones—trauma, rape, isolation, financial destitution—a new burden was added: The Srebrenica remains, if they were to be reburied and mourned at individual gravesites, would have to be identified piece by piece.

The forensic detection, the exhaustive matching of bones and fragments to DNA samples from relatives, has been the work of a post–Bosnian war organization called the International Commission on Missing Persons. The demands for an accounting—the push for a single special cemetery; the hunt for photos of all the missing; the monthly street protests to insist that each man’s remains be found, the killers prosecuted, and the word “genocide” attached forever to the Srebrenica killings—have been the work of the women. “I have to say they’re all heroes,” Amra Begić, an official at the Srebrenica-Potočari memorial center, told me the day before the 20th-anniversary funeral. “We didn’t know what strong women our mothers are.”

Begić’s father and grandfather were among the victims; two headstones mark their graves. There were 6,241 finished graves before this latest delivery of the dead. The new green coffins now lined up inside the memorial center—in Islam green is a sacred color—numbered 136. The remains of Ekrem Uzunović lay in coffin 59, and on the cloudless warm morning of the funeral Mirsada Uzunović found the headstone with his name, the freshly dug grave. The relatives with her had brought folding chairs, and for a while she sat on one and received people politely, their embraces, their murmured sympathies. From a dignitaries’ tent too far away for her to see clearly, Clinton’s voice could be made out faintly, but Uzunović didn’t understand the English and was not especially interested. The voices changed, the prayers and intonations kept coming, and there was a moment of noisy rage when the Serbian prime minister, in attendance at a July 11 ceremony for the first time, tried to place flowers on a random headstone and was whistled and jeered so menacingly that his bodyguards hustled him to a waiting car.

An imam pleaded for respect. The cemetery went silent. The first of the green coffins could be glimpsed down below, borne by pallbearers; the imam called for prayer for the fallen, and thousands of people together on the hillsides bent simultaneously. Uzunović did not pray. She got off her chair, lit a cigarette, sat on the ground by the empty hole in the earth, and waited. Let the others pray, she thought. She had said so many prayers already, and it was Ekrem she needed to address: You told me to keep our son safe. Look, he is 22 years old. He is a university student. He is helping to carry your coffin. He will help lower it into the ground and shovel the dirt on top, and then, finally, you will have a place.

3. ENFORCING THE LAW, Mukono District, Uganda

“The humble petition of Tumushabe Clare Glorious showeth as follows.” In Uganda legal documents are composed in flowery, colonial-era English, and on a midsummer morning an attorney named Diana Angwech balanced two thick files on her lap, thumbing pages, reviewing. The improvised courtroom was a small red building between a corn patch and a stand of banana trees, an hour’s drive from the capital, Kampala. Inside, on the concrete floor, a few wooden benches faced the magistrate’s desk, which atop its clean surface displayed only a calendar, a Quran, and an old Bible held together with string.

A guard at the door stepped aside, and the people came in, filling the benches beside and behind Angwech. The widow Clare Tumushabe carried her two-year-old daughter, the youngest of her six children, and sat down in the fourth row. Tumushabe had once been a more timid woman, but her head was now high as she studied the courtroom around her; she had been pregnant with this daughter when her husband died—a sharp headache, a hospital unable to revive him—and she was learning how to speak with clarity and passion about what happened to her next.

She was summoned—mourning, pregnant—to a meeting of important members of her deceased husband’s family and clan. They informed her that the children now belonged not to her but to them; directed her to keep her hands off all crops on the household plot, as they also were no longer hers; and presented to her the brother-in-law—her husband’s oldest sibling, 20 years Tumushabe’s senior—who would move into the home at once and take her as the third of his wives.

The house and three acres Tumushabe’s husband had inherited from his father must pass wholly to them, the in-laws said. As the widow, Tumushabe, by tradition, was essentially part of the property, like the coffee bushes and the jackfruit trees.

Tumushabe told them this was nonsense. She said she would never take this man into her bed, that her husband had left papers proving the land passed to her. The in-laws said she had apparently bewitched and stupefied her husband and that she might want to see just how much help he would be to her now, from that freshly dug grave in which he lay. Tumushabe summoned police. She harvested some crops and chopped trees for firewood. Threats escalated; epithets were directed at the children. One day a man from her husband’s family appeared on the property shouting that today Tumushabe would die, and because Tumushabe’s hand was cut during the encounter by a panga—a broad-bladed African machete—Diana Angwech had an assault charge with which to haul one of Tumushabe’s tormentors into court.

UGANDA

You work with what the situation brings you, Angwech and her colleagues kept reminding us, as Toensing and I followed them through their rounds in villages of central Uganda: You commiserate, you counsel, you try to enlighten police officers and village elders, you visit community forums to explain that bullying a new widow into giving over her family property is prohibited even when the bullies are her own in-laws. “People were in shock—‘Oh my God, this is actually wrong?’ ” said a lawyer named Nina Asiimwe, recalling the first public talks she gave after joining other Ugandan professionals in the Kampala office of International Justice Mission (IJM), the organization that employs Angwech. “They thought it was normal. An injustice, but normal. OK’d by society.”

Think of these Ugandans as a widows’ defense brigade: attorneys, social workers, and criminal investigators using their nation’s own justice system to undo long-held assumptions about women who have lost their husbands. IJM is a U.S.-based nonprofit that supports legal advocacy in other countries for impoverished victims of violent abuse, and in one sense the agenda of its employees in Kampala is modest. They operate a pilot program, within one large, mostly rural district east of the capital, that provides free lawyers and caseworkers for victims of a crime known throughout eastern and southern Africa as “property grabbing”—extorting vulnerable people, by verbal threats or physical attacks, into giving up possession of land that is rightfully theirs.

For reasons both ancient and modern, widowed women are the most frequent victims of property grabbing in this region of the world. More than two-thirds of Uganda’s 39 million people raise at least some of their own food, and holding title to one’s own home and attached land remains a powerful assurance of material security: meals for the children, firewood for cooking, crops to sell at market. Because graves are often placed near the home, the person in charge of the family property also possesses ancestral history, honor, status. And the rapid growth of Uganda’s population, along with the arrival of mortgage banking, are pushing up the value of land. A house and the cropland around it now constitute potential loan collateral for business investments or the accumulation of more land.

These are things traditional Ugandan culture does not easily concede to a widow. The constitution, rewritten in 1995 and a source of national pride, promises gender equality. Modern statutes explicitly extend inheritance rights to wives and female children. But in practice, especially in the rural areas that make up most of Uganda, it’s still widely assumed that only men should own or inherit land, that widowhood terminates a woman’s social legitimacy, and that it’s up to her husband’s family and clan to decide what happens next—who will take the property, who will take the children, who will have sex with her now. “Plus the stigma,” Asiimwe said. “If you’re a widow, bad luck. You’re cursed. You’re blamed for the death of your spouse. It could be that he had several homes, several wives, that he brought HIV into the house. But when he dies, it’s you. You killed him.”

So with widows as their clients, IJM advocates in the villages and courtrooms of Uganda’s Mukono District have an audacious goal: to broadcast across Mukono, and perhaps throughout Uganda and beyond, the idea that seizing these women’s homes and crops—as well as the assaults, threats, forgeries, and verbal abuse this often entails—is not only wrong but punishable by the courts. Diplomacy is crucial; in village meetings Asiimwe always addresses her elders as “my fathers” and “my mothers.” She tells them she knows widow abuse is typically treated as a family dispute to be worked out among clan leaders or by village councils, whose elected heads command respect.

But their efforts are often inadequate, she insists, and council heads can be bought off or threatened. In Luganda, the primary indigenous language of the area, she uses blunt words: okubba, stealing, and kimenya mateeka, criminal. She implores her listeners to remember the likely future for a widow who is chased from her home by panga-brandishing property grabbers: Her birth family may not take her back, because they can’t afford to or no longer regard her as one of them. Such a widow may be left to the streets, perhaps forced into prostitution. “Then of course the society around them is going to face a problem of insecurity,” Asiimwe said. “The children will become street children. People who used to eat three times a day are going to eat once a day. Malnutrition will come into play.”

The buy-in is slow. A former national police officer who now directs IJM’s Mukono District investigations said his policing friends were initially perplexed as he began heading into village constabularies, teaching officers to gather property-grabbing evidence and take seriously threats of violence against widows who try to fight back. Colleagues of his generation would raise an eyebrow, he told us: “ ‘What is the issue here? Is this an important matter?’ ”

The threats are so credible and widespread, in fact, that they are sometimes directed at case investigators, which is why IJM asked that this investigator’s name not be published. And the cases themselves can be enormously complex. Uganda sanctions multiple ways to possess land, both precolonial and modern, so it can be hard to prove who held ownership rights even before the husband died. Ugandans are wary of wills, such obvious portents of death. Cohabitation relationships are common, even though those aren’t legal marriages; many women who regard themselves as wives turn out not to be, for inheritance purposes. “But I believe that there is hope,” lawyer and casework director Alice Muhairwe Mparana told Toensing and me last June. “We are not 100 percent there, but we have begun the work. We already have nine convictions this year.”

Some of the charges that stuck during the first half of 2016: unlawful eviction, criminal trespass, intermeddling, which means impermissibly interfering with someone else’s business matters. There is no law in Uganda, or anywhere else, making it criminal to treat a widow as though her life no longer has value. But June 23 marked the sixth International Widows’ Day, and in the biggest town in Mukono, a grassy square facing the courthouse was given over to a special commemoration, with microphones, a uniformed band, hundreds of folding chairs, and a tented seating area roped off, as the signpost read, for “Honoured Widows.” Important people rose to speak: the police chief, for example; and the head magistrate; and Clare Glorious Tumushabe, who took more time at the microphone than any of them.

With help, Tumushabe said, she had remained on her family property. “I only loved one man,” she shouted in Luganda, her voice rising like a preacher’s, and the Honoured Widows cheered. “I said to my husband’s clan, ‘How would you give me t

For years, the focus of stem cell research has hit the center of the media with expert arguments on both sides of this contro

Name

Institution:

Course:

Tutor:

Date

Introduction

For years, the focus of stem cell research has hit the center of the media with expert arguments on both sides of this controversial topic. Stem cells have been on the map as the link to possibly curing life threatening and life altering diseases by hopes of manipulating cells to become any cells of desirable quality. This advancement could cure any disease or illnesses ranging from mental disabilities to cancer. With, significant resources and efforts going into the research, many argue that the millions of funds going toward stem cell research can assist other social and economic sectors that require financial help. Millions of dollars have been directed towards stem cell research in hope to better human future, but with these biological advances in science, researchers argue to lengths with regard to the relative moral concerns.

In his review, Phillips defined stem cells as cells that are found in the multi cellular organisms and those that are capable of renewing themselves through a process of mitotic cell division and differentiating into diverse range of specialized cell types (1). He spelt out that there are two broad types of mammalian stem cells; embryonic stem cells and adult stem cells. Scientific evidence ascertains that stem cells have various functions in both the adult and the developing embryo. In the developing embryo, the cells have the ability to differentiate into various embryonic tissues which aid in the development of the same.

Embryonic cell systems are cells derived from the tissue of the cell of an earlier stage embryo approximately four to five days old and it consists of fifty to a hundred and fifty cells.

Differentiating embryonic cells into usable cells while avoiding transplant rejections are just a few of the hurdles that embryonic stem cell researchers still face. Because of their combined abilities of unlimited expansion and pluripotensy, these cells remain a theoretically potential source for regenerative medicine and tissue replacement after injury or disease.

From a moral standpoint, the procedure has raised different ethical as well as scientific issues. (New York Times, 1). While conventional studies argue that the technology is essential in eliminating pain and saving the lives at risk, some maintain that the process undermines the welfare of other individuals. However, a significant percentage of the populations justifies its use and believes that the rewards are worthwhile. Persons advocating for this technology tend to derive their view points from the moral standing that indicates that since the embryos lack the capacity to feel pain and suffering, they should not be treated as humans. In other words, the conception of pain and suffering plays a primal role in determining the status of these individuals in the society. Furthermore, they cite that according the embryos the fundamental moral status can undermine the application of different fertility programs. Presumably, this can have diverse social, economic and psychological impacts that can threaten the harmonic functioning of the entire society (Reaves1)

From a religious point of view, pro arguments ascertain that a fertilized egg that is living in isolation cannot be considered a moral being. As such, it needs not be treated as a normal human being. It is in this regard that they perceive the procedure to be morally acceptable as it enhances holistic human wellbeing through perpetuating a great degree of happiness.

In the life of an adult, the stem cells act as the repair systems of the body, replenishing specialized cells while maintaining the normal turnover of regenerative organs, such as blood, skin or intestinal tissues. In his research Bohlin indicates that this occurs because the cell has the property to divide and create another cell like itself and also divide and create a cell more differentiated than it (1). This cell types are known as somatic and they are found in both adults and children.

Scientists such as Steenblock show that most adult stem cells are lineage-restricted and are generally referred to by their tissue origin, adipose, derived stem cell (1). It is further contended that stem cells have been successfully used for many years to treat leukemia and related bone/blood cancers through bone marrow transplants. Further, mature stem cells are employed in treatment of tendons and ligament related infections in horses and cattle. In his consultative review, Forman ascertains that the use of adult stem cells is not controversial as the embryonic plant cells because it does not involve the destruction of an embryo and also because in some instances it can be obtained from the intended recipient (3).

The advantages of using cell stem research are wide and varied. To begin with, the procedure provides for medical benefits in the field of therapeutic cloning and regenerative medicine, Rosenthal cited that it also provides great potential for discovering treatment and cures to a plethora of diseases including different kinds of cancer and parkinson’s disease amongst others (1). Besides treatment of diseases, stem cloning provides for a means by which limbs and organs could be grown in a lab from stem cells and then used in transplants. Scientists and doctors would also derive huge benefits from this as they would be able to test millions of potential drugs and medicine, without the use of animals or human testers. This will necessitate a process of stimulating the effect the drug has on a specific population of cells. It is instrumental as it would ascertain if the drug is useful or has any problems.

In her speech at Virgin Health Bank, Rosenthal quoted that stem cell research also benefits the study of development stages that cannot be studied directly in a human embryo. Notably, this is sometimes linked to major clinical consequences such as birth defects, pregnancies loss and infertility (1). Arguably, a more comprehensive understanding of normal development would ultimately allow the prevention or treatment of abnormal human development. This technology has also been accredited for eliminating the implications of aging and enhancing the quality of human life. This is attained through the enhancement and prolonging of one’s life. Stem cell research has already initiated a host of treatments that help slow the aging process, and a bonus of further stem cell research is a possible ‘cure’ for aging altogether.

An advantage of the usage of adult stem cells to treat disease as cited by Kinsley is that a patient’s own cells could be used to treat a patient (1). Risks could be reduced significantly because patient bodies would not reject their own cells. Finally, embryonic stem cells can develop into any cells of the body, and may then be more versatile than adult stem cells.

Basically, scientific research contends that Umbilical cord blood shows promise for Adults. The disadvantage of using embryonic stem cells is that it involves that destruction of blastocytes formed from laboratory-fertilized human eggs. From an ethical view point, Bohlin believes that life begins at conception and therefore the blastocyte is a human life and destroying it is immoral and unacceptable (1).

Considering the fact that it is a new form of technology, the extent of the implications to the society is not conclusive. Nonetheless, emergent research ascertains that embryonic stem cells may also not be a solution for all animals. According to New York Times, stem cell therapy is effective in treating cardiac related complications (1). In particular, this has the ability to make coronary arteries become narrower.

Conclusion

In conclusion, the ensuing debate has prompted authorities around the world to seek regulatory frameworks and highlighted the fact that stem cell research represents a social and ethical challenge. The recent development of stem cell technology has been called a bypass of the legal controversy. Laws limiting the destruction of human embryos have been credited for being the reason for development of the stem cells, but they are less efficient and reliable than natural cells. Different approaches are currently being developed in a bit to address the problems through elimination of mutations. The relative moral controversies have also raised varied concerns with regard to employment of technology for vital functions.

Works cited

Chan, Sewell. “Saving Blood Cells from Umbilical Cords.” New York Times Company (2007), Retrieved 12th April 2010, from: <http://cityroom.blogs.nytimes.com/2007/06/22/saving-blood-cells-from-umbilical-cords/?scp=2&sq=umbilical%20cord%20stem%20cells&st=cse>.

Forman, Lillian. Stem Cell Research. Edina, Minn: ABDO , 2008. 112. Print.

Jennifer Reaves. Debate over Stem Cell Research. Retrieved 25th April, 2010, from: http://www.time.com/time/health/article/0,8599,167245,00.html

Michael, Kingsley. The Controversies of Stem Cells. Retrieved 25th April, 2010, from: HYPERLINK “http://www.time.com/time/magazine/article/0,9171,1101040531-641157,00.html” http://www.time.com/time/magazine/article/0,9171,1101040531-641157,00.html

New York Times.”In Studies, Umbilical Cord Blood Shows Promise for Adults .” New York Times Company (2004 ), Accessed 11th April, 2010, from: <http://query.nytimes.com/gst/fullpage.html?res=9407EED6153EF935A15752C1A9629C8B63>.

Ray, Bohlin. Stem Cell Controversies. Retrieved, 22nd April, 2010 from: HYPERLINK “http://www.leaderu.com/science/stemcellresearch.html” http://www.leaderu.com/science/stemcellresearch.html

Rosenthal, Elisabeth. “At Virgin Health Bank, parents can store babies.” NewYork Times Company (2007). Retrieved 11th April, 2010, from: <ttp://www.nytimes.com/2007/04/03/world/europe/03iht-stem.4.5130301.html?_r=1&scp=5&sq=umbilical%20stem%20cells&st=cse>.

Steenblock, David, and Anthony G Payne. Umbilical Cord Stem Cell Therapy. Laguna Beach, CA: Basic Health publication, 2006. 178. Print.

Stolberg, Sheryl Gay. “Obama Lifts Bush’s Strict Limits on Stem Cell Research.” New York Times Company (2009). Retrieved 13th April, 2010 from: <http://www.nytimes.com/2009/03/10/us/politics/10stem.html?scp=9&sq=umbilical%20cord%20stem%20cells&st=cse>.

Thererssa, Phillips. Pros and Cons of Stem Cell Research. Retrieved 22nd April, 2010 from: HYPERLINK “http://biotech.about.com/od/bioethics/i/issuestemcells.htm” http://biotech.about.com/od/bioethics/i/issuestemcells.htm

Food Miracles and Medicine

Name

Professor

Course

Date

Food Miracles and Medicine

According to Ornish, the human body can heal naturally if one stops processes causing the problem. It is also the human nature to be happy, peaceful, and healthy. Such aspects are innate, and there is no point of pursuing them. If there is a health problem, one can identify its cause and allow the natural healing to occur. For example, if someone gets a heart attack, people can think that it will get worse with time. However, the condition can improve provided one adheres to the optimal lifestyle program that revolves around diet, stress management, exercise, smoking cessation, psychological support, and supplements.

Foods can enhance or detract stress depending on how they are consumed. Normally, when people take food rich in bad fats such as omega-3 fatty acids, they can develop health-related problems leading to stress. One of possible solutions that may be offered to treat such health issues is to reduce the quantity of food taken, but the negative side of this advice triggers the loss of weight in an undesired way escalating the already-existing stress. A better solution is to take food that has low fat and high fiber which lead to fewer health issues and less stress.

Food can enhance the wellbeing and comfort of an individual depending on how they are selected. There are certain foods that can harm the human body if they are consumed in large quantities. They include sugary foods, white rice, and white flour. Such foods trigger excess production of insulin in the body. Too much insulin heightens the conversion of calories into fat which eventually causes obesity or heart-related problems. However, if one takes less-sugary foods, there will be lower risks of heart-related diseases. Thus, food can enhance our wellbeing depending on how we eat.

Although every individual needs food to survive, there are certain types that can cause addiction, particularly the hyper-palatable ones. They can potentially make one dependent on them just like the drugs do. Drugs cause addiction by altering brain functions and reinforcing drug-seeking habits leading to repeated overconsumption of the substance. Similarly, hyper-palatable food can shift individual’s attention from the normal diet leading to the overdependence and consumption of certain foods (Gearhardt et al. 1-2).

People’s cravings can be educational for their physical, emotional, and spiritual needs. Although it is normal to desire certain things, learning about their effects on our lives can educate individuals and possibly change their attitudes towards their desires. For instance, the wellbeing of a person depends on a number of issues, including intimacy, friendship, compassion, meditation, and support groups. If people are aware of such issues, they can learn to manipulate and free themselves from suffering and diseases.

Some of the possible implications of food, medicine, beliefs, and stress are reflected on the human health. They are the main factors that determine the health of individuals. Medicine can be used to reverse the adverse effects of food in our lives. Similarly, our beliefs can determine the level of self-induced stress in our lives.

It is the responsibility of the fortunate members of the society to provide food for needy people. In an attempt to provide food for themselves, the needy people have encroached on forests causing deforestation. However, if the rich were to reconsider what they eat, there could be plenty food for everyone.

The issue of reconsidering what one eats should be explored in three ways. First, it should be something that can stop one from feeling hungry once eaten. Second, it should be something that has fewer side effects on the body. Lastly, it should be something that can be produced cheaply without harming the environment.

Works Cited

Gearhardt, N. Ashley, Grilo, M. Carlos, DiLeone, J. Ralph, Brownell, D. Kelly, and Potenza, N. Marc. “Can Food be Addictive? Public Health and Policy Implications.” Rudd Center for Food Policy and Obesity. N.p., 2011. Web. 25 September, 2014. <http://www.yaleruddcenter.org/resources/upload/docs/what/addiction/AddictionPublicHealthandPolicyImplications_Addiction_6.11.pdf>.

Ornish, Dean. “Healing Through Diet.” TED. N.p., 2004. Web. 25 September 2014. <http://www.ted.com/talks/dean_ornish_on_healing#t-741846>.

Forced Migration Asylum Seekers being dispersed.

Forced Migration: Asylum Seekers being dispersed. 

Name

Instructor

Institution

Date

Forced Migration: Asylum Seekers Being Dispersed. 

Introduction

Forced migration is the movement of persons from their areas of residence for various reasons such as invasion, war, and lashes. Many of the displaced persons become refugees in the foreign countries. Voluntary migration is where people move from their countries of origin willingly to look for jobs or join their relatives in the other countries (Bloch, & Schuster 2005). The objective of this research is to analyse the forced migration from Palestine to the other parts of the world and the UK. The other activity will be collecting and analysing the data with respect to the number of asylum seekers in the UK. Human rights interventions on forced migration will be an area of importance in this research. The other area of this research will be the analysis of the dynamics of contemporary forced migration

Data on Forms Forced Migration in Palestine (2006-2012)

There are various forms of forced migration in the world, which can lead to internal or external movement of persons from their country of origin. Some of the forms of forced migration in Palestine to the UK are forced population are population transfer due to wars and conflict that saw 20,000 persons undergo displacement from Palestine to the other countries. The others are ethnic cleansing with 24,000 people, internally displaced people 230,000, and developmental displaced persons were 68,000. The other forced immigrants were the smuggled persons 21,000, trafficked persons 12,000 and environmental and disaster displaced 76,000 people. The asylum seekers to the other countries and the UK were 56,000, which is quite a big number (Castles, & Miller 2003). Looking at the figures Palestine’s forced migrants are very many, and the concerned parties such as the human rights organizations should intervene. Neighbouring countries should also offer assistance in the form of accommodation and refuge for the migrants.

Data Analysis and Presentation

Form of Forced Migration Number of Forced Migrants

Population transfer due to conflicts and wars 20,000

Ethnic Cleansing 24,000

Asylum seeking people 56,000

Internal displacement 68,000

Smuggling 21,000

Human trafficking 12,000

Displacement by disaster and environmental factors 76,000

Table showing the number of forced migrants from Palestine 2006-2012 (Castles, 2004)

From the table, the number of forced migration from Palestine is quite high, with displacement due to disasters being the highest with 76, 000 persons followed by the internally displaced persons with 68,000 persons. The ethnic cleansing displaced 24,000 while the asylum seekers were 56,000, which represent a high number of forced migrants from that country. Human smuggling stood at 21,000 while forced migration due to human trafficking was the lowest at 12,000. From the results, it shows that displacement of people from Palestine is quite high and needs immediate intervention by different governments and human rights groups.

Data representation

EMBED MSGraph.Chart.8

A graph showing the number of forced migrants from Palestine.

Nature and Scope of Forced Migration from Palestine

Forced migration is very high in Palestine with the majority of those, who suffer most being women and children. Most of the migration in Palestine is involuntary, and a few cases are voluntary. Forced migration in Palestine is rampant with many cases of human, trafficking and, ethnic cleansing, and religious conflict being the major causes (Cohen, 2001). There are many internally displaced persons in Palestine, who escaped their residential areas because of the internal wars and the conflict between Palestine and Israel. Majority of internally displaced persons depend on humanitarian groups for the basic communities, such as food and clothing. There are many scholars for Palestine spread all over the world, and one of the contributors to their large numbers is the forced transfer of people. There are very many internally displaced persons in Palestine, due to Israel- Palestine conflicts, who live in refugee camps and depend on the humanitarian groups for their basic commodities. There are many adolescents migrants in the camps, with most of them exposed to human violence and violation of their rights (Giddens, 2009). Forced migration is widespread in many parts of the country, with many of the migrants seeking refuge in West Bank, Syria, and many other neighbouring countries.

Human rights situation of forced migration in Palestine

The massive forced migration of persons from Palestine raised many concerns of the humanitarian groups especially the international groups as it involved the violation of human rights. The human rights activists have a lot of concern for the displaced persons in Palestine as they offer protection to the internally displaced persons in the country. However many human rights groups, especially the international groups take the mandate of providing the IDPs with their necessities (King, Black, Collyer, Fielding, & Skeldon 2010). The human rights organize seminars and forums for the IDPs and provide a chance for the refugees to interact and discuss their challenges that they face on a daily basis. There are other international human rights groups, which collaborate with the Palestinian human rights group to come up with programs for the forced migrants. The Palestinian human rights centre facilitate and coordinate programs for refugees such as seminars and income generating projects to help the displaced persons in coping with the life challenges. One of the international bodies that assist Palestinian refugees is the United Nations High Commissioner for Refugees UNHCR, which deals with forced migration affecting many countries. The other one is the United Nations Relief and Workers Agency for Palestine Refugees, who offer support to the Palestinian refugees in the Middle East UNRWA (Sigona, & Hughes, 2012). UNRWA has the mandate of ensuring that the refugees and other forced migrants have the basic needs and rights protection.

The extent of asylum applications in the UK and the cases of Human trafficking from Palestine

Research shows there are many asylum seekers in the UK, who come from Palestine and require assistance and protection by the government agencies. Many of the asylum seekers are children, who sometimes have no one accompanying them (King, 2002). Most of the children lost their parents or separated during the Palestine-Israel crises. The other group of persons seeking asylum were the youths, of which most of them did not have any training or skills. Another category was that of women with children and men who needed urgent help. The total number of applications received was 2818, out of which 1236 got approvals King, 2002). The cases of human trafficking from Palestine in the UK is growing at a high rate, with most of those trafficked working as domestic workers and prostitutes. Majority of the asylums and the trafficked people are in major UK towns working as casual labourers and domestic workers. Majority of them report that they got promises of working in industries and restaurants, only to end up in peoples’ homes to work as house helps and gardeners.

Dynamics and forms of contemporary forced migration

There are many forms of contemporary migration all over the world, with which leads to massive movement of people in their country or outside their country’s borders. Some of the forms of forced migrations are

Conflict -induced displacement where people leave their country if they feel that the state cannot offer protection to them (King, 2002). Some of the conflicts experienced in many countries are civil war, violence, discrimination in terms of race, social, or religion. Another form of forced migration is the development-induced displacement that involves people moving because of implementation of development projects. The projects may include railways, roads, airports, and environmental conservation, which cause internal displacement. The third forced migration is the Disaster-induced migration, in which people move away from their residents because of calamities, such as floods, landslides, earthquakes, and desertification (King, 2002). The other form is the human trafficking and smuggling, where some people take individuals out of their countries by promising them jobs and good life. Countries with internal migration should come up with policies to assist the displaced by compensating them for their land and buildings. Human rights groups should also offer assistance by addressing the root causes of forced migration and taking the right action such as prosecution of the perpetrators. An example where the perpetrators of internal displacement faced prosecution was in Kenya, during the 2007 election chaos (King, 2002).

Bottom of Form

Conclusion

Forced migration is a serious problem that faces many countries in the world. The rate of forced migration is increasing day by day due to various reasons such as conflict, human trafficking, natural disasters, and internal wars. The major causes of forced migrations in the Palestine are wars and conflict with their neighbors, such as the Israel and religious conflicts between the Christians and the Muslims. The children and the young people are the ones who suffer most whenever there is the forced migration. The human rights in Palestine and the UN are the major Humanitarian groups, who deal with the migrants and make sure they get the basic needs. There are various dynamics and forms of forced migration in the world such as conflict-induced migration and human trafficking among others. The area of forced migration is under-researched and, therefore, there is the need for more researchers to come out and find more information regarding forced migration.

References

Bloch, A. and Schuster, L., 2005. At the Extremes of Exclusion: Deportation, Detention and Dispers, Ethnic and Racial Studies, 28 (3), 491-512.

Castles, S. and Miller, M., 2003.The Age of Migration: International Population Movements in the Modern World, Basingstoke: Palgrave Macmillan.

Castles, S., 2004. Why migration policies fail Ethnic and Racial Studies, 27 (2), 205-27.

Cohen, S., 2001. States of Denial: Knowing about Atrocities and Suffering, Cambridge: Polity Press.

Giddens, A., 2009. Sociology, Cambridge: Polity Press

King, R., Black, R., Collyer, M., Fielding, A. and Skeldon, R., 2010. The Atlas of Human Migration: Global Patterns of People on the Move, Brighton: Earthscan

Sigona, N. and Hughes, V., 2012. No Way Out, No Way In: Irregular Migrant Child and Families in the UK, Oxford: Centre on Migration, Policy and Society (COMPAS), University of Oxford.

King, R., 2002.Towards a New Map of European Migration, International Journal of Population Geography, 8, 39-106.

Food misinformation on the media

Misinformation about Food on the Media

Student’s Name

Institution

Misinformation about Food on the Media

Food misinformation can be harmful, affect the economic well being, and the economic status of customers. Groups such as the nationally credentialed dietetics experts working in health care and government sources are qualified to backer science-based nutrition information to the public. As a result of increased nutrition health awareness, a large number of consumers are taking charge of their self care making them more vulnerable to nutrition and food misinformation (Larsen, 2011). This brings in the promise that food information that is sound can play a key role in a person’s health, and at the same time be vulnerable to health and economic considerations. The issue of food misinformation becomes even more critical when a population ages and they spend a lot of money on weight loss. This paper will focus on particular media food misinformation and try defining whether they are true or false.

Sources of food information are got from many sources. However, the media is the frequently used source of information with magazines taking 47%, newspapers (28%) books (29%), and television 34%, being the most importance(Larsen, 2011). The other category is under the internet which comprises of 21% of the information released.

According to a research conducted by the American Dietetic Association it showed that there are some advertisements that were posted in the internet showing that once the elderly people take some herbal supplements they could get cured of cancer, and cardiovascular disease(Larsen, 2011). When these supplements were closely examined they were found to contain mercury contaminants, and lead. These products were being sold online through the internet. Therefore, once consumers spend on products such as functional foods diet supplements organic foods advice from health professionals is required.Another good example is the advert which is usually made on margarine. The adverts show a kid who grows up very fast when the kid feeds on margarine. The aim of the advert is to draw the attention of the potential consumer to win his or her loyalty on the product. It is clear that feeding on too much fat can lead into various health disorders, but the product does not focus on the negative part of margarine. The information contained in the advert is not reliable, but is aimed at increasing the company’s sales (Larsen, 2011). Therefore, again the case of consumer becoming more conscious on these junk foods and seeking health advice from experts is an important strategy towards maintaining and leading g a healthy life. This calls for the American consumers to have an access to only comprehensive information about products like these. However, there is a need for empowerment on making relevant health decisions (Chopra, Lotvin, & Fisher, 2010).

Weight loss is a significant problem to a majority of adults in the United States. They invest more than $ 30 billion on weight loss services and products. It is clear that these consumers have a right to accurate as well as reliable information on weight loss management. That is they need to know whether the weight loss products or foods are reliable or dangerous (Chopra, Lotvin, & Fisher, 2010). The information attributed to these products by diet bookmakers, product producers, suppliers and advertising companies is very positive on these products, but they fail to show the side effects of the products.

These advertisements made either through the TV, and the weight loss diet magazines are misleading and they also prevent consumers from listening to words that endorse therapeutic routine changes as advocated by professional societies and the U.S. Department of Health and Human Services.Research has shown that 70 million Americans are practicing weight loss by using products and feeding on food stuffs that they have learnt from magazines or have seen adverts from the TV (Chopra, Lotvin, & Fisher, 2010). These products they are not effective as shown in those adverts. For example, cigarettes smoking and drug abuse deceptive adverts of weight loss products puts such people at a risk. Most of these products heavily advertised are unproven and are worst unsafe. They provide and promote hopes and expectations that are unrealistic. As a result, they doom the weight loss procedures less likely to succeed. Therefore, nonexistence of regulations and laws that protect the public from these misleading products and a media priority and willingness to assign to the highest advertising standards is likely to go high (Chopra, Lotvin, & Fisher, 2010). That is those media sources and companies that reject creation of food misleading advertisements is likely to reduce.

Another important area to note is on food packages. The information provided on certain food products during online advertisements and on nutritional labels provided on the food products entices consumers with great taste and good health promises. For example, natural food, fat free, sugar free among other false facts on food (Chopra, Lotvin, & Fisher, 2010). Therefore, in order to determine the veracity of such claims nutrition facts and laws required on packaged foods can be used.

Consumers expect that when they pay for product the information provided about it is true. For example, when a customer’s purchases a package of 100 percent Natural Granola” with oats, honey, he or she expects that the product includes natural ingredients only (Chopra, Lotvin, & Fisher, 2010). Conversely, checking the ingredients list a problem arises. These ingredients are arranged in a descending weight order, and it is notable that the information provided on the products ingredients is totally different from what the food product is made. As a result, a consumer will buy such food stuffs following the directives either on the printed label or online adverts on such food products (Larsen, 2011). However, in the long run it is discovered that the specified ingredients are not found in the product.

In conclusion, it is clear that media plays a role in misleading customers on food products. There is a need to control media practices because they can result into serious health hazards. Many people have followed advert prescriptions on certain products where they are later affected by very serious side effects.

References

Chopra, S., Lotvin, A., & Fisher, D. (2010). Doctor Chopra says: Medical facts and myths everyone should know. New York: Thomas Dunne Books.

Larsen, L. (2011). Diet and nutrition sourcebook: Basic consumer health information about dietary guidelines, servings and portions, recommended daily nutrient intakes and meal plans, vitamins and supplements, weight loss and maintenance, nutrition for different life stages and medical conditions, and healthy food choices. Detroit, MI: Omnigraphics.

HYPERLINK “http://www.scientificpsychic.com/fitness/labels.html” http://www.scientificpsychic.com/fitness/labels.html

Ford Case Study Analysis

Ford Case Study Analysis

Name

Affiliation

Course

Date Introduction

Any effective entrepreneur or financial specialist is always assessing the execution of the organizations they are included with, contrasting chronicled figures and its industry rivals, and even with fruitful organizations from different businesses (Rangan & Lee, 2011). To finish an intensive analysis of any organization’s adequacy, notwithstanding, a greater number of requirements to be taken a gander at than the effortlessly feasible numbers like deals, benefits, and aggregate resources. Fortunately, there are numerous decently tried ratios out there that make the assignment a bit less overwhelming. Financial ratio analysis aides distinguish and measure an organization’s qualities and shortcomings, assess its financial position, and shows potential dangers (Gertler & Kiyotaki, 2010).

Similarly as with some other type of analysis, financial ratios aren’t complete and their outcomes shouldn’t be seen as the main potential outcomes. Then again, when utilized as a part of conjuncture with different business assessment forms, financial ratios are significant. By analyzing Ford Motor Company’s financial ratios, alongside a couple of other organization considers, this report will give an agreeable picture of how the organization is getting along now and ought to do later on.

This is a trend table of Ford’s financial ratio for the previous five years: Ford Motor Co. (DE)

Ratios 12/31/2004 12/31/2003 12/31/2002 12/31/2001 12/31/2000

Return on Equity (%) 21.65 7.6 5.18 -60.04 29.07

Return on Assets (%) 1.19 0.29 0.1 -1.97 1.9

Return on Investment 8.13 5.62 5.87 2.23 11.24

Gross Margin 0.021 0.021 0.023 0.02 0.026

Operating Margin (%) 6.22 4.94 5.56 2.07 10.42

Net Profit Margin (%) 2.03 0.3 -0.6 -3.36 2.04

Quick Ratio 0.29 0.35 0.35 0.21 0.19

Current Ratio 0.48 0.53 0.52 0.32 0.22

Working Capital/Total Assets -0.20 -0.23 -0.14 -0.17 -0.19

Total Debt to Equity 9.12 12 24.21 18.12 7

Long Term Debt to Assets 0.32 0.37 0.40 0.42 0.32

Interest Coverage 1.72 1.12 1.10 0.8 1.75

This is a trend table of industrial average financial ratio for the previous five years in comparison: Industry Averages

Ratios 12/31/2004 12/31/2003 12/31/2002 12/31/2001 12/31/2000

Return on Equity (%) 16.22 8.65 -80.32 –0.41 21.06

Return on Assets (%) 2.34 0.68 -1.88 3.46 3.87

Return on Investment 8.13 5.62 5.87 2.23 11.24

Gross Margin 0.021 0.18 0.18 0.18 0.023

Operating Margin (%) 5.11 4.04 -5.56 7.07 8.42

Net Profit Margin (%) 2.83 1.43 -0.69 3.39 3.22

Quick Ratio 0.89 0.55 0.73 0.73 0.70

Current Ratio 1.23 1.34 1.11 1.87 1.44

Working Capital/Total Assets 0.12 0.12 0.02 0.05 3.21

Total Debt to Equity 7.12 10.87 18.21 15.11 9.12

Long Term Debt to Assets 0.32 0.46 0.93 0.98 0.21

Interest Coverage 8.82 2.00 0.88 -1.23 5.64

The analysis of these ratios shows how Ford stands as a company for the past five years.

Return on equity (ROE)

Uncovers the amount of benefit an organization earned in analysis to the aggregate sum of shareholder value on the asset report. For long haul contributing with awesome prizes, organizations that have exceptional yield on value ratios can give the greatest adjustments. This ratio additionally tells speculators how viably their capital is being reinvested, so it is a decent gage of administration’s cash taking care of abilities. Passage is demonstrating an impressive turn around here this previous year, which could without much of a stretch be because of changes in administration. They are additionally sensibly emulating the business around there.Return on assets

(ROA) tells the amount of benefit an organization creates for every dollar in resources. It quantifies the advantage power of a business. They bring down the benefit every dollar of advantages, the more resource escalated the business is. Passage is resource serious, in light of the fact that it requires enormous, costly supplies to produce benefit. This implies more cash must be reinvested into the organization to keep on producing profit. Despite the fact that their lower number is depicted in resource force, Ford is reliably falling a couple of rate focuses underneath the business normal here. This could be a thought against the organization.Return of investments

(Return of investments) ratio measures the consolidated impacts of overall revenues and aggregate resource turnover. This ratio analyzes the way an organization produces benefits, and the way it uses its resources for create deals. In the event that advantages are utilized successfully, ROI will be high. As indicated by Ford’s numbers, this has been a region of slow change over the recent years, after a radical drop from 2000 to 2001. This is the standard for the business, also. Worker evaluating advancements will be an enormous thought here during the current year.

Gross margin

Has a tendency to stay steady over the long haul. Be that as it may, this ratio is still essential to assess, on the grounds that changes can be an indication of extortion or unpredictable financials. A higher horrible edge than different organizations in the business likewise indicates more proficiency. Passage’s consistency in this ratio praises the organization’s steadiness. The way that the organization is reliably in front of the business additionally talks very of Ford’s productivity rate.

Working edge likewise measures administration’s productivity. It does as such by looking at the nature of an organization’s operations to others in the business. A higher working edge has a tendency to mean lower altered expenses and better horrible edge. This gives administration more adaptability when setting costs, which is especially vital amid times of financial hardship. This is an alternate region where Ford is abating turning things around. It is no astonishment, however, that the organization is additionally fairing above industry midpoints around there.

Net profit margin

Is what amount of benefit an organization makes for each dollar it produces in income? Ordinarily, the higher the organization’s net revenue, the better. In any case, there are instances of lower net revenue numbers being an indication of an organization’s evaluating technique or a value war. This is the first unmistakable indication of Ford’s numbers coming back to the gainfulness of 2000. While the organization is fairing marginally lower than the business normal around there, it is barely sufficiently huge to warrant a lot of a cautioning.Quick ratio

Is the hardest gauge of an organization’s liquidity and quality? It takes a gander at an organization’s benefits, discovers what can be quickly changed over to money, and partitions that by the organization’s liabilities (Woodford, 2010). This tells the amount of money an organization can think of in a matter of hours or days.Current ratio

Is a comparable test to speedy ratio, yet it ascertains what number of dollars in resources are prone to be changed over to trade inside one year in for cold hard currency request to pay obligations that come due amid that same year. Excessively high a number, in the same way as a 3 or 4, implies that there is an excessive amount of money close by that is not being reinvested. A number beneath 1, in the same way as that of Ford’s, implies that there is a negative working capital. This is adequate if the stock can instantly be changed over to money. On the other hand, in both brisk and current ratios, Ford is falling enough underneath industry midpoints for it to issue some worry.The working capital ratio

Uncovers all the more about the financial state of a business than different figuring. It makes it simple to predict any financial challenges that may emerge. For Ford’s situation, the turnover is not brisk enough not to keep a working capital save if there should arise an occurrence of financial hardship. The business normal falls rapidly behind this hypothesis with short of what a rate point contrast for as far back as five years.

Working capital ratio measures the amount of cash an organization ought to have the capacity to acquire over drawn out stretches of time. The ordinary level of obligation fluctuates, however any organization more than 40 to half ought to be taken a gander at all the more precisely on the off chance that there are fluid issues. Passage is fit as a fiddle around 8% this previous year in analysis to the 25% of 2002. This is yet an alternate zone where Ford is just after industry midpoints.

Long haul obligation to resource ratio can give valuable data with respect to the extent to which that organization funds its advantages with long-term obligation. It can serve as an option for assessing financial influence. Portage conveys such a low rate in this specific ratio, there is more influence. A large portion of the business falls under the level of influence here.

Interest coverage ratio

Is an estimation of the quantity of times an organization could make its advantage installments with its income before investment and assessments? They bring down the ratio an organization has, the higher the organization’s obligation trouble. This ratio gives stockholders a reasonable picture of the fleeting financial capacities (Doyle, Ge & McVay, 2007). At present, Ford is not experiencing issues producing the money to pay its advantage commitments, yet they are not about as secure as whatever remains of the business for the past few years.

The greatest component, adjacent to ratios, that needs to be considered in assessing Ford at this moment is the overwhelming outside business. Toyota is a prime illustration, as they are pushing some way or another to the number three spot in the United States car industry. The mind-boggling value climbs in human services of the years has gradually and most likely injured the American car industry in their endeavors to meet the annuities of all their past workers. This is not an issue for outside organizations, who have national social insurance frameworks set up. Unless things turn around, this shortage will cover the US car industry.

The key new activity for Ford, and additionally whatever is left of the business, is in creating half breed vehicles. Fuel effectiveness is an objective of the nation all in all, and President Bush has conferred a lot of cash towards this exploration. Notwithstanding, the lull in congress has not delivered the cash needed to do the innovative work for the huge three in the auto business. The few half and half vehicles that exist are scarcely an answer, nor are they paying for themselves in the fantastic plan of things yet.

From this investigation of Ford, now would not be a prime time to put resources into this organization. As opposed to the good faith of the yearly report, the American car industry’s battle is not over. While the numbers have started to turn around marginally over the past few years, Ford still has far to go. The innovative work alone that is obliged to support the auto business into its own particular is still years from execution (Kashyap, Stein & Hanson, 2010). While the financial ratios don’t warrant safeguarding boat for those that have officially put resources into this battling industry, present and future fuel issues will make it increasingly hard for any of the huge three to be effective. Besides, the financial trouble of paying American annuities cuffs the once auto goliaths from sifting more cash towards headway.

The DuPont Analysis.

An end to end strategic analysis technique of an organization ought to be done to spotlight on the accompanying essential points of view of the business. The business standard strategy for financial execution observing of Ford is to keeping a nearby look on the essential ratios of the organization:

Profit Margin

Net Income

= PM =

Sales (Total Revenues)

Sales (Total Revenues)

Total Asset Turnover = TAT = Total Assets

Return on Investment = ROI = Profit Margin X Total Asset Turnover

Net Income Sales (Total Revenues)

= X Sales (Total Revenues) Total Assets

Net Income

=

Total Assets

Total Assets

Equity Multiplier = EM =

Total Equity

Return on Equity = Profit Margin X Total Asset Turnover X Equity Multiplier

= Return on Investment X Equity Multiplier

Net Income Total Assets = X Total Assets Total Equity Net Income = Total Equity These five discriminating ratios are on the whole dissected in the DuPont model which is broadly utilized by Finance Managers and Consultants around the world. The last yield of DuPont analysis is the Return on Equity.

The flow chart for the DuPont Analysis of Ford

19050532130

References

Doyle, J. T., Ge, W., & McVay, S. (2007). Accruals quality and internal control over financial reporting. The Accounting Review, 82(5), 1141-1170.

Gertler, M., & Kiyotaki, N. (2010). Financial intermediation and credit policy in business cycle analysis. Handbook of monetary economics, 3(3), 547-599.

Kashyap, A. K., Stein, J. C., & Hanson, S. (2010). An analysis of the impact of ‘substantially heightened’capital requirements on large financial institutions.Booth School of Business, University of Chicago, mimeo.

Rangan, V. K., & Lee, K. L. (2011). Ford Motor Company: Strengthening the Dealer Network. Harvard Business School Marketing Unit Case, (511-132).

Woodford, M. (2010). Financial intermediation and macroeconomic analysis.The Journal of Economic Perspectives, 21-44.

Food Plan for track events athletes (Sprinters)

(Name)

(Instructors’ name)

(Course)

(Date)

Food Plan for track events athletes (Sprinters)

Introduction

In every sport, it is mandatory that all the athletes eat the right foods and train well. This is for the purpose of making them strong, as well as fit to engage in their various sporting activities. Performance is improved by the food that is consumed by them, and this means it must have all the needed nutrients. Most times, the athletes are involved in rigorous activities that make them burn and lose many calories. They are constantly exposed to sporting events, frequent workouts, and competitions, which affects their bodies. Sporting performance is improved by regular practice, but the food is the most vital aspect of the training program. Eating the right food is known to affect the performance of athletes (Volek, 2004. 34).

I have chosen to research about athletes who participate in track events and that are short distances. The latter is known as sprinters. This is because they are known for the distances that they run, and this involves a lot of energy usage. They need to find ways they can replenish the lost energy and finish their races. These are the reasons why I chose to research on this group of individuals. Readers will be interested to know about the food plan that is similar to that of Usain Bolt, and how it affects his performance. The food plan that I have provided is aimed at athletes who run short races between 200m and 100m.

This paper seeks to give an analysis of the food plan that athletes use, especially those in short track events. Also, it explains the benefits of using the required food plan.

Analysis of a track event Athlete’s Food Plan

Food Plan for sprinters

Breakfast Milk and Breakfast cereal

Snack Sandwiches that have egg, cheese and meat fillings

Lunch Chicken, Meat, Fish stir-fries and served with noodles or rice

Water

Snack Liquid meal supplements and fruit smoothies

Dinner Salmon on crackers with canned tuna served with rice cakes

Yoghurt or fruit

Snack Nut mixes and dried fruit

Athletes who run short distances are known as sprinters, and they have a food plan, which recommends that they eat high energy foods. According to their food plan, they have to eat at least five to nine snacks and meals on a daily basis. This is better off as compared to increasing their meal sizes. Furthermore, they are required to have a high intake of drinks such as juices, water, fortified milkshakes, and meal supplements that are in a liquid form, among others. They are highly recommended as they are better off as compared to bulky food. Products made especially for sports, and sugary foods should be taken. This is because they are high in nutrients, carbohydrates, and sugar. In order to fuel up, they must have a food record to assist in knowing when to eat (Volek, 2004. 36). From the above food plan, it is evident that the intake of proteins and carbohydrates is high as it aids in giving the sprinters energy.

The food plan has been approved by trhe International Association of Athletics Federations (IAAF). The latter is an athletics body, which has the responsibility of regulating the activities of athletes. On the other hand, the USDA has its own guidelines concerning the intake of food by athletes. It is recommended by the USDA that the calories, which are obtained from intake of proteins, are 20%. Thus, it is in accordance with the food plan that is recommended by the IAAF. It also recommends that the intake of carbohydrates is fifty percent of the total intake. This is because carbohydrates are high in energy and are vital to enhancing the athlete’s performance. The only differences, which exist between the IAAF food plan and that of USDA, is that the latter has more items (Volek, 2004. 42). For example, the USDA requires that athletes consume no more than 2300 milligrams of sodium on a daily basis. Also, an athlete should have an intake of fat that is saturated. In percentage form, this is 10% of the total intake of food that is consumed.

It is required that sprinters increase their strength levels, as well as their muscle mass. They can achieve this through the effective programs on resistance training. The myth that exists among sprinters is that protein intake should be monitored. Unfortunately, the latter is not true as it has been proven by researchers. The researchers have found out that taking proteins in large quantities does not influence the results of training. Instead, the sprinters should focus on strategies that promote intake of carbohydrates and proteins in the right portions.

Water is an essential aspect of the food plan, and the sprinters should have their water bottles all the time. This is because athletes should be well fueled and hydrated when they are working out, as this is the best condition for training. A sports drink is also recommended, and it should be taken together with the water. Water and a health drink assist in making the training session effective and lasting. Supplements are also encouraged as they have many beneficial elements. They include; enhancing performance, body fat reduction, muscle mass increment, and promotion of recovery. Caution should be taken by the athletes when they are taking supplements. This is because some have harmful substances, which can cause serious harm to the sprinters (DeLee & Drez, 2003. 45).

Many benefits are obtained as a result of having such a food plan. This is because sprinters need a cardiovascular system that is healthy, have strong muscles, and endurance that is obtained from the intense work out. Thus, they should all the time have with them sports drinks, water, and enough intakes of proteins, and carbohydrates. Only fats that are healthy should be consumed in order to have enough energy when training. Saturated fats and Trans fats mostly found in beef should be totally limited. This limitation also applies to processed and fast foods as they increase ones chance of obtaining heart diseases. By having a food plan, the sprinter is assured that their calorie intake is monitored. Athletes who have extra weight are advised to keenly follow the food plan and record their intake in food records (Kraemer & Zatsiorsky, 2006. 161).

Caution is given to athletes as they risk losing their lives or even being injured if they do not follow the food plan. Before training, they must have eaten what is required, and in the right amount. This is to reduce the risk of burnout and muscle cramps, among others. Fats should be consumed well, and especially the Trans fats. They are known to affect the athlete’s cholesterol levels by increasing the (LDL). Also, it lowers the athletes (HDL), which are known to be vital to the body functions. If sodium is taken in large quantities, it can be extremely deadly. Some of its effects include high blood pressure and paralysis, which can affect the athlete’s career or even end it. Thus, caution has to be taken by the athletes as its impacts are of a high magnitude.

Conclusion

In conclusion, the plan that I have provided is straightforward, also approved by the IAAF. Any athlete can easily find the food items as they are cheap and widely available. Apart from that, the reader should keenly follow the suggestions that I have provided. This also refers to the times when the food should be consumed. It should be known that supplements will never replace food; they only assist in providing the nutrients. They should not be misused as they may lead to poor and dismal performance by the athlete. The risks should be examined versus the benefits before taking supplements. It is extremely unfortunate when some athletes have to be disqualified from races because they have used substances, which are banned. The reader of this plan should ensure that they obtain more advice from a sports nutritionist. This is because there are different body types, and the intake levels are different. One needs to know about their individual food plans, and how it will assist during training. Indeed, Life quality and the health of athletes are determined by the choices they make concerning food.

Work Cited

Volek, S. HYPERLINK “http://www.purdue.edu/SWO/healthshop/nutrition/HealthyWeightGain/InfluenceOfNutritionOnWtGain.pdf” Influence of nutrition on responses to resistance training. Medicine & Science in Sports & Exercise, 23, 4, (2004): 23 -57.

DeLee, MD, & Drez, MD. DeLee & Drez’s Orthopedic Sports Medicine; Principles and Practice. Philadelphia: Saunders, 2003.Print.

Kraemer, William & Zatsiorsky, Vladimir. HYPERLINK “http://books.google.com/?id=QWSn4iKgNo8C&pg=PP12&dq=strength+training+weekly” Science and Practice of Strength Training, Second Edition. Champaign, Ill: Human Kinetics Publishers, 2006.Print.