Consider the database of a car rental company that contains three tables drivers, cars and reservation tables.

Drivers:                                           Reservation:                              Cars:

1. Write DDL statements to create the tables

Drivers(Dno, Dname, age)

Reservation(Dno, Cno, Day)

Cars(Cno, Cmake, Color)

Where:

• no field could be empty except the age of the Driver.
• The company does not own more than one car from one maker     
• the colors of the cars should not be other than the following group (blue, white, red , green)

2. Write Queries for the following:
   1. Insert the sample data shown above into the tables

3. Write Queries for the following:
   1. Find the names of drivers who have reserved car no 103.
   2. Find the names of Drivers who have reserved red or Green cars.( use IN, UNION, =SOME/=ALL, and JION    each in separate query)For this segment, 4 responses are required, using the operations shown in parentheses
   3. Find the driver Dno of drivers with age over 20 who have not reserved a read car.
   4. Find the names of drivers who have reserved all cars.
   5. List the name of the drivers along with the day they rent cars in descending order
   6. List the name of the drivers whom rent more than 3 times along with the number of the times.
   7. Change the age of Alice to 18 years old
   8. Delete the information of the drivers younger than 20 years old

Consider the database of a car rental company that contains three tables drivers, cars and reservation tables.

Drivers:                                           Reservation:                              Cars:

1. Write DDL statements to create the tables

Drivers(Dno, Dname, age)

Reservation(Dno, Cno, Day)

Cars(Cno, Cmake, Color)

Where:

• no field could be empty except the age of the Driver.
• The company does not own more than one car from one maker     
• the colors of the cars should not be other than the following group (blue, white, red , green)

2. Write Queries for the following:
   1. Insert the sample data shown above into the tables

3. Write Queries for the following:
   1. Find the names of drivers who have reserved car no 103.
   2. Find the names of Drivers who have reserved red or Green cars.( use IN, UNION, =SOME/=ALL, and JION    each in separate query)For this segment, 4 responses are required, using the operations shown in parentheses
   3. Find the driver Dno of drivers with age over 20 who have not reserved a read car.
   4. Find the names of drivers who have reserved all cars.
   5. List the name of the drivers along with the day they rent cars in descending order
   6. List the name of the drivers whom rent more than 3 times along with the number of the times.
   7. Change the age of Alice to 18 years old
   8. Delete the information of the drivers younger than 20 years old

A person is both myopic and hyperopic. He can see objects clearly only if they are between 30.5 cmcm and 80.0 cmcm .

Part A

What power of contact lens is required to read at the normal near point of 25 cm?

Express your answer using three significant figures.

Part B

What power of contact lens is required to see a distant oobject clearly?

Express your answer using three significant figures.

Exothermic Vs. Endothermic Reaction

Reaction progress diagrams for single-step endothermic and exothermic reactions.

a. Devise a general statement about the relationship between Ea and the rate of a reaction. 


b. Describe the effect of temperature on the energy of collisions, and explain how this effect changes the rate of a reaction. 


c. State three things that resulted in an increase in the rate of the reaction. For each of the three things, explain at a molecular level what happens to cause the rate of the reaction to increase. 


A. Answer the following questions: Describe the two general roles of an operating system

and elaborate why these roles are important.

B. What is a process? What are attributes of a process?

C. Describe the three state process model, describe what transitions are valid between the

three states, and describe an event that might cause such a transition.

D. What is the function of the ready queue?

E.. What is the producer consumer problem? Give an example of its occurrence in operating

systems.

(1 point) The distribution of actual weights of 8-oz chocolate bars produced by a certain machine is normal with mean 8 ounces and standard deviation 0.13 ounces.

(a) What is the probability that the average weight of a bar in a Simple Random Sample (SRS) with three of these chocolate bars is between 7.9 and 8.16 ounces? ANSWER:

(b) For a SRS of three of these chocolate bars, what is the level L such that there is a 4% chance that the average weight is less than L? ANSWER:

A manufacturer of microwaves has discovered that female shoppers have little value for microwaves and attribute almost no extra value to an auto-defrost feature. Male shoppers generally value microwaves more than women do and attribute greater value to the auto-defrost feature. There is little additional cost to incorporating an auto-defrost feature. Since men and women cannot be charged different prices for the same product, the manufacturer is considering introducing two different models. The manufacturer has determined that men value a simple microwave at $67 and one with auto-defrost at $124, while women value a simple microwave at $57 and one with auto-defrost at $67.

Suppose the manufacturer is considering three pricing strategies:

For simplicity, assume there is only 1 man and 1 woman and that if the price of a microwave is equal to an individual's willingness to pay, the individual will purchase the microwave.

Strategy

Revenue from Men

Revenue from Women

Total Revenue from Strategy

1. Auto-Defrost Microwave only at $67

2. Auto-Defrost Microwave only at $1243. Simple Microwave at $57, Auto-Defrost Microwave at $113

Suppose that, instead of one man and one woman, the market for this microwave consisted entirely of men. For simplicity, you can assume this means that there are two men, and no women.

Under these conditions, pricing strategy   would maximize revenue for the manufacturer.

The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow.

a. Use  to test the hypotheses

and/or  is not equal to zero

for the model , where

television advertising

newspaper advertising

Compute the  test statistic (to 2 decimals). Use F table.

What is the -value?

- Select your answer -less than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 2

What is your conclusion?

- Select your answer -The overall model is not significantThe overall model is significantItem 3

b. Use  to test the significance of . Compute the  test statistic (to 2 decimals). Use t table.

What is the -value?

- Select your answer -less than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and .40greater than .40Item 5

What is your conclusion?

- Select your answer -No significant relationship between television advertising and revenueSignificant relationship between television advertising and revenueItem 6

Should  be dropped from the model?

- Select your answer -No, x1 should not be dropped from the modelYes, x1 should be dropped from the modelItem 7

c. Use  to test the significance of . Compute the  test statistic (to 2 decimals). Use t table.

What is the -value?

- Select your answer -less than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and .40greater than .40Item 9

What is your conclusion?

- Select your answer -No significant relationship between newspaper advertising and revenueSignificant relationship between newspaper advertising and revenueItem 10

Should  be dropped from the model?

ForestLand Wood Products manufactures lumber and wood components. The company has two main product lines: Hardwood and Softwood. Hardwoods are used for flooring, cabinetry, paneling, doors and trimwork. Softwoods are used for wall studs, joists, planks, rafters, beams, stringers, posts, decking, subflooring and concrete forms. ForestLand also sells a by-product, wood shavings and saw dust. Shavings are purchased for farm and industrial use as well as for further processing into wood pellets and fiber board. The revenue is allocated to each product line based on the percentage of thousand board feet produced by the product line.

Your accounting firm has been retained by ForestLand for three years. You have been assigned to properly allocate support department costs. Your manager wants the allocation to be as accurate as possible and has instructed you to use the reciprocal services method. She reminds you that revenue from by-products are used to offset costs.

You begin your research and learn that there are four production departments: log yard, milling, drying, and packaging. The Hardwood line produces 300 thousand board feet of product while the Softwood produces 900 thousand board feet. The milling department direct costs, direct labor and overhead per thousand board feet for Hardwood is two times that of Softwood. You have been instructed to use the weighted average method to allocate the costs in the milling department between the two product lines. The remaining department costs are the same for both product lines, per thousand board feet.

There are two support departments: maintenance and administration. The maintenance department is responsible for maintaining all equipment and janitorial duties. Because the equipment is used more extensively for hardwoods, the department cost driver is hours worked. The administration department includes the company president and his staff. Their duties include accounting, human resources, and information technology. The cost driver for the administration department is number of employees.

In your first step, you determine the costs traced to each department and the usage of the support department cost drivers. You have created the following table:

Your next step is to determine the proportional usage of each support department's cost driver by the other departments to which its costs are to be allocated. Complete the following tables.

Using the cells below, create the formulas that will simultaneously allocate support department costs among the departments. "M" represents Maintenance and "A" represents Administration.

M = $ + (%  )

A = $ + (%  )

Solve the equations, If required round any decimal to three places in your computations. For example, .0183 would be rounded to .018. Round your final answer to the nearest dollar.

M = $

A = $

Use the following table to allocate the support cost departments. Round allocated amounts to the nearest whole dollar. If an amount is zero, enter "0".

Using the rounded amounts from the support cost allocation table (previous task), complete the following table to allocate the production department costs to each product line. Round allocated amounts to the nearest whole dollar.

Forest Land earns revenue of $100,000 from selling its by-products, wood shavings and saw dust. Allocate the revenue to each product line in the following table and determine the final cost per product line.

ForestLand Wood Products manufactures lumber and wood components. The company has two main product lines: Hardwood and Softwood. Hardwoods are used for flooring, cabinetry, paneling, doors and trimwork. Softwoods are used for wall studs, joists, planks, rafters, beams, stringers, posts, decking, subflooring and concrete forms. ForestLand also sells a by-product, wood shavings and saw dust. Shavings are purchased for farm and industrial use as well as for further processing into wood pellets and fiber board. The revenue is allocated to each product line based on the percentage of thousand board feet produced by the product line.

Your accounting firm has been retained by ForestLand for three years. You have been assigned to properly allocate support department costs. Your manager wants the allocation to be as accurate as possible and has instructed you to use the reciprocal services method. She reminds you that revenue from by-products are used to offset costs.

You begin your research and learn that there are four production departments: log yard, milling, drying, and packaging. The Hardwood line produces 300 thousand board feet of product while the Softwood produces 900 thousand board feet. The milling department direct costs, direct labor and overhead per thousand board feet for Hardwood is two times that of Softwood. You have been instructed to use the weighted average method to allocate the costs in the milling department between the two product lines. The remaining department costs are the same for both product lines, per thousand board feet.

There are two support departments: maintenance and administration. The maintenance department is responsible for maintaining all equipment and janitorial duties. Because the equipment is used more extensively for hardwoods, the department cost driver is hours worked. The administration department includes the company president and his staff. Their duties include accounting, human resources, and information technology. The cost driver for the administration department is number of employees.

In your first step, you determine the costs traced to each department and the usage of the support department cost drivers. You have created the following table:

Your next step is to determine the proportional usage of each support department's cost driver by the other departments to which its costs are to be allocated. Complete the following tables.

Using the cells below, create the formulas that will simultaneously allocate support department costs among the departments. "M" represents Maintenance and "A" represents Administration.

M = $ + (% A )

A = $ + (% M )

Solve the equations, If required round any decimal to three places in your computations. For example, .0183 would be rounded to .018. Round your final answer to the nearest dollar.

M = $

A = $

Use the following table to allocate the support cost departments. Round allocated amounts to the nearest whole dollar. If an amount is zero, enter "0".

Using the rounded amounts from the support cost allocation table (previous task), complete the following table to allocate the production department costs to each product line. Round allocated amounts to the nearest whole dollar.

Forest Land earns revenue of $100,000 from selling its by-products, wood shavings and saw dust. Allocate the revenue to each product line in the following table and determine the final cost per product line.