## Archive for November, 2013

## GSCM 334 Mtls Resource & Cap Pln wLab Week All weeks DQs_Checkpoint_Homework_ Lab_Final Exam_Complete_Answer

**GSCM 334 Mtls Resource & Cap Pln wLab Week All weeks DQs_Checkpoint_Homework_ Lab_Final Exam_Complete_Answer**

**GSCM 334 Mtls Resource & Cap Pln wLab Week All weeks DQs_Checkpoint_Homework_ Lab_Final Exam_Complete_Answer **

For getting the solution, Please click on the “Purchase” link below to get GSCM 334 Mtls Resource & Cap Pln wLab Week All weeks DQs_Checkpoint_Homework_ Lab_Final Exam_Complete_Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

## QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

**QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer**

**QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer**

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_AnswerCase 5-2 Template

.“Refer to and use the following abbreviations for the problems below:

• R = Royalty Payment

• CT = Artist Credit Total

• SV = Share Value

• CV = Credit Value

• RP = Retail Price

• PD= Packaging Deduction

• R%=Royalty Percentage of Suggested Retail Price minus packaging

”1. Ziam wants to know how much his royalty will be for a song he has written. How will it be calculated? Write the steps or the formulas that will be used to calculate his royalty payment.

“Use the marked cells below to fill in the appropriate numbers for the variables (CV, SV, and R) to check your answer for the credit total.

”

3. Ziam quickly published another song, “Take Me There,” that is played even more often than “Going There.” If his first song earns 4,000 credits and his second song earns 6,000 credits, what will the royalty payment be from the two songs if the credit value remains at $3.50?

4. Ziam is considering an offer to perform his own songs on a CD to be titled “Waiting There.” In the past, he has written but not performed his music. If Ziam’s royalty is 0.12 of the suggested retail price of $15.00, but 0.25 of the retail price is deducted for packaging before Ziam’s royalty is calculated, how much will he receive for sale of the CD? Write your answer in the form of an equation and solve it.Case 6-2 Template

“Refer to and use the following abbreviations for the problems below:

• PS = Public Subscribers

• AD = Advertisers

• TC = Telephone Customers

• ISP = Internet Customers

• TOT = Total Customers”1. What percentage of the total does each of the four customer groups represent? Round to the nearest hundredth of a percent.

2. Minh’s data shows that on average only 4.6% of customers were purchasing complementary services available within Media Systems. By using his company’s services, Minh was projecting that these percentages would triple across all user groups within 1 year. a) How many customers would that equate to in total for each group? b) What would be the difference compared to current levels?

“Use the cells below to fill in the appropriate numbers for the variables (PS, AD, TC, ISP, current purchasing %, projected multiple factor, and % difference) to check your answers.

”3. Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers, 1,174; advertisers, 423; telephone service customers, 4,411; and ISP customers 823. a) What percentage of customers (round to two decimal places)complained within the last year in each category? b) If the CRM software were able to reduce complaints by 50% each year over the next 2 years, how many complaints would there be by category at the end of that time period? And c) What would the number of complaints at the end of 2 years represent on a percentage basis?

“Now use the cells below to fill in the appropriate numbers for the variables to check your answers.

”

For getting the above solution or instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

## QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

**QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer**

**QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer**

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_AnswerCase 5-2 Template

.“Refer to and use the following abbreviations for the problems below:

• R = Royalty Payment

• CT = Artist Credit Total

• SV = Share Value

• CV = Credit Value

• RP = Retail Price

• PD= Packaging Deduction

• R%=Royalty Percentage of Suggested Retail Price minus packaging

”1. Ziam wants to know how much his royalty will be for a song he has written. How will it be calculated? Write the steps or the formulas that will be used to calculate his royalty payment.

“Use the marked cells below to fill in the appropriate numbers for the variables (CV, SV, and R) to check your answer for the credit total.

”

3. Ziam quickly published another song, “Take Me There,” that is played even more often than “Going There.” If his first song earns 4,000 credits and his second song earns 6,000 credits, what will the royalty payment be from the two songs if the credit value remains at $3.50?

