The tbl_employee contains information about the employee and its department, and it contains the following fields (it is possible to also include other missing fields): employee_id, employee_gender ,employee_salary, employee_annual_sallary, department_name, department_location, department head.

Make use of the database normalization skills learned to normalize a database to the third normalization form. Organize the columns and tables to reduce data redundancy and arrange attributes based on the relationships.

• Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
• Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
• In more than 400 words, describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms.

A federal watchdog is investigating an advertising claim that a certain device reduces gasoline consumption in cars. Seven devices have been tested and installed in cars belonging to the institution. To compare performance under standard conditions, the miles each car travels with a gallon of gasoline are measured in both situations, before and after installation.

Would you say that the federal monitoring body has conclusively proven that the device has no effect on the performance of cars?

Formulate the appropriate null hypothesis and alternative, with a α = 0.025. Your work should have detailed procedure and appropriate analysis.

Refi Corporation is planning to repurchase part of its common stock by issuing corporate debt. As a result, the firm’s debt-equity ratio is expected to rise from 35 percent to 50 percent. The firm currently has $3.1 million worth of debt outstanding. The cost of this debt is 8 percent per year. The firm expects to have an EBIT of $1.3 million per year in perpetuity and pays no taxes. A.) What is the market value of the firm before and after the repurchase announcement? B.) What is the expected return on the firm’s equity before the announcement of the stock repurchase plan? C.) What is the expected return on the equity of an otherwise identical all-equity firm? D.) What is the expected return on the firm’s equity after the announcement of the stock repurchase plan?

A number of minor automobile accidents occur at various high-risk intersections in York county despite the traffic lights. The traffic department claims that a modification in the type of light will reduce these accidents. The county commissioners have agreed to a proposed experiment. Eight intersections were chosen at random, and lights at those intersections were modified. The number of minor accidents during a six-months periods before and after the modifications were

At the .01 significance level, it is reasonable to conclude that the modifications reduced the number of traffic accidents?

A high school is examining whether or not a certain college admissions test prep course is helpful. To evaluate this, 15 students took the college admissions test. Afterwards, they went through the prep course and then took the admissions test again. Their before and after scores are shown below. With a significance level of 0.90, is the admissions test prep course effective?

Student Before After

1 27 29

2 28 29

3 30 31

4 32 31

5 16 20

6 25 27

7 27 27

8 25 26

9 27 30

10 23 28

11 25 26

12 24 24

13 22 25

14 31 32

15 25 25

A certain drug is tested for its effect on blood pressure. Seven male patients have their systolic blood pressure measured before and after receiving the drug with the results shown below (in mm Hg).

                                    Patient                SBP before       SBP after

                                         1                          120                  125

                                         2                          124                  126

                                         3                          130                  138

                                         4                          118                  117

                                         5                          140                  143

                                         6                          128                  128

                                         7                          140                  146

a. (2) State, in prose, the study hypothesis (two-tailed).

b. (2) What test statistic(s) test would you use?

c. (2) What is the critical value of the test statistic?

d. (3) If the value of the test statistic is t = 2.67, what do you conclude (reject/do not reject is not sufficient).

Mavis corporation has 75,000 shares of $1 par value stock outstandiing. The largest single stockholders is Lennox Bing, who owns 6,000 shares. On December 31, the total assets of the company amount to $4,360,000 and total liabilities to $2,230,000. On that day, the board of directors declared a stock dividend of one new share for each five shares outstanding. Compute the following: Book value per share before the stock dividend:( ) Book value per share after the stock dividend ( ) Total book value of Lennox Bing's stockholdings before the dividend ( ) Total book value of Lennox Bing's stockholdings after the dividend ( ) Prepare the stockholder's equity section of the Mavis Corporation balance sheet assuming that retained earning is $1,650,000 and there are no perferred stocks.

A team of health research wants to investigate whether having regular lunch break improves working adults’ sleep. A group of 85 adults with a full-time job were recruited in the study, they reported average hours of sleep in the past week, committed to having a 1-hour, out-of-office, work-free lunch break each day for 3 months, and, at the end of the study, reported average hours of sleep in the past week. The mean difference in hours of sleep before and after the study was 3 with a standard deviation of 0.9. Which one of the following statements is INCORRECT? (Set alpha level at 0.05.)

For C++ Use arrays and or vectors, no classes.

Visualize and consider 100 lockers all lined up horizontally in a row
Each locker is numbered from 1 to 100 in sequential order

Every locker can be fully closed (open state = 0.00)
Every locker can be fully opened (open = 1.00)
Every locker can be partially open with any possible value between 0.00 and 1.00 inclusive on both ends
A locker cannot ever be more closed than fully closed (open cannot be less than 0.00)
A locker cannot ever be more open than fully opened (open cannot be greater than 1.00)

All 100 lockers start in the fully closed state
100 students will be walking by the lockers and opening/closing them in the following manner:

The 1st student will OPEN EVERY LOCKER       1/2 of the way (ADD 0.50 TO LOCKERS 1,2,3,4...)

The 2nd student will CLOSE EVERY SECOND LOCKER 1/3 of the way (SUBTRACT 0.333333333333 FROM LOCKERS 2,4,6,8...)

The 3rd student will OPEN EVERY THIRD LOCKER   1/4 of the way (ADD 0.25 TO LOCKERS 3,6,9,12...)

The 4th student will CLOSE EVERY FOURTH LOCKER 1/5 of the way (SUBTRACT 0.20 FROM LOCKERS 4,8,12,16...)

The 5th student will OPEN EVERY FIFTH LOCKER   1/6 of the way (ADD 0.166666666666 TO LOCKERS 5,10,15,20...)

The 6th student will CLOSE EVERY SIXTH LOCKER 1/7 of the way (SUBTRACT 0.142857142857 FROM LOCKERS 6,12,18,24...)

The 99th student will OPEN EVERY 99TH LOCKER   1/100 of the way (ADD 0.01 TO LOCKER 99)

The 100th student will CLOSE EVERY 100TH LOCKER 1/101 of the way (SUBTRACT 0.009900990099 FROM LOCKER 100)

NOTE: Remember that the locker open state must always stay within 0.00 <= value <= 1.00

1) Develop C++ code that will generate the open state values for all 100 lockers

2) Also develop C++ code that will output answers to the following questions:

Which lockers are left fully closed (open state == 0.00)?

Which lockers are left fully open (open state == 1.00)?

Which locker is the one opened the least and what is its value (open state closest to 0.00)?

Which locker is the one closed the least and what is its value (open state closest to 1.00)?