Class: Healthcare Policy

Give some examples of the statement, “Common disorders commonly occur and rare ones rarely happen.” What are the implications of this statement for the ratio of generalist to specialist physicians in the United States? In addition, find one recent article about the ratio of generalist to specialist physicians using the ProQuest database in LIRN (see eResources) and write an informative summary of what you found. (400 words)

An agency wants to examine the distribution of wages F(x) of graduates with bachelor degrees. For that purpose they receive from US Census Bureau database a sample X₁,…, X_n of   10,000 numeric records of wages for randomly chosen graduates.

Find the algorithm to provide an interval of wages which cover the 50% central part of distribution F(x) with approximate confidence 95%. How can you evaluate the accuracy of that estimation?

- Explain what a business environment is and what factors within the environment put pressure on the business.

- Identify the five forces of Porter’s competitive forces model, and explain how the Internet impacts each one.

- Explain the six issues that can be addressed using the database approach.

- Differentiate among local area networks, wide-area networks, and value-added networks

- Discuss the advantages of voice over IP for organizations.

Read “Scuba: Diving into Data at Facebook." Consider Facebook and other social media platforms when answering the following topic questions:

• What challenges do they face from a data handling perspective?
• What database issues has Facebook had in the past? How do they handle them?
• What are their current efforts to maintain peak performance on their site?
• Are these performance efforts unique to social media? Why?

Key roles for a successful analytics project. Select a data analytics of your choice and discuss how the following roles add value to this initiative: Business User, Project Sponsor, Project Manager, Business Intelligence Analyst, Database Administrator, and Data Engineer. Again, please note that you will discuss specific activities that each of these roles may perform on a data analytics project that you select.

Need 500 discussion

Using Node.js as a Webserver

1. How do you modify a webserver.js code to include your name and date? Please include code.

2. Create a MongoDB database for the following group that includes member names and contact information and Include code: Gourp member exapmples: Pete 912-555-6666; Sam 912-111-3333; Mary 678-111-1111; and April 912-690-1111

Using your downloaded DBMS (MS SQL Server or MySQL), write SQL queries that inserts at least three rows in each table.

1. 1. For the On-Demand Streaming System,
      1. First, insert information for multiple users, at least three video items and insert the three different types of subscriptions (Basic, Advanced, Unlimited) into the database.
      2. Then insert at least three user subscriptions.
2. Execute the queries and make sure they run correctly

Create a new website using C# & ASP.Net in Visual Studio:

1. Create a web page to access a database and display the data from a table by providing an SQL statement. Create the page with these requirements:

    create label, textbox and button
    the textbox will capture the SQL statement
    the button will process the statement and display the results

2. Add necessary data access pages to your project.

3. Display the data in Gridview

A Video store (AVS) runs a standard video stores. Before a video can be put on the shelf, it must be cataloged and entered into the video database. Every customer must have a valid a AVS customer card to rent a video. Customers rent videos for three days at a time. Every time a customer rent video, the system must ensure that he/she does not have any overdue videos. If so, the overdue videos must be returned and an overdue fee paid before customer can rent more videos, Likewise, if the customer has returned overdue videos but not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos. If a video is two or more days overdue, the manager calls the customer to remind him/her to return the video. If a video is returned in damaged condition, the manager removes it from the database.

1. Create a State Machine Diagram the above information

2. Choose two different senerios from the above situation and make a sequence diagram for each

Assignment 1 - IN PDF FORMAT Using R and Rstudio

Pick a database from: data()

Then preview the first 10 rows.

Print the number of rows and columns

- Print the names of the variables

If you have row names, print them - work with the values for a field in your dataset. You can do it by dataset[[xx]] operator with xx can be the index of the field or the nae of the field.

Now use dataset[xx] to get a slice of datframe instead of vector, e.g. df = mtcars[c(‘mpg’, ‘disp’)] - With two scalar arguments (rows,columns), the [] operator can select elements in the dataframe. Try this.

- Subset your data using rules similar to the lectures. For example part of the data that has a characteristics AND/OR another one, etc.

- Write a function that does an operation, for example averaging a property, on your dataset.

- Write a function that works on rows and adds a column to the dataset with the results for each row.

- Using the iris database, explain the following line of code:

data(iris) aggregate(iris["Petal.Length"], by = iris["Species"], FUN=median)

## Species Petal.Length

## 1 setosa 1.50

## 2 versicolor 4.35

## 3 virginica 5.55