4. Ziam is considering an offer to perform his own songs on a CD to be titled “Waiting There.” In the past, he has written but not performed his music. If Ziam’s royalty is 0.12 of the suggested retail price of $15.00, but 0.25 of the retail price is deducted for packaging before Ziam’s royalty is calculated, how much will he receive for sale of the CD? Write your answer in the form of an equation and solve it.Case 6-2 Template

“Refer to and use the following abbreviations for the problems below:

• PS = Public Subscribers

• AD = Advertisers

• TC = Telephone Customers

• ISP = Internet Customers

• TOT = Total Customers”1. What percentage of the total does each of the four customer groups represent? Round to the nearest hundredth of a percent.

2. Minh’s data shows that on average only 4.6% of customers were purchasing complementary services available within Media Systems. By using his company’s services, Minh was projecting that these percentages would triple across all user groups within 1 year. a) How many customers would that equate to in total for each group? b) What would be the difference compared to current levels?

“Use the cells below to fill in the appropriate numbers for the variables (PS, AD, TC, ISP, current purchasing %, projected multiple factor, and % difference) to check your answers.

”3. Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers, 1,174; advertisers, 423; telephone service customers, 4,411; and ISP customers 823. a) What percentage of customers (round to two decimal places)complained within the last year in each category? b) If the CRM software were able to reduce complaints by 50% each year over the next 2 years, how many complaints would there be by category at the end of that time period? And c) What would the number of complaints at the end of 2 years represent on a percentage basis?

“Now use the cells below to fill in the appropriate numbers for the variables to check your answers.

”

For getting the above solution or instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@genietutorial.com

## QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

**QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer**

**QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer**

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_Answer

QRB 501_Week 2_r4_case_templates_Case 5-2 Case 6-2_Ziam wants to know how much his royalty_AnswerCase 5-2 Template

.“Refer to and use the following abbreviations for the problems below:

• R = Royalty Payment

• CT = Artist Credit Total

• SV = Share Value

• CV = Credit Value

• RP = Retail Price

• PD= Packaging Deduction

• R%=Royalty Percentage of Suggested Retail Price minus packaging

”1. Ziam wants to know how much his royalty will be for a song he has written. How will it be calculated? Write the steps or the formulas that will be used to calculate his royalty payment.

“Use the marked cells below to fill in the appropriate numbers for the variables (CV, SV, and R) to check your answer for the credit total.

”

3. Ziam quickly published another song, “Take Me There,” that is played even more often than “Going There.” If his first song earns 4,000 credits and his second song earns 6,000 credits, what will the royalty payment be from the two songs if the credit value remains at $3.50?

4. Ziam is considering an offer to perform his own songs on a CD to be titled “Waiting There.” In the past, he has written but not performed his music. If Ziam’s royalty is 0.12 of the suggested retail price of $15.00, but 0.25 of the retail price is deducted for packaging before Ziam’s royalty is calculated, how much will he receive for sale of the CD? Write your answer in the form of an equation and solve it.Case 6-2 Template

“Refer to and use the following abbreviations for the problems below:

• PS = Public Subscribers

• AD = Advertisers

• TC = Telephone Customers

• ISP = Internet Customers

• TOT = Total Customers”1. What percentage of the total does each of the four customer groups represent? Round to the nearest hundredth of a percent.

2. Minh’s data shows that on average only 4.6% of customers were purchasing complementary services available within Media Systems. By using his company’s services, Minh was projecting that these percentages would triple across all user groups within 1 year. a) How many customers would that equate to in total for each group? b) What would be the difference compared to current levels?

“Use the cells below to fill in the appropriate numbers for the variables (PS, AD, TC, ISP, current purchasing %, projected multiple factor, and % difference) to check your answers.

”3. Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers, 1,174; advertisers, 423; telephone service customers, 4,411; and ISP customers 823. a) What percentage of customers (round to two decimal places)complained within the last year in each category? b) If the CRM software were able to reduce complaints by 50% each year over the next 2 years, how many complaints would there be by category at the end of that time period? And c) What would the number of complaints at the end of 2 years represent on a percentage basis?

“Now use the cells below to fill in the appropriate numbers for the variables to check your answers.

”

For getting the above solution or instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

## QRB 501_Week 3_r4_The Artist’s Palette purchases its inventory from a number of suppliers Case 8-3 Case 9-1 Template Answer

**QRB 501_Week 3_r4_The Artist’s Palette purchases its inventory from a number of suppliers Case 8-3 Case 9-1 Template Answer**

**QRB 501_Week 3_r4_The Artist’s Palette purchases its inventory from a number of suppliers Case 8-3 Case 9-1 Template Answer**

QRB 501_Week 3_r4_The Artist’s Palette purchases its inventory from a number of suppliers Case 8-3 Case 9-1 Template AnswerCase 8-3 Template

“Refer to and use the following abbreviations for the problems below:

• PP = Parma minimum supply purchase

• S1 = Supplier 1

• S2 = Supplier 2

• CDF = Chain Discount Factor

• NP = Net Price

• NDE = Net Decimal Equivalent

• TD = Trade Discount”1. The Artist’s Palette purchases its inventory from a number of suppliers and each supplier offers different purchasing discounts. The manager of The Artist’s Palette, Marty Parma, is currently comparing two offers for purchasing modeling clay and supplies. The first company offers a chain discount of 20/10/5, and the second company offers a chain discount of 18/12/7 as long as the total purchases are $300 or more. Assuming Parma purchases $300 worth of supplies, a) what is the net price from supplier 1? And b) From supplier 2? And c) From which supplier would you recommend Parma purchase her modeling clay and supplies?

2. What is the net decimal equivalent for supplier 1? For supplier 2?

3. What is the trade discount from supplier 1? From supplier 2?

4. The Artist’s Palette recognizes that students may purchase supplies at the beginning of the term to cover all of their art class needs. Because this could represent a fairly substantial outlay, the Artist’s Palette offers discounts to those students who pay sooner than required. Assume that if students buy more than $250 of art supplies in one visit, they may put it on a student account with terms of 2/10, n/30. If a student purchases $250 of supplies on September 16, what amount is due by September 26? How much would the student save by paying early?

5. Assume that if students buy more than $250 of art supplies in one visit, they may put the charge on a student account with terms of 2/10 EOM. If a student makes the purchase on September 16, on what day does the 2% discount expire? If the purchase is made on September 26, on what day does the 2% discount expire? If you were an art student, which method would you prefer: 2/10, n/30, or 2/10 EOM?

Case 9-1 Template“Refer to and use the following abbreviations for the problems below:

• BT = Box of tea

• S&H = Shipping and handling

• P = Desired profit per box of tea

• RFP = Rice-filled pad”

1. What is the markup percentage for a box of ginger tea?

2. If the rice-filled heating pads sell for $7.00, $10.00, and $15.00 for small, medium, and large, respectively, what is the markup percentage on each one?

3. Karen wants to compare using the cost plus method to the percentage markup method. If she sells 2 small rice pads, 4 medium rice pads, 2 large rice pads, and 20 boxes of $3.50 tea in a month, how much profit does she accumulate? What markup percentage based on cost would she have to use to make the same amount of profit on this month’s sales?

“Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.

”

4. What prices should Karen charge (using the markup percentage) to obtain the same amount of profit as she did with the cost plus method? Do not include shipping.

QRB 501_Week 3_r4_The Artist’s Palette purchases its inventory from a number of suppliers Case 8-3 Case 9-1 Template AnswerCase 8-3 Template

“Refer to and use the following abbreviations for the problems below:

• PP = Parma minimum supply purchase

• S1 = Supplier 1

• S2 = Supplier 2

• CDF = Chain Discount Factor

• NP = Net Price

• NDE = Net Decimal Equivalent

