Consider the following data.   

If the database administrator in the University has turned off auto-commit, consider the following:

Student 4211 has joined the Photomedia and Design club. When the system admin wanted to update the database, she wrote the following statement:

UPDATE STUDENT

SET CLUBID = “PDC”

Answer the following:

1. How does the above SQL statement produce false information in the Student table?

The data below is the total spending (in millions of dollars) on drugs and other non-durable products for your assigned state (or DC). You need to convert this data to spending per capita in constant 2019 dollars.

Go to the FRED database at https://fred.stlouisfed.org/

Search for the PCEPI. Change the frequency to annual. Using that price index (this is a national index; there isn't a PCE index for each state), convert the following to 2019Q3 dollars.

Again using the FRED database, find the population for your state. The symbol is usually the two letter abbreviation for the state and POP. New York, for example, would be NYPOP.

Using this information, covert the spending below into spending per capita, in 2019Q3 dollars. Keep in mind that the values below are in millions of dollars and you want your answers in dollars.

Enter your results for every even-numbered year in the answer

Alaska

According to data from the 2018 General Social Survey (GSS 2018), the average number of years of education of the 2345 adults in the U.S. sample is 13.73, with a standard deviation of 2.974. Compared to the national average of 13.26 years of education in 2000, researchers are wondering if the national education level had increased during these years. Do a hypothesis testing with α=0.05. Use this example to answer questions 24 to 27.

24. What’s the null hypothesis in this case?
A. The average number of years of education in the U.S. adult population did not change much from 2000 to 2018.
B. The average number of years of education in the U.S. adult population was equal to 13.73 in 2018.
C. The average number of years of education for the GSS 2018 sample is no different from 13.26, the national average in 2000.
D. The average number of years of education in the U.S. adult population had increased from 2000 to 2018.

25. What’s the alternative hypothesis in this case?
A. The average number of years of education in the U.S. adult population had changed since 2000.
B. The average number of years of education for the GSS 2018 sample is different from 13.26, the national average in 2000.
C. The average number of years of education in the U.S. adult population in 2018 was higher than that in 2000.
D. The average number of years of education in the U.S. adult population had decreased from 2000 to 2018.

26. Which of the following statements about this example is correct?
A. This is a two-tailed test and you have two rejection regions.
B. Since the sample size is large, we cannot use the normal distribution as the sampling distribution.
C. This is a one-tailed test and the rejection region is on the left side of the sampling distribution.
D. The rejection region is on the right side of the sampling distribution.

27. What conclusion can we draw for this example?
A. There is no enough evidence to reject the null hypothesis.
B. We can be 90% confident that the average number of years of education in the U.S. adult population had increased since 2000.
C. The average number of years of education in the U.S. adult population had increased since 2000.
D. There is a significant difference between 2018 and 2000 in terms of the national education level in the U.S. adult population.

Data Modeling and Database Design (Database Concepts, Eighth Edition)

The relational model is the most important standard in database processing today. Why do you feel that this model has continued to be successful in the world of IT? What would happen if large corporations decided to reject this theory, and store their data using a non-relational model? Are there any success stories where this has happened?

Dan is Single, Age 47 and has a new business on 1/15/2018, he provides service for a summer camp for children.

Dan's 2018 transactions related to business:

Income    $100,000

Mortgage Interest 8,000

Property Taxes 3,000

Utilities    5,000

Supplies    7,000

Telephone fees 2,000

Estimated Federal Tax
Payments    15,000

Dan Purchased a commercial building on 2/1/2018 for $300,000 in which (building=80% of the cost and land= 30% of the cost).
Dan also purchased a computer for his business on 2/15/2018 for $2000. Dan does not take section 179 deduction or bonus depreciation.

Question 1) are the business expense deductions FOR AGI or FROM AGI ?
Question 2) List any non deductible expenses
Question 3) If Dan Sells the computer on 9/20/19 for $600, what is his gain of loss?

Given is a Python program that connects to a sqlite database and has one table called writers with two columnns:

• name - the name of a writer
• num - the number of works the writer has written

The writers table originally has the following data:

name, num

Jane Austen,6

Charles Dickens,20

Ernest Hemingway,9

Jack Kerouac,22

F. Scott Fitzgerald,8

Mary Shelley,7

Charlotte Bronte,5

Mark Twain,11

Agatha Christie,73

Ian Flemming,14

J.K. Rowling,14

Stephen King,54 Oscar Wilde,1

Update the Python program to ask the user if they want to update entries or add new entries. If the name entered already exists in the writers table then the database record is updated, overwriting the original contents. If the name does not exist in the writers table, then add a new record with the writer's name and number of works. The following TODO sections must be completed.

• Check if a writer exists in the writers table
• If the writer exists in the table, locate an entry to be updated by writer's name and update the writer's value for num
• If the writer does not exist in the table, add a new entry in the writers table and provide the value for name and num

Ex: If the input is:

y

J.K. Rowling 30

y

Elton John

y

62

n

What is output. Getting nothing but errors with existing help. Again, this is for Python3

Foot length in millimeters for a sample of 2000 babies is approximately normally distributed with a mean of 81.0. If the standard deviation is 5.0 mm, how many babies would the empirical rule suggest have feet of length longer than 86.0 mm but shorter than 96.0 mm?

Data modeling is a key component to creating a database. There are all different aspects of data modeling, with concerns from various things to the methodology of modeling, to software, to interfaces used between each model.

Paper: Write a 3 page paper (at model 1.2 spacing, 12 pt font, 1 inch margins with at most one half of the paper including a figure, citations not included) on some aspect of data modeling in industry. You must use reliable academic and industry resources. You must have at least one resource that connects your topic to industry. Write up should not exceed 4 pages, excluding citations. Example topics include:

• Data modeling challenges in transportation industry (logistics)

1) How does information and knowledge management link to competitive advantage? Discuss the reasons why or why not a dominant firm might or might not consider attacking smaller competitors to increase market share?

2) Companies have to update their strategy on a regular basis but sometimes need to look at radical change, briefly explain these two types of Strategic Change and how they might affect company organization. Define incremental and transformational change.

enter academic citations.