Draw the corresponding ERD for the following Employee Database:

Employee (emp_id, first_name, middle_name, last_name, date_of_birth)

Dept (Dept_id, Dept_name, Building)

works (emp_id, dept_id, hours)

Emp_phone (emp_id, phone_num)

Note:

Please I need a short answer only on paragraph and simple words.

In 2000, Enron enjoyed remarkable success in the capital markets. During that year, Enron’s shares increased in value by 89%, while the S&P 500 index fell by 9%. At the end of 2000, Enron’s shares were trading at roughly $83 per share, and all of the sell-side analysts following Enron recommended the shares as a ‘‘buy’’ or a ‘‘strong buy.’’ With 752.2 million shares outstanding, Enron had a market capitalization of $62,530 million and was one of the largest firms Enron had a market capitalization of $62,530 million and was one of the largest firms (in terms of market capital) in the United States. At year-end 2000, Enron’s book value of common shareholders’ equity was $11,470 million. At year-end 2000, Enron posted earnings per share of $1.19. Among sell-side analysts following Enron, the consensus forecast for earnings per share was $1.31 per share for 2001 and $1.44 per share for 2002, with 10% earnings growth expected from 2003 to 2005. At the time, Enron was paying dividends equivalent to roughly 40% of earnings and was expected to maintain that payout policy. At year-end 2000, Enron had a market beta of 1.7. The risk-free rate of return was 4.3%, and the market risk premium was 5.0%. (Note: The data provided in this problem, and the inferences you draw from them, do not depend on foresight of Enron’s declaring bankruptcy by the end of 2001.)

Reverse engineer Enron’s $83 share price to solve for the implied expected return on
Enron shares at year-end 2000. Do the reverse engineering under the following
assumptions:
(1) Enron’s market price equals value.
(2) The consensus analysts’ earnings-per-share forecasts through 2005 are reliable proxies
for market expectations.
(3) Enron will maintain a 40% dividend payout rate.
(4) Beyond 2005, Enron’s long-run earnings growth rate will be 3.0%.

Please include details on how the reverse engineering numbers are calculated.

Question 2

The extracts from the trial balance of Tall Ltd as at 31 December 2019 are: K’000 K’000 Land (K5 million) and buildings – at cost 55,000 Plant and equipment – at cost 58,500 Accumulated depreciation at 1 January 2018 : buildings 20,000 : plant and equipment 34,500 The following notes are relevant: Non-current assets: The price of property has increased significantly in recent years and on 1 January 2019, the directors decided to revalue the land and buildings. The directors accepted the report of an independent surveyor who valued the land at K8 million and the buildings at K39 million on that date. The remaining life of the buildings at 1 January 2019 was 15 years. Tall Ltd does not make an annual transfer to retained profits to reflect the realisation of the revaluation gain. Plant and equipment is depreciated at 12½% per annum using the reducing balance method. No depreciation has yet been charged on any non-current asset for the year ended 31 December 2019. Depreciation is charged to cost of sales.

Required:

Prepare extracts from the statement of profit or loss and other comprehensive income for Tall Ltd for the year ended 31 December 2019 and from the statement of financial position as at the same date with regards property, plant and equipment.

Sheridan Corporation owns machinery that cost $21,200 when purchased on July 1, 2017. Depreciation has been recorded at a rate of $2,544 per year, resulting in a balance in accumulated depreciation of $8,904 at December 31, 2020. The machinery is sold on September 1, 2021, for $11,130.

Prepare journal entries to (a) update depreciation for 2021 and (b) record the sale.

Concord Corporation owns machinery that cost $26,400 when purchased on July 1, 2017. Depreciation has been recorded at a rate of $3,168 per year, resulting in a balance in accumulated depreciation of $11,088 at December 31, 2020. The machinery is sold on September 1, 2021, for $6,864.

Prepare journal entries to (a) update depreciation for 2021 and (b) record the sale.

The inverse demand function for a product by a company that montizes the market is given by v = 200 - 0.03m and supply is given by v = 0.05m

a) Draw and calculate market balance (show price & quantity and a picture)

b)The product damage to society is 70$ per unit. The government uses Pigovjan tax on the production of the company. Update the picture from a) in regards to the Pigovjan tax/1b.

First, create a project that creates an ordered linked list class (use the code provided, make sure to update the insert function so that it maintains an ordered list).

To this class, add a function that prints the list in REVERSE order. Making use of recursion is the easiest and best way to do this, but certainly not the only way.

Submit a .zip of your entire project.

Write an AFTER Insert trigger for the following Employee table. Check Date of Birth and calculate age. Update AGE field with calculated value in Employee_Info table

• Employee (Emp_ID int, DOB date)

• Employee_Info (Emp_ID int, Fname char, Lname char, Age int)

• Set variable Current_Date to CURDATE()

• Substract DOB from Current_Date to find Age

--Know how to nest subqueries: in, not in, some, all, and exists. Know how to nest queries in the from clause. Be able to use the with clause. Be able to use scalar subqueries.
--Know how to use correlation variables in subqueries.
--Know how to use case in queries.
--Know how to insert, delete, and update using subqueries.

Study guide please give examples