A database needs to be developed that supports a supermarket.

(i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements.

1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records how many items of each product are currently on stock.

2. A product can be on special offer. A special offer is valid for a period, which has a start date and an end date. A special offer refers to exactly one product. Two special offers for the same product cannot have overlapping periods. A special offer for a product specifies that a certain number of items of that product are sold at a certain price (e.g., 2 items for $1.99).

3. There is a card scheme for which customers can register. A registered customer holds a customer card. Each registered customer has a customer number, which is unique. For each registered customer the supermarket records the name and the address of the customer and the day when the customer joined the card scheme.

4. When a customer buys one or more items and pays for them, a purchase is being completed. A purchase is uniquely identified by the number of the checkout where the customer pays, together with the date and the time when the purchase is made.

5. Some purchases are made by registered customers.

6. A purchase consists of one or more line items. Within a given purchase, each line item is uniquely identified by its line number. Each line item refers to a unique product. (In fact, the line items correspond to the items of the purchase). Some line items have an additional comment, which is a string. (The comment may say that a special price applies to the product item because it is part of a special offer.)

[20]

Use the “Consumer Food” Database on “Excel Databses.xls”. As the researcher you are interested in predicting the annual food spending according to annual household income as well as a qualitative variable: location or region.

Link to data: https://drive.google.com/file/d/1YMYMy7H0sLRZJzXwFKMrANuAGxmp-z9I/view?usp=sharing

Please use excel and post step by step

Construct two regression models to predict annual food spending:

• Model 1: Food = b₀ + b₁Income + b₂Metro
• Model 2: Food = b₀ + b₁Income + b₂NE + b₃MW+ b₄S

NOTES:

• DO NOT: Print the data.
• DO: Only print the results of each model from Excel (i.e. Print the Summary Output, ANOVA, and Table of Coefficients from each model
• DO NOT: Include the residual output to turn in.

Must complete all the parts to this problem:

• PART 1: Output the results from Excel for Model 1.
• PART 2: Output the results from Excel for Model 2.
• PART 3: Write the model (estimated regression equation) using your output for Model 1. Then calculate the predicted annual food spending for a household outside the metro area that has $60,000 income.
• PART 4: Write the model using your output for Model 2. Then calculate the predicted annual food spending for a household that has a $35,000 income and is located in the South.

Use the Securities and Exchange Commission’s EDGAR corporate filings database to search for and view the annual reports on Form 10-K of Google and Yahoo.

Google: https://www.sec.gov/Archives/edgar/data/1288776/000128877615000008/0001288776-15-000008-index.htm

Yahoo: https://www.sec.gov/Archives/edgar/data/1011006/000119312515066560/0001193125-15-066560-index.htm

Click on the Document Link for 10-K, In the Table of Contents, go to Item 8 Financial Statements and Supplementary Data.

Using information from the statement of cash flows, answer the following questions for each company:

1. Which method, direct or indirect, was used to prepare the company’s Statement of Cash Flows? How can you tell?

2. How much cash and cash equivalents did the company have on hand at the end of its most recent fiscal year?

3. What is the trend in the company’s net cash from operations over the past three years?

4. What were the significant cash flows from or used by financing activities during its most recent fiscal year?

5. What were the significant cash flows from or used by investing activities during its most recent fiscal year?

A. The Train Station has a database of travel times on the blue line ever sense it began running. An analyst pulls a report of all the travel times from the Washington stop to the Oak Park stop. The average is 14 and the standard deviation is 4.

B. The analyst calculates 81 average travel times based on a random sample of 49 travel times in each sample. A subset of these averages is 14.5, 16.8, 17.2, etc.

C. One of the sets of 49 travel times has values such as 12, 14, 18, 17, etc.

Question 1

Indicate which of the three is a sample distribution

Choice A

Choice B

Choice C

Question 2

Indicate which of the three is the population distribution

Choice A

Choice B

Choice C

Question 3

Indicate which of the three is a sampling distribution

Choice A

Choice B

Choice C

Question 4

According to the Central Limit Theorem (and only the Central Limit Theorem) what will be the average of the sampling distribution

A) 14

B) 4/2

C) 14/81

D) 4/7

Question 5

According to the Central Limit Theorem (and only the Central Limit Theorem) what will be the standard deviation of the sampling distribution

A) 14

B) 4/6

C) 14/10

D) 4/7

Question 6

According to the Central Limit Theorem (and only the Central Limit Theorem) what will be the shape of the sampling distribution

A) Regular

B) Normal

C) Non-normal

D) Rectangular

Question 7

Now suppose that the analyst calculates 100 averages each with a random set of 36 travel times in each sample. What will be the standard deviation of the sampling distribution. All other facts are the same.

A) 14

B) 4/6

C) 14/10

D) 4/7

Question 8

Which of the two sampling distributions will have a WIDER spread?

A) The first

B) The second

For this assignment, you will use the provided database in the Unit 5 script file. You will add statements to this file to query the database tables. For your reference, below is a screenshot of the enhanced entity relationship diagram (ERD) as a reference when you write your queries. With the data types listed in the diagram, this will help you identify the types of operators that you can use for particular queries.

Use paiza.io for MySQL to execute and troubleshoot your Structured Query Language (SQL) statements. It is recommended that you use Notepad to write your SQL statements. Then, copy and paste your SQL statements to paiza.io to test your statements to ensure that they execute without errors. Save your work frequently.