• TD = Trade Discount”1. The Artist’s Palette purchases its inventory from a number of suppliers and each supplier offers different purchasing discounts. The manager of The Artist’s Palette, Marty Parma, is currently comparing two offers for purchasing modeling clay and supplies. The first company offers a chain discount of 20/10/5, and the second company offers a chain discount of 18/12/7 as long as the total purchases are $300 or more. Assuming Parma purchases $300 worth of supplies, a) what is the net price from supplier 1? And b) From supplier 2? And c) From which supplier would you recommend Parma purchase her modeling clay and supplies?

2. What is the net decimal equivalent for supplier 1? For supplier 2?

3. What is the trade discount from supplier 1? From supplier 2?

4. The Artist’s Palette recognizes that students may purchase supplies at the beginning of the term to cover all of their art class needs. Because this could represent a fairly substantial outlay, the Artist’s Palette offers discounts to those students who pay sooner than required. Assume that if students buy more than $250 of art supplies in one visit, they may put it on a student account with terms of 2/10, n/30. If a student purchases $250 of supplies on September 16, what amount is due by September 26? How much would the student save by paying early?

5. Assume that if students buy more than $250 of art supplies in one visit, they may put the charge on a student account with terms of 2/10 EOM. If a student makes the purchase on September 16, on what day does the 2% discount expire? If the purchase is made on September 26, on what day does the 2% discount expire? If you were an art student, which method would you prefer: 2/10, n/30, or 2/10 EOM?

Case 9-1 Template“Refer to and use the following abbreviations for the problems below:

• BT = Box of tea

• S&H = Shipping and handling

• P = Desired profit per box of tea

• RFP = Rice-filled pad”

1. What is the markup percentage for a box of ginger tea?

2. If the rice-filled heating pads sell for $7.00, $10.00, and $15.00 for small, medium, and large, respectively, what is the markup percentage on each one?

3. Karen wants to compare using the cost plus method to the percentage markup method. If she sells 2 small rice pads, 4 medium rice pads, 2 large rice pads, and 20 boxes of $3.50 tea in a month, how much profit does she accumulate? What markup percentage based on cost would she have to use to make the same amount of profit on this month’s sales?

“Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.

”

4. What prices should Karen charge (using the markup percentage) to obtain the same amount of profit as she did with the cost plus method? Do not include shipping.

## Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

**Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer**

**Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer**

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer1. Two mutually exclusive investments cost $10,000 each and have the following cash inflows. The firm’s cost of capital is 12%.

Investment

Cash inflow A B

Year 1 $12,407 —

Year 2 — —

Year 3 —

Year 4 — $19,390

A. What is the net present value of each investment?

B. What is the internal rate of return of each investment?

C. Which investment(s) should the firm make?

D. Would your answers be different to C if the funds received in Year 1 for investment A could be reinvested at 16%? Show your work.2. Given the following information, answer the following questions:

TR = $3Q

TC = $1,500 + $2Q

A. What is the break-even level of output?

B. If the firm sells 1,300 units, what are its earnings or losses?

C. If sales rise to 2,000 units, what are the firm’s earnings or losses?

D. If the total cost equation were TC = $2,000 + $1.80Q,

what happens to the break-even level of output units?3. Determine the current market prices of the following $1,000

bonds if the comparable rate is 10% and answer the following questions.

XY 5.25% (interest paid annually) for 20 years

AB 14% (interest paid annually) for 20 years

A. Which bond has a current yield that exceeds the yield to maturity?

B. Which bond may you expect to be called? Why?

C. If CD, Inc., has a bond with a 5.25% coupon and a maturity of 20 years but which was lower rated, what would be its price relative to the XY, Inc., bond? Explain.

Bond XY Bond ABRate 10% Rate 10%

NPER 20 NPER 20

PMT 52.5 PMT 140

FV 1000 FV 1000

PV $595.61 PV $1,340.54A. Which bond has a current yield that exceeds the yield to maturity?

B. Which bond may you expect to be called? Why?

C. If CD, Inc., has a bond with a 5.25% coupon and a maturity of 20 years but which was lower rated, what would be its price relative to the XY, Inc., bond? Explain.

Part C: Select the one best answer to each question. Each answer is worth 4 points.

1. An investor may place a limit order that

A.limits the amount of commissions.

B.specifies when the stock will be purchased.

C.establishes the exchange on which the security is to be bought or sold.D.states a price at which the investor seeks to buy or sell the stock.

2. Which of the following is not a financial intermediary?

A.New York Stock Exchange

B.Washington Savings and Loan

C.First National City Bank

D.Merchants Savings Bank

3. Using accelerated depreciation

A.initially increases the firm’s profits.

B.initially decreases the firm’s taxes.

C.discourages investment in plant and equipment.

D. increases expenses and decreases cash flow.

4. The current yield on a bond is

A.interest paid divided by the bond’s price.

B.the bond’s coupon.

C.the interest rate stated on the bond.

D.the yield over the lifetime of the bond.

5. The increased use of financial leverage may

I. affect the firm’s credit rating.

II. decrease risk.

III. alter the firm’s earnings.

A.I and II

B.I and III

C.II and III

D.I, II, and III

Part D: Solve each of the following problems. Each answer is worth 5 points.

1. If a new college graduate wants a car costing $15,000, how much must be saved annually over the next four years if the funds earn 5%?FV = 15000

NPER = 4

Rate = 5%

PMT = ?2. You purchase a bond for $875. It pays $80 a year (that is, the semiannual coupon is 4%), and the bond matures after 10 years. What is the yield to maturity?

## Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

**Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer**

**Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer**

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer

Two mutually exclusive investments cost $10,000 each and have the following cash inflows_Answer1. Two mutually exclusive investments cost $10,000 each and have the following cash inflows. The firm’s cost of capital is 12%.

Investment

Cash inflow A B

Year 1 $12,407 —

Year 2 — —

Year 3 —

Year 4 — $19,390

A. What is the net present value of each investment?

B. What is the internal rate of return of each investment?

C. Which investment(s) should the firm make?

D. Would your answers be different to C if the funds received in Year 1 for investment A could be reinvested at 16%? Show your work.2. Given the following information, answer the following questions:

TR = $3Q

TC = $1,500 + $2Q

A. What is the break-even level of output?

B. If the firm sells 1,300 units, what are its earnings or losses?

C. If sales rise to 2,000 units, what are the firm’s earnings or losses?

D. If the total cost equation were TC = $2,000 + $1.80Q,

what happens to the break-even level of output units?3. Determine the current market prices of the following $1,000

bonds if the comparable rate is 10% and answer the following questions.

XY 5.25% (interest paid annually) for 20 years

AB 14% (interest paid annually) for 20 years

A. Which bond has a current yield that exceeds the yield to maturity?

B. Which bond may you expect to be called? Why?

C. If CD, Inc., has a bond with a 5.25% coupon and a maturity of 20 years but which was lower rated, what would be its price relative to the XY, Inc., bond? Explain.

Bond XY Bond ABRate 10% Rate 10%

NPER 20 NPER 20

PMT 52.5 PMT 140

FV 1000 FV 1000

PV $595.61 PV $1,340.54A. Which bond has a current yield that exceeds the yield to maturity?

B. Which bond may you expect to be called? Why?

C. If CD, Inc., has a bond with a 5.25% coupon and a maturity of 20 years but which was lower rated, what would be its price relative to the XY, Inc., bond? Explain.

Part C: Select the one best answer to each question. Each answer is worth 4 points.

1. An investor may place a limit order that

A.limits the amount of commissions.

B.specifies when the stock will be purchased.

C.establishes the exchange on which the security is to be bought or sold.D.states a price at which the investor seeks to buy or sell the stock.

2. Which of the following is not a financial intermediary?

A.New York Stock Exchange

B.Washington Savings and Loan

C.First National City Bank

D.Merchants Savings Bank

3. Using accelerated depreciation

A.initially increases the firm’s profits.

B.initially decreases the firm’s taxes.

C.discourages investment in plant and equipment.

D. increases expenses and decreases cash flow.

4. The current yield on a bond is

A.interest paid divided by the bond’s price.

B.the bond’s coupon.

C.the interest rate stated on the bond.

D.the yield over the lifetime of the bond.

