topic:- Fundamentals of Databases

*********** no hand writing*********

If there is photo but photo don’t do fax ?

*the answer must be unique not copied "plagiarized "

question One

Consider the following two tables:

Table – EmployeeInformations

EmpId Name ManagerId DateOfJoining

121 Ali 321 01/31/2014

321 Raed 986 01/30/2015

421 Khaled 876 27/11/2016

Table – EmployeeSalary

EmpId Project Salary

121 P1 8000

321 P2 1000

421 P1 12000

Question

Explain the role of SQL authorization mechanisms that allow to differentiate among the users of the database as far as the type of access they are permitted on various data values in the database?

Match each term with the correct description:

You are a member of a research team that has been asked to create a proposal for a study design to address a potential cholera outbreak in Puerto Rico.

The Centers for Disease Control and Prevention is sending a team of epidemiologists to Puerto Rico to investigate cases of cholera associated with Hurricane Maria. As a team member, you are asked to research study design for the upcoming investigation, identifying the advantages and disadvantages of the following four designs as they relate to the mission:

Cross-sectional.

Case control.

Cohort.

Clinical trial.

Your job is to report back to leadership with a recommendation for a study design to be used in the investigation. You must also recommend an implementation strategy that considers the nature of the environment and the affected population.

You are a member of a research team that has been asked to create a proposal for a study design to address a potential cholera outbreak in Puerto Rico.

The Centers for Disease Control and Prevention is sending a team of epidemiologists to Puerto Rico to investigate cases of cholera associated with Hurricane Maria. As a team member, you are asked to research study design for the upcoming investigation, identifying the advantages and disadvantages of the following four designs as they relate to the mission:

Cross-sectional.

Case control.

Cohort.

Clinical trial.

Your job is to report back to leadership with a recommendation for a study design to be used in the investigation. You must also recommend an implementation strategy that considers the nature of the environment and the affected population.

Instructions

To successfully complete this assignment, you must include the following:

Outline the basic processes a team will use to investigate a public health threat.

Select the appropriate study design for investigating a disease outbreak.

Compare epidemiological strengths and weaknesses of study designs used in research and practice.

Recommend evidence-based epidemiological methods for investigating cases of disease outbreak after a natural disaster.

Describe how to control bias in an epidemiological research study.

Recommend implementation strategies for a disease investigation team.

The evidence supporting obesity as a risk factor for colon cancer remains inconclusive, especially among women. A study reported the association between obesity (measured at baseline) and colon cancer morbidity as determined from review of medical records and death certificates in a nationally representative cohort of men and women age 25-74 years who participated in the First National Health and Nutrition Examination Survey from 1971 to 1975 and were subsequently followed up through 1992. The following table is from this study for men and women combined.

a. Which of the following best describes the research design used in this study? Choose the ONE best answer. (1 point)

1. Cross-sectional survey
2. Ecological study
3. Population based case control study
4. Cohort study
5. None of the above

b. Complete the table above by calculating the crude body mass index-specific incidence rates. (Show your work in the table above.) (3 points – ½ point for each correct answer)

c. Calculate the relative risk (rate ratio) of colon cancer associated with a BMI of 30+. Use the lowest BMI category as the reference group. In one sentence interpret your answer. (2 points)

d. Calculate the attributable fraction among those in the 30+ BMI category. In one sentence interpret your answer. (The attributable fraction formulas provided in class can be used even though the data provided here is for rates.) (2 points)

Question 1:

Broussard Skateboard's sales are expected to increase by 25% from $7.8 million in 2016 to $9.75 million in 2017. Its assets totaled $2 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2016, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 55%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Round your answer to the nearest dollar. Do not round intermediate calculations.

Question 2:

Broussard Skateboard's sales are expected to increase by 15% from $8.8 million in 2016 to $10.12 million in 2017. Its assets totaled $5 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2016, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 70%. What would be the additional funds needed? Do not round intermediate calculations. Round your answer to the nearest dollar.
$

Assume that an otherwise identical firm had $6 million in total assets at the end of 2016. Broussard's capital intensity ratio (A₀*/S₀) is Higher / Lower / Equal toItem 2 than the otherwise identical firm; therefore, Broussard is More / Less / Same capital intensive - it would require Small / Large / Same increase in total assets to support the increase in sales.

Question 3:

Broussard Skateboard's sales are expected to increase by 20% from $7.8 million in 2016 to $9.36 million in 2017. Its assets totaled $5 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2016, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 3%. Assume that the company pays no dividends. Under these assumptions, what would be the additional funds needed for the coming year? Do not round intermediate calculations. Round your answer to the nearest dollar.
$

Why is this AFN different from the one when the company pays dividends?
I. Under this scenario the company would have a higher level of retained earnings but this would have no effect on the amount of additional funds needed.
II. Under this scenario the company would have a lower level of retained earnings which would reduce the amount of additional funds needed.
III. Under this scenario the company would have a lower level of retained earnings but this would have no effect on the amount of additional funds needed.
IV. Under this scenario the company would have a higher level of retained earnings which would reduce the amount of additional funds needed.
V. Under this scenario the company would have a higher level of retained earnings which would increase the amount of additional funds needed.

Question 4:

The Booth Company's sales are forecasted to double from $1,000 in 2016 to $2,000 in 2017. Here is the December 31, 2016, balance sheet:

Booth's fixed assets were used to only 50% of capacity during 2016, but its current assets were at their proper levels in relation to sales. All assets except fixed assets must increase at the same rate as sales, and fixed assets would also have to increase at the same rate if the current excess capacity did not exist. Booth's after-tax profit margin is forecasted to be 5% and its payout ratio to be 40%. What is Booth's additional funds needed (AFN) for the coming year? Round your answer to the nearest dollar.

$

1. How is the discrete choice experiment method different from the contingent valuation method? What are some relative advantages of the discrete choice experiment method as compared to the contingent valuation method? Can you think of any examples where the contingent valuation method may be more practical than the discrete choice experiment method?

When the supply of oxygen is limited, iron metal reacts with oxygen to produce a mixture of FeO and Fe2O3 . In a certain experiment, 20.00 g iron metal was reacted with 11.31 g oxygen gas. After the experiment, the iron was totally consumed, and 3.91 g oxygen gas remained. Calculate the amounts of FeO and Fe2O3 formed in this experiment.

1.Describe an experiment you would perform to determine if a beetle can discriminate between green and yellow. Be sure to explain the independent and dependent variables of your experiment.

How might you go about ensuring that your test subjects in the experiment above are attending to the cues you are presenting, and are provided enough motivation to discriminate?

Question #1:

• What is a survey?
• With the aid of examples, distinguish between face-to-face, telephone, mail, and internet surveys.
• What are their relative advantages and disadvantages?
• Which is the best and why?

Question #2:

• What is an experiment?
• What is the difference between a true/classical experiment and a quasi-experiment?
• Enumerate and explain 5 threats to experimental validity.

which one is true and which one is false?

1. Investment depends both on the expected present value of future profits and on the current level of profit.
2. Tobin’s q theory of consumption is based on the notion that the stock market can provide a   good estimate of expected profitability.
3. In the pipeline theory, inventories are held as part of a production process.
4. As a result of anticipated information, stock prices follow a random walk.
5. The return on the savings account is R × ps; the return on the stock is the dividend plus the capital gains, Δps.
6. The MPK equals the user costs, uc & variations in the user costs, given the MPK schedule, are then used to explain variations in the desired capital stock, investment.
7. Wage equality is largely caused by a steady increase in the demand for high-skilled workers relative to the demand for low-skill workers.

10-Deflation spiral or deflation trap occurs at Y’ when output is still below potential, and thus inflation is still decreasing.