The asterisk (*) indicates that a column is not null (i.e., required to have a value).

1. If you would like to see the test SQL statements, click on “Run” to see the statements execute. You should see “Hello” appear in the Output window (see the following screenshot).
2. Because you do not require these test SQL statements for your assignment, delete the sample SQL statements. To do this, select the text, and click on the Delete key on your keyboard. Your MySQL paiza.io screen should now be blank, as you see in the following screenshot. Note that if you ran the test statements, “Hello” will still appear in the Output window.
3. Copy and paste the code from the provided script file into the code editor, and click on “Run” (“Ctrl + Enter”). You should see no error messages displayed in the Output area at the bottom of your paiza.io screen. After you click on “Run,” you should see a green bar with “Success” at the top. You will see this circled in the following screenshot:
4. Next, you will write 1 query to respond to each of the following questions. Note that you can only use the information that is in the question or the enhanced ERD. Write a query to do the following:
   1. Display all of the rows in the publisher table.
   2. Display all of the books in the book table that were written by the author whose author ID is 1504192.
   3. Display all of the purchases in the shopbasket that were ordered on 2020-02-29.
   4. Display the largest quantity ordered in the shopbasket.
   5. Display the authors' first and last names sorted by their last name.
   6. Display a count of the number of orders placed via the shopbasket.
   7. Display the order date and quantity of orders in the shopbasket that have a quantity of more than 25.
   8. Display the first and last names of those authors who have a null Facebook.
   9. Display all of the customers' names, city, and state if they live in GA, FL, or CA.
   10. Display the book titles of those books that were not published by Scholastic Press.
   11. Display the first and last names of the authors and the book titles. Only display those authors who wrote a book with the word database in the title.
   12. Add a multiline comment before the first CREATE TABLE statement that includes your name, the course code (ITCO231), and the date when you are submitting your assignment.
5. Save your script file using your last name, ITCO231, U5, and the file extension .sql, as in “Smith_ITCO231_U5.sql.”
   1. Tip: When saving a Notepad file, you can change the file extension to .sql as required for the assignment by changing the “Save as type” to “All Files” and then typing the .sql extension, as shown in the example.

I didnt understand by what you mean by SQL TEST. If what you are asking me is that an SQL TEST? Yes! It is SQL QUERY TEST!!

Statistica is a well-known database that caters to the research requirements of economists and data scientists. The penetration rate for Statistica is however, not as high as compared to similar products in the market with much less functionality. A market research report on the use of Statistica shows that the main reason individual researchers haven’t signed up for the database is the price.

To boost revenues, the top management of CIE Ltd., the creator of Statistica is contemplating a promotional price. Since this offer will be a part of our supplier promotion plan and will be publicised, the same deal has to be offered to our existing subscribers as well. A genuine concern of the top management is that the additional subscribers generated by the lower price may not fully offset the revenues lost from our existing base of subscribers.

Based on data on the current sales in the excel sheet, please comment whether lowering the price will yield higher revenues? Can you also arrive at an estimate of the maximum monthly revenues that can be achieved?

Please write your answer in the answer sheet. Excel calculations need to be attached too. Answers without excel sheet will not be evaluated (sheet attached).

Access the CallCenterWaitingTime.xlsx file. Each row in the database corresponds to a different call. The column variables are as follows:

• Protocol Type: indicates protocol type, either PT or PE
• QueueTime: Time in Queue, in seconds
• Service Time: Service Time, in seconds
• Perform a test of hypothesis to determine whether the average TiQ is lower than the industry standard of 2.5 minutes (150 seconds). Use a significance level of α=0.05.  
• Evaluate if the company should allocate more resources to improve its average TiQ.
• Perform a test of hypothesis to determine whether the average ST with service protocol PE is lower than with the PT protocol. Use a significance level of α=0.05.  
• Assess if the new protocol served its purpose. (Hint: this should be a test of means for 2 independent groups.)
• Submit your calculations and a 175-word summary of your conclusions.
•         

  QueueTime

  service time

• PE	43	976
  PE	151	33
  PE	57	35
  PE	715	39
  PE	45	41
  PE	97	43
  PE	239	43
  PE	33	48
  PE	31	48
  PE	299	49
  PE	27	50
  PE	189	50
  PE	51	51
  PE	71	52
  PE	57	56

Write the following two functions maintaining a database of entries of type person in a file. (see .h file for the definition of point) person* find_person(const char* file_name, int ID) The function gets a name of a file and searches the file for a person with the given ID. It returns a pointer to the struct person (on heap) with the name and ID of the person. If the file does not exist or if the person with the required ID is not in the file, the function returns the NULL pointer. The file should not be changed by this function. int add_person(const char* file_name, person p) The function gets a name of a file, and a person p. If the person with the same ID is already in the file, the function does nothing. If the person is not in the file, the function adds p to the file. If the file does not exist, a new file is created and the person is added to the file. The function returns 0 if the person is added to the file. The function returns 1 if the person has already been in the file. The function returns -1 if there was an error (e.g. error opening a file)

For each of the following research cases, search the FASB ASC database for information to address the issues. Copy and paste the FASB ASC paragraphs that support your responses. Then summarize briefly what your responses are, citing the paragraphs used to support your responses.

• FASB ASC 1-3 Accounting for the Investment Tax Credit

The accounting alternative treatments for the investment tax credit originally outlined in APB Opinions 2 and 4 are still considered GAAP. Find and cite the FASB ASC paragraphs and copy the relevant information.