In each of these exercises, consider the relation, CKs, and FDs. Determine if the relation is in BCNF, and if not in BCNF give a non-loss decomposition into BCNF relations. The last 5 questions are abstract and give no context for the relation nor attributes.

1. Consider a relation Player which has information about players for some sports league. Player has attributes id, first, last, gender. id is the only CK and the FDs are:
idfirst
idlast
idgender

Player-sample data

2.Consider a relation Employee which has information about employees in some company. The employee has attributes id, first, last, sin (social insurance number) where id and sin are the only CKs, and the FDs are:
idfirst
idlast
sinfirst
sinlast
idsin
sinid

Employee – sample data

• Complete the exercise to achieve 3NF. Describe in your own words these normalization concepts into your saved document file.
  • You may display this information in table format (as posted in the exercise) or use DBDL design format.

Write this in c++

Leap year and Second in year program

1. Whether a year is a leap year on not a leap year.
2. The number of seconds in a year. (FYI, it will be a different amount for leap vs non-leap year.) You can calculate the seconds by whatever means you choose, whether with defined constants and calculations or just calculations. It is your choice.
3. If the user inputs a year number greater than zero, the program returns how many seconds were or will be in that year.
4. Put in descriptions for your request for input. If you do the bonus portion, also put that in for your request.
5. Tell the user that an input of -99 ends the program. (+5)
   Put your prompt in a loop, asking the user each time what year to check. (+5)
6. You should assume a day length of exactly 24 hours. Obviously, multiplying 365*24*3600 isn’t exactly a programming challenge, and it won’t even give the right answer for all years.
7. You must take account of leap years, which means your years will not all have the same number of days. If you do not already know, here is the calculation for leap years:

1. If a year is divisible by 4 with no remainder, it is a leap year,
2. unless it is a centurial year (ending in 00).
3. Then it is not a leap year,
4. unless it is a year divisible by 400, in which case it is still a leap year.

For example:

1904 is a leap year—evenly divisible by 4.
1900 is not a leap year—it is evenly divisible by 4, and also evenly divisible by 100. However, it is not evenly divisible by 400.
2000 is a leap year— it is evenly divisible by 4, evenly divisible by 100, but also evenly divisible by 400.
Your calculation should ignore all other variations in the length of the calendar year, such as leap seconds or the change from the Julian to the Gregorian system.

2) At the start of the new year, Adriana finds out that the price of her economics textbook increased from $100 to $120, She along with her classmates plans on purchasing the textbook, but falls from 10 students to 9 students. At the same time, the minimum wage increased from $11.50 to $12.00. What is Adriana’s income elasticity?

3) Ernesto is looking to purchase a new vehicle as his income has increased from $2,000 per month to $3,000 per month, so his purchase increases from 0 to 1 vehicle. He see’s a new Mercedes Benz that decreased its price from $45,000 to $42,000. What is Ernesto’s income elasticity of demand for a Mercedes Benz vehicle?

4) Cris, a dedicated employee at Google just found out that he will be recognized for the employee of the year award, plus an additional pay increase of 10%. He along with several top employees from other states rush to purchase Porsche 911 4S vehicles resulting in a 7% increase in the quantity demanded. What is Cris’ income elasticity of demand for a Porsche 911 4S?

5) Jerry, an addict of Jamba Juice finds out about his 3% increase in pay, so he plans on increasing his Jamba Juice consumption by 5% not to mention Jamba Juice’s 1% price decrease. However, he plans to decrease his consumption of Tropical Smoothie by 2%. What is Jerry’s cross-price elasticity of demand for a Tropical Smooth with respect to the price of Jamba Juice?

6) Matthew is an addicted coffee drinker and proud patron of Starbucks, so he keeps an eye out on the prices of coffee. He finds out that Starbucks increases its price of a grande frappuccino from $3.50 to $4.00, so he expects many patrons to consume less grande lattes from 2 to 1 per week, and to find an alternative. He lives by a Coffee Bean and Tea Leaf café and his opportunity for a grande frappucino is a medium ice blended. He plans to consume more medium ice blended drinks increasing his quantity demanded from 1 to 5 per week. What is the cross price elasticity of demand for a medium ice blended drink with respect to a grande frappuccino’s price?