5. The increased use of financial leverage may

I. affect the firm’s credit rating.

II. decrease risk.

III. alter the firm’s earnings.

A.I and II

B.I and III

C.II and III

D.I, II, and III

Part D: Solve each of the following problems. Each answer is worth 5 points.

1. If a new college graduate wants a car costing $15,000, how much must be saved annually over the next four years if the funds earn 5%?FV = 15000

NPER = 4

Rate = 5%

PMT = ?2. You purchase a bond for $875. It pays $80 a year (that is, the semiannual coupon is 4%), and the bond matures after 10 years. What is the yield to maturity?

## Assume that at Pine Valley Furniture products are composed of components_Answer

**Assume that at Pine Valley Furniture products are composed of components_Answer**

**Assume that at Pine Valley Furniture products are composed of components_Answer**

Assume that at Pine Valley Furniture products are composed of components_Answer

Assume that at Pine Valley Furniture products are composed of components_Answer

Assume that at Pine Valley Furniture products are composed of components_Answer

Assume that at Pine Valley Furniture products are composed of components_AnswerAnswer the following questions (please copy the question’s text before each of your answers) and submit them to your professor for grading.

1. Assume that at Pine Valley Furniture products are composed of components, products are assigned to salespersons, and components are produced by vendors. Also assume that in the relation PRODUCT (Prodname, Salesperson, Compname, Vendor), Vendor is functionally dependent on Compname and Compname is functionally dependent on Prodname. Eliminate the transitive dependency in this relation and form 3NF (third normal form) relations.

2. Transform the E-R diagram of Figure 8-3 into a set of 3NF relations. Make up a primary key and one or more non-keys for each entity.

3. Transform the E-R diagram of Figure 9-21 into a set of 3NF relations.

4. Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities.

PATIENT(Patient_ID, Room_Number, Admit_Date, Address)

ROOM(Room_Number, Phone, Daily_Rate)

PATIENT(Patient_Number, Treatment_Description, Address)

TREATMENT(Treatment_ID, Description, Cost)

PHYSICIAN(Physician_ID, Name, Department)

PHYSICIAN(Physician_ID, Name, Supervisor_ID)

(a) Merge these relations into a consolidated set of 3NF relations. State whatever assumptions you consider necessary to resolve any potential problems you identify in the merging process. (b) Draw an E-R diagram for your answer to part “a”.

5. Consider the following 3NF relations about a sorority or fraternity:

MEMBER(Member_ID, Name, Address, Dues_Owed)

OFFICE(Office_Name, Officer_ID, Term_Start_Date, Budget)

EXPENSE(Ledger_Number, Office_Name, Expense_Date, Amt_Owed)

PAYMENT(Check_Number, Expense_Ledger_Number, Amt_Paid)

RECEIPT(Member_ID, Receipt_Date, Dues_Received)

COMMITTEE(Committee_ID, Officer_in_Charge)

WORKERS(Committee_ID, Member_ID)

(a) Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions. (b) Draw an E-R diagram for these relations, using your answer to part “a”. (c) Explain the assumptions you made about cardinalities in your answer to part “b”. Explain why it is said that the E-R data model is more expressive or more semantically rich than the relational data model.

6. Consider the following functional dependencies:

Applicant_ID –> Applicant_Name

Applicant_ID –> Applicant_Address

Position_ID –> Position_Title

Position_ID –> Date_Position_Opens

Position_ID –> Department

Applicant_ID + Position_ID –> Date_Applied

Applicant_ID + Position_ID + Date_Interviewed –> (Nothing)

(a) Represent these attributes with 3NF relations. Provide meaningful relation names. (b) Represent these attributes using an E-R diagram. Provide meaningful entity and relationship names.

7. Suppose you were designing a file of student records for your university’s placement office. One of the fields that would likely be in this file is the student’s major. Develop a coding scheme for this field that achieves the objectives outlined in Chapter 10 for field coding.

8. Suppose you created a file for each relation in your answer to question “3” above. If the following queries represented the complete set of accesses to this database, suggest and justify what primary and secondary key indices you would build.

