Analyze current trends among drug and alcohol use within the last five years.

Evaluate empirical evidence that provides comprehensive information about one trend among drug and alcohol use within the last five years.

Analyze one current trend among drug and alcohol use within the last five years utilizing the empirical evidence for support.

-Include a comparison to previous years and predictions of the future of the current trend.

-Include how the current trend is being addressed within the field of addiction counseling. Illustrate how the knowledge of the chosen trend will benefit addictions professionals.

What is a Database?

What is an Attribute?

What is COSO?

What is IT Governance?

how can object -relational database be used to implement an SDBMS?

What is a csv file and how does database work in general?

Problem 05 Empirical Rule : Several years of final exam scores in statistics courses for a local university are normally distributed with a mean of 81 and a standard deviation of 8. If the lowest 2.5% of the scores on this test qualifies for a failing grade (F), use the empirical rule to calculate the score a student would need on this test to pass the final exam? show your work integer answer

Problem 08 Expected Value and Life Insurance Payouts : There is a 0.9985 probability that a randomly selected 60-year-old female lives through the year U.S. Department of Health and Human Services. A Fidelity life insurance company charges $180 for insuring that the female will live through the year. If the female does not survive the year, the policy pays out $100,000 as a death benefit.

1. From the perspective of the 60-year-old female, what are the monetary values corresponding to the two events of surviving the year and not surviving?

2. If a 60-year-old female purchases the policy, what is her expected value?

3. Can the insurance company expect to make a profit from many such policies? Why?

Problem 11 Continuous Random Variables: Empirical Rule:  Scores on an examination are assumed to be normally distributed with mean 78 and variance 10. Suppose that students scoring in the top 10% of this distribution are to receive an A grade. If you are asked “What is the minimum score a student must achieve to earn an A grade?”, can you use the empirical rule to answer this question? Explain your answer.

In the MATLAB environment, display an image of a breast mammogram from the MAMMO database. Apply gray-level scaling, histogram equalization, and an LOG enhancement mask for image enhancement as given below. Compare the enhanced images to original image qualitatively.

LOG enhancement mask to be convolved with the image:

- 1 -1 -1
- 1 9 - 1
-1 -1 -1

MAMMO database:

http://peipa.essex.ac.uk/pix/mias/

National Artists Association (NAA) maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Create a database implementation of the statements above using SQL.

1. Functional Dependency and normalization.

The following database table describes a hospital containing physicians and the patients they had appointments with.

1. Define the functional dependencies in the database table. (10 pts)

2. Normalize the table to follow third normal form (10 pts)

Suppose the MyBook.org company has three other employees of different roles. Alice: only need to retrieve book names from the database Bob: need to insert book names into the database Cob: needs to know the basic information of the table, such as the status of the table, when it was created, etc, but doesn't need to see the content in the table.

Q6: Should the company grant the same permissions to them? Briefly explain why.

Please answer true or false for each statement.

1. An attribute that is a foreign key cannot have a null value.

2.The Excel spreadsheet’s data model is set-theoretic.

3.A candidate key is a property of a database that must always be unique for all relations in the database.

4. A table in Microsoft’s Access must have at least one column.

5. In the relational model, a relation schema is a set of tuples.