Q4 - Week 9 a) What are key audit matters? How do these affect the format of the audit report? (2 marks, maximum 200 words) b) Stewart Jones is reviewing the results of the subsequent events audit procedures. Stewart is writing a report for his audit partner based on these results and will be attending a meeting tomorrow with the partner and representatives of the company to discuss them. The issue will be whether the financial report should be amended, or additional notes included for these subsequent events. Many of the items are not material and Stewart will recommend that no action be taken with respect to these. However, there are several items that Stewart believes are material and should be discussed at the meeting. These are as follows. (a) The board is planning to issue shares in a private placement on 15 August. (b) The share issue is to fund the purchase of a 60 per cent stake in another company. The negotiations are in the final stages and although the contract is not yet signed it will be signed by 15 August. (c) A writ was lodged in the Supreme Court in the week after year-end claiming damages for illness allegedly caused by chemicals used at a subsidiary company’s manufacturing plant in the 1990s. This is the tenth such writ lodged, and the client has denied responsibility in all cases because it was unreasonable to believe at that time that these chemicals had adverse health effects. The claimant has new scientific evidence that counters this defence. (d) The review of subsequent cash receipts has revealed that several of the trade receivables that were considered doubtful have now been paid. However, the audit procedures have shown that a large debtor that was considered safe at 30 June was unexpectedly declared bankrupt on 20 July. The year-end for the company is 30 June and the audit report is due to be signed on 20 August. Required: For each of the items above, explain what type of subsequent event it is and the appropriate treatment of the item in the financial report. (8 marks, maximum 300 words) Part A: Like an essay type presentation Part B: Issues Event/ Accounting Treatment (1 mark) Explanation (1 mark) (a)(/(b)/ Write 1 line about issue Types 1 Adjusting Subsequent Event – Adjust material items in financial report Or Type 2 Non-Adjusting Subsequent Event – Disclose effects of material items in financial report Or Type- No effect/ No impact Here you will mention about date, explain why you select this event with details explanation or accounting treatment and follow AASB 110 Event after the reporting period

a) What are key audit matters? How do these affect the format of the audit report? (2 marks, maximum 200 words) b) Stewart Jones is reviewing the results of the subsequent events audit procedures. Stewart is writing a report for his audit partner based on these results and will be attending a meeting tomorrow with the partner and representatives of the company to discuss them. The issue will be whether the financial report should be amended, or additional notes included for these subsequent events. Many of the items are not material and Stewart will recommend that no action be taken with respect to these. However, there are several items that Stewart believes are material and should be discussed at the meeting. These are as follows. (a) The board is planning to issue shares in a private placement on 15 August. (b) The share issue is to fund the purchase of a 60 per cent stake in another company. The negotiations are in the final stages and although the contract is not yet signed it will be signed by 15 August. (c) A writ was lodged in the Supreme Court in the week after year-end claiming damages for illness allegedly caused by chemicals used at a subsidiary company’s manufacturing plant in the 1990s. This is the tenth such writ lodged, and the client has denied responsibility in all cases because it was unreasonable to believe at that time that these chemicals had adverse health effects. The claimant has new scientific evidence that counters this defence. (d) The review of subsequent cash receipts has revealed that several of the trade receivables that were considered doubtful have now been paid. However, the audit procedures have shown that a large debtor that was considered safe at 30 June was unexpectedly declared bankrupt on 20 July. The year-end for the company is 30 June and the audit report is due to be signed on 20 August. Required: For each of the items above, explain what type of subsequent event it is and the appropriate treatment of the item in the financial report. (8 marks, maximum 300 words)

Part A: Like an essay type presentation

Part B: Issues Event/ Accounting Treatment (1 mark) Explanation (1 mark) (a)(/(b)/ Write 1 line about issue Types 1 Adjusting Subsequent Event – Adjust material items in financial report Or Type 2 Non-Adjusting Subsequent Event – Disclose effects of material items in financial report Or Type- No effect/ No impact Here you will mention about date, explain why you select this event with details explanation or accounting treatment and follow AASB 110 Event after the reporting period

a) What are key audit matters? How do these affect the format of the audit report? ( maximum 200 words)

b) Stewart Jones is reviewing the results of the subsequent events audit procedures. Stewart is writing a report for his audit partner based on these results and will be attending a meeting tomorrow with the partner and representatives of the company to discuss them. The issue will be whether the financial report should be amended, or additional notes included for these subsequent events. Many of the items are not material and Stewart will recommend that no action be taken with respect to these. However, there are several items that Stewart believes are material and should be discussed at the meeting. These are as follows.

(a) The board is planning to issue shares in a private placement on 15 August.  