(a) For each PART in Item_Number order list in Vendor_ID, sequence all the vendors and their associated prices for that part. (b) List all PART RECEIPTs, including related PART fields for all the parts received on a particular day. (c) For a particular VENDOR, list all the PARTs and their associated prices that VENDOR can supply.

## Assume that at Pine Valley Furniture products are composed of components_Answer

**Assume that at Pine Valley Furniture products are composed of components_Answer**

**Assume that at Pine Valley Furniture products are composed of components_Answer**

Assume that at Pine Valley Furniture products are composed of components_Answer

Assume that at Pine Valley Furniture products are composed of components_Answer

Assume that at Pine Valley Furniture products are composed of components_Answer

Assume that at Pine Valley Furniture products are composed of components_AnswerAnswer the following questions (please copy the question’s text before each of your answers) and submit them to your professor for grading.

1. Assume that at Pine Valley Furniture products are composed of components, products are assigned to salespersons, and components are produced by vendors. Also assume that in the relation PRODUCT (Prodname, Salesperson, Compname, Vendor), Vendor is functionally dependent on Compname and Compname is functionally dependent on Prodname. Eliminate the transitive dependency in this relation and form 3NF (third normal form) relations.

2. Transform the E-R diagram of Figure 8-3 into a set of 3NF relations. Make up a primary key and one or more non-keys for each entity.

3. Transform the E-R diagram of Figure 9-21 into a set of 3NF relations.

4. Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities.

PATIENT(Patient_ID, Room_Number, Admit_Date, Address)

ROOM(Room_Number, Phone, Daily_Rate)

PATIENT(Patient_Number, Treatment_Description, Address)

TREATMENT(Treatment_ID, Description, Cost)

PHYSICIAN(Physician_ID, Name, Department)

PHYSICIAN(Physician_ID, Name, Supervisor_ID)

(a) Merge these relations into a consolidated set of 3NF relations. State whatever assumptions you consider necessary to resolve any potential problems you identify in the merging process. (b) Draw an E-R diagram for your answer to part “a”.

5. Consider the following 3NF relations about a sorority or fraternity:

MEMBER(Member_ID, Name, Address, Dues_Owed)

OFFICE(Office_Name, Officer_ID, Term_Start_Date, Budget)

EXPENSE(Ledger_Number, Office_Name, Expense_Date, Amt_Owed)

PAYMENT(Check_Number, Expense_Ledger_Number, Amt_Paid)

RECEIPT(Member_ID, Receipt_Date, Dues_Received)

COMMITTEE(Committee_ID, Officer_in_Charge)

WORKERS(Committee_ID, Member_ID)

(a) Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions. (b) Draw an E-R diagram for these relations, using your answer to part “a”. (c) Explain the assumptions you made about cardinalities in your answer to part “b”. Explain why it is said that the E-R data model is more expressive or more semantically rich than the relational data model.

6. Consider the following functional dependencies:

Applicant_ID –> Applicant_Name

Applicant_ID –> Applicant_Address

Position_ID –> Position_Title

Position_ID –> Date_Position_Opens

Position_ID –> Department

Applicant_ID + Position_ID –> Date_Applied

Applicant_ID + Position_ID + Date_Interviewed –> (Nothing)

(a) Represent these attributes with 3NF relations. Provide meaningful relation names. (b) Represent these attributes using an E-R diagram. Provide meaningful entity and relationship names.

7. Suppose you were designing a file of student records for your university’s placement office. One of the fields that would likely be in this file is the student’s major. Develop a coding scheme for this field that achieves the objectives outlined in Chapter 10 for field coding.

8. Suppose you created a file for each relation in your answer to question “3” above. If the following queries represented the complete set of accesses to this database, suggest and justify what primary and secondary key indices you would build.

(a) For each PART in Item_Number order list in Vendor_ID, sequence all the vendors and their associated prices for that part. (b) List all PART RECEIPTs, including related PART fields for all the parts received on a particular day. (c) For a particular VENDOR, list all the PARTs and their associated prices that VENDOR can supply.