( b) The share issue is to fund the purchase of a 60 per cent stake in another company. The negotiations are in the final stages and although the contract is not yet signed it will be signed by 15 August.

(c) A writ was lodged in the Supreme Court in the week after year-end claiming damages for illness allegedly caused by chemicals used at a subsidiary company’s manufacturing plant in the 1990s. This is the tenth such writ lodged, and the client has denied responsibility in all cases because it was unreasonable to believe at that time that these chemicals had adverse health effects. The claimant has new scientific evidence that counters this defence.

(d) The review of subsequent cash receipts has revealed that several of the trade receivables that were considered doubtful have now been paid. However, the audit procedures have shown that a large debtor that was considered safe at 30 June was unexpectedly declared bankrupt on 20 July. The year-end for the company is 30 June and the audit report is due to be signed on 20 August.

Required: For each of the items above, explain what type of subsequent event it is and the appropriate treatment of the item in the financial report. (, maximum 300 words)

Part A: Like an essay type presentation

Part B: Issues Event/ Accounting Treatment (1 mark) Explanation (1 mark) (a)(/(b)/ Write 1 line about issue Types 1 Adjusting Subsequent Event – Adjust material items in financial report Or Type 2 Non-Adjusting Subsequent Event – Disclose effects of material items in financial report Or Type- No effect/ No impact Here you will mention about date, explain why you select this event with details explanation or accounting treatment and follow AASB 110 Event after the reporting period

1. In class we learnt about the broad classifications of financial markets. How will you explain any three of these classifications to your friends in history department?
2. Why are financial markets so keenly regulated? Explain the rational for the regulation of financial markets in Ghana, providing cogent examples of such regulations within the Ghanaian financial market.
3. Describe the requirements for listing on the Ghana Alternative Exchange (GAX) relative to the first official listing requirements.
4. Expatiate on the role of participants in the primary and secondary mortgage market. Provide examples within the Ghanaian context.
5. Explain the difference between debt to income (DTI) ratio and loan to value ratio (LTV). In addition, mention in which scenario the mortgage is likely to be insured,
(a) High or low DTI ( b). High or low LTV.
6. Expound on the arguments in favour and against financial innovation. Provide examples of financial innovation within any country of choice.
7. A. Nii Laryea purchased a T-bill with a GHC10,000 par value for GHC9,465. One hundred days later, Nii sells the t-bill for GHC9,650. Assuming 365 days in a year, what is Nii Laryea’s expected annualized yield from the transaction?
B. Assume investors require a 5% annualized return on a six-month t-bill with a par value of GHC10,000. The price investors would be willing to pay in cedis will be?
8. According to the Loanable funds theory, how are interest rates determined?
9. Compare and contrast three different money market securities in terms of issuer, return, risk and tradability/liquidity.
10. Explain the role of non-depository financial institutions within the financial sector? Discuss the core functions of any three of these institutions.
11. In class we learnt about defined-benefit pension plans and a defined-contribution pension plans. How will you explain these to your sibling who just got a job after his University education? Which of them will you recommend to him and why?
12. Compare and contrast index fund and active fund. Provide relevant examples of these and explain what their objective is.
13. Endicott Enterprises Inc. has twenty years remaining on Ghc 1,000 par value semiannual coupon bonds paying a coupon of Ghc40. If the yield to maturity on these bonds is 6% per year, what is the current price?

How Grounded Is Your Love Life?

In a recent experiment, psychologists at University of Pittsburgh and the University of Waterloo in Canada decided to examine stability, turbulence and love. The researchers focused on stability because it is a term that has both literal and abstract meanings. Our bodies can be physically stable or they can be wobbly, and so can our intimate relationships. The study participants were 40 college students who reported being involved in a committed relationship that had lasted for at least a year. The researchers randomly assigned half of their volunteers to sit at a normal desk and the other half to sit at a workstation that had been subtly altered so that both the chair and the desk wiggled slightly. The volunteers individually completed questionnaires about their lives and romantic relationships, including whether they felt the relationship would last. The volunteers were alone in the room when they completed the questionnaire and were instructed to not put their name on the questionnaire. The ratings of perceived stability ranged from 1- 7 (1 = not at all likely to last to 7 = certain this relationship will last). A participant could report any number between 1 and 7 on that scale. The students who had been seated at the unstable workstations were much more likely to perceive instability in their love lives (mean = 4.17) than were the students whose chairs and work spaces didn’t waver (mean = 4.93). There is a statistically significant difference between these means (t(38) = 3.64; p<0.05).

PART A

1. Name the Predictor / Independent Variable

2. Give the operational definition of the Predictor / Independent Variable.

3. Evaluate the construct validity of the Predictor / Independent Variable PLEASE INCLUDE/EXPLAIN ALL THE ASPECTS!!: (Be sure to consider face, method, and procedural aspects though not all aspects will necessarily need to be discussed; point out strengths and weaknesses of this measure.)

PART B

1. Name the Outcome / Dependent Variable

2. Give the operational definition of the Outcome / Dependent Variable.

3. Evaluate the construct validity of the operational definition for the Outcome / Dependent Variable. PLEASE INCLUDE/EXPLAIN ALL THE ASPECTS!!: (Be sure to consider face, method, and procedural aspects though not all aspects will necessarily need to be discussed; point out strengths and weaknesses of this measure.)

PLEASE ANSWER IF YOU KNOW!

How Grounded Is Your Love Life?

In a recent experiment, psychologists at University of Pittsburgh and the University of Waterloo in Canada decided to examine stability, turbulence and love. The researchers focused on stability because it is a term that has both literal and abstract meanings. Our bodies can be physically stable or they can be wobbly, and so can our intimate relationships. The study participants were 40 college students who reported being involved in a committed relationship that had lasted for at least a year. The researchers randomly assigned half of their volunteers to sit at a normal desk and the other half to sit at a workstation that had been subtly altered so that both the chair and the desk wiggled slightly. The volunteers individually completed questionnaires about their lives and romantic relationships, including whether they felt the relationship would last. The volunteers were alone in the room when they completed the questionnaire and were instructed to not put their name on the questionnaire. The ratings of perceived stability ranged from 1- 7 (1 = not at all likely to last to 7 = certain this relationship will last). A participant could report any number between 1 and 7 on that scale. The students who had been seated at the unstable workstations were much more likely to perceive instability in their love lives (mean = 4.17) than were the students whose chairs and work spaces didn’t waver (mean = 4.93). There is a statistically significant difference between these means (t(38) = 3.64; p<0.05).

PART A

1. Name the Predictor / Independent Variable

2. Give the operational definition of the Predictor / Independent Variable.

3. Evaluate the construct validity of the Predictor / Independent Variable PLEASE INCLUDE/EXPLAIN ALL THE ASPECTS!!: (Be sure to consider face, method, and procedural aspects though not all aspects will necessarily need to be discussed; point out strengths and weaknesses of this measure.)

PART B

1. Name the Outcome / Dependent Variable

2. Give the operational definition of the Outcome / Dependent Variable.

3. Evaluate the construct validity of the operational definition for the Outcome / Dependent Variable. PLEASE INCLUDE/EXPLAIN ALL THE ASPECTS!!: (Be sure to consider face, method, and procedural aspects though not all aspects will necessarily need to be discussed; point out strengths and weaknesses of this measure.)

1. As a matter of law, what is an “investment security”?

Question 1 options:

Question 2 (5 points)

2. If your firm only occasionally issues securities for purchase by the public, the 1933 Securities Act does not require registration with the Securities and Exchange Commission and disclosure of material financial information.

Question 2 options:

Question 3 (5 points)

3. “Shelf registration” under the 1933 Act:

Question 3 options:

Question 4 (5 points)

4. Most municipal bond issuance is required to be registered with the SEC.

Question 4 options:

Question 5 (5 points)

5. The antifraud provisions of the 1934 Act (Securities Exchange Act of 1934)(Rule 10b-5):

Question 5 options:

Question 6 (5 points)

6. Persons who may violate Rule 10b-5 include:

Question 6 options:

Question 7 (5 points)

7. The punishment for violations of Rule 10b-5 (up to ten years of federal imprisonment and up to a $1 million fine) is among the harshest in the federal criminal code (18 U.S.C.) for nonviolent felonies that do not involve the sale of illegal drugs.

Question 7 options:

Question 8 (5 points)

8. In a trademark infringement case, a court presumably would give great weight to the facts that the first manufacturer had registered his trademark and that a subsequent competitor manufactured products in the same style and color and using an emblem with the same shape as the emblem on the first manufacturer’s products.

Question 8 options:

Question 9 (5 points)

9. How long does standard copyright protection under federal law last now?

Question 9 options:

Question 10 (5 points)

10. What is the life of a design patent registered with the U.S. Patent and Trademark Office? Assume that a design patent is the diagram of a machine that accomplishes a task. For machines, scale models have to be submitted, also.

Question 10 options: