Discussion Topics:
Assume that you have a Saudi league player database. In this
database, you have a table containing players’ attributes such as
(Name, age, position, etc.) and you decided to add information
about players’ agents. Would you represent the agent information as
attributes in the player table or would you create an entity set
for players’ agents? Justify your answer.
Note: Provide answers in your own words.
In: Computer Science
Consider the following scenario:
An electronics manufacturer produces a range of consumer and commercial grade electronic devices. These include television sets, sound systems, computer monitors, mobile phones and many other products. Each of these products has a name and a unique ID number associated with them.
Components to make these devices can be purchased from a single vendor or from multiple vendors. Each component has a name, unique ID number and may include a component description (this information is optional).
The manufacturer sells its products to commercial buyers and also directly to consumers. The manufacturer keeps track of the name, address and phone numbers of the commercial buyers. Only the postcode for non-commercial buyers is stored.
a) Your first task is to construct an Entity-Relationship diagram that captures entities and their relationships. You are free to make assumptions about any information that you believe is not supplied as long as you state these assumptions. (Your assumptions should not contradict the description!)
b) Translate the E-R diagram from part (a) into a database schema in SQL. * Your DDL statements should define foreign keys that reflect the relationships outlined in the scenario. * Your foreign key contains should have appropriate referential triggered actions defined. Include an explanation of the referential actions. * Make sure that you select reasonable types for each table's attributes
c) The manufacturer requires that all phone numbers from commercial buyers include the country code (e.g. for Australia this will be +61). How can you use the your database to enforce this rule? Include an appropriate SQL statement(s) in your answer.
In: Computer Science
Q9: Mr. Osama Al Rawabi , a research consultant recently conducted a survey of the people from 05 countries regarding the level of education and he has published his study as per below:
|
Country |
Post Graduation |
Graduation |
Higher Secondary |
Primary |
No Answer |
|
China |
7 |
315 |
671 |
506 |
3 |
|
France |
69 |
388 |
766 |
309 |
7 |
|
India |
161 |
514 |
622 |
227 |
11 |
|
UK |
58 |
207 |
1240 |
32 |
20 |
|
USA |
84 |
486 |
896 |
87 |
4 |
Find out the following probabilities: (5Q*1M=5 Marks)
e) Critically compare mutually exclusive and non exclusive events in probability
In: Statistics and Probability
Digg company is evaluation two projects for next year’s capital budgeting. The after-tax cash flow ($) (including depreciation) are following:
Project A Project B
Year 0 -6000 -17500
Year 1 2000 5600
Year 2 2000 5600
Year 3 2000 5600
Year 4 2000 5600
Year 5 2000 5600
Year 6 4000 9000
If company’s WACC is 13%, find NPV, IRR, Payback and discount payback for each project. If the projects are mutually exclusive what is your recommendation to the company.
Specific help and showing of work for the payback discount please!!
In: Finance
Below are the 2018 and 2019 year-end balance sheets for Tran Enterprises:
| Assets: | 2018 | 2017 |
| Cash | $ 200,000 | $ 170,000 |
| Accounts receivable | 864,000 | 700,000 |
| Inventories | 2,000,000 | 1,400,000 |
| Total current assets | $3,064,000 | $2,270,000 |
| Net fixed assets | 6,000,000 | 5,600,000 |
| Total assets | $9,064,000 | $7,870,000 |
Liabilities and equity:
| Accounts payable | $1,400,000 | $1,090,000 |
| Notes payable to bank | 1,600,000 | 1,800,000 |
| Total current liabilities | $3,000,000 | $2,890,000 |
| Long-term debt | 2,400,000 | 2,400,000 |
| Common stock | 3,000,000 | 2,000,000 |
| Retained earnings | 664,000 | 580,000 |
| Total common equity | $3,664,000 | $2,580,000 |
| Total liabilities and equity | $9,064,000 | $7,870,000 |
The firm has never paid a dividend on its common stock, and it issued $2,400,000 of 10-year, non-callable, long-term debt in 2018. As of the end of 2019, none of the principal on this debt had been repaid. Assume that the company's sales in 2018 and 2019 were the same. Which of the following statements must be CORRECT?
|
|||
|
|||
|
|||
|
|||
|
In: Finance
Noel Chappell has started the car repair business for five years. He is interested to know the performance of his business. The statement of financial position is shown below:
|
|||||
|
2018 |
2019 |
||||
|
Assets |
($) |
($) |
|||
|
Cash |
6,000 |
3,000 |
|||
|
Accounts receivable |
14,000 |
17,000 |
|||
|
Inventory |
13,000 |
19,000 |
|||
|
Non-current assets (net) |
27,000 |
20,000 |
|||
|
Total assets |
60,000 |
59,000 |
|||
|
Liabilities and shareholders' equity |
|||||
|
Accounts payable |
20,000 |
22,000 |
|||
|
Long term borrowings |
16,000 |
13,000 |
|||
|
Capital |
24,000 |
24,000 |
|||
|
Total liabilities and shareholders' equity |
60,000 |
59,000 |
|||
Additional information:
Total assets as at 1 July 2017 were $25,000.
Total revenues/sales in 2019 were $180,000 and in 2018 were $140,000.
Profit after tax for 2019 is $36000 and in 2018 is $28000.
Required
(i) Calculate the following ratios for 2018 and 2019:
1. current ratio
2. quick ratio
3. debt ratio
4. asset turnover ratio
5. profit margin
The industry average of the liquidity ratio for similar businesses is also provided:
|
current ratio |
1.3:1 |
|
quick ratio |
0.8:1 |
|
debt ratio |
50% |
|
asset turnover ratio |
4.0:1 |
(ii) Comment on the liquidity and financial stability performance of the business.
In: Accounting
Noel Chappell has started the car repair business for five years. He is interested to know the performance of his business. The statement of financial position is shown below:
|
Noel Chappell |
||||||
|
Statement of Financial Position |
||||||
|
As at 30 June |
||||||
|
2018 |
2019 |
|||||
|
($) |
($) |
|||||
|
Assets |
||||||
|
Cash |
6,000 |
3,000 |
||||
|
Accounts receivable |
14,000 |
17,000 |
||||
|
Inventory |
13,000 |
19,000 |
||||
|
Non-current assets (net) |
27,000 |
20,000 |
||||
|
Total assets |
60,000 |
59,000 |
||||
|
Liabilities and shareholders' equity |
||||||
|
Accounts payable |
20,000 |
22,000 |
||||
|
Long term borrowings |
16,000 |
13,000 |
||||
|
Capital |
24,000 |
24,000 |
||||
|
Total liabilities and shareholders' equity |
60,000 |
59,000 |
||||
Additional information:
Total assets as at 1 July 2017 were $25,000.
Total revenues/sales in 2019 were $180,000 and in 2018 were $140,000.
Profit after tax for 2019 is $36000 and in 2018 is $28000.
Required
(i) Calculate the following ratios for 2018 and 2019:
1. current ratio
2. quick ratio
3. debt ratio
4. asset turnover ratio
5. profit margin
The industry average of the liquidity ratio for similar businesses is also provided:
|
current ratio |
1.3:1 |
|
quick ratio |
0.8:1 |
|
debt ratio |
50% |
|
asset turnover ratio |
4.0:1 |
(ii) Comment on the liquidity and financial stability performance of the business.
In: Accounting
The following facts are for a non-cancellable lease agreement between Alpha Corporation and Beta Corporation, a lessee:
|
Inception Date |
July 1, 2018 |
|
Annual lease payment due at the beginning of each year, starting July 1, 2018 |
$20,066.26 |
|
Purchase option price at end of lease term reasonably certain to be exercised by Beta |
$4,500.00 |
|
Lease term |
5 years |
|
Economic life of leased equipment |
10 years |
|
Lessor’s cost |
$60,000.00 |
|
Fair value of asset at July 1, 2018 |
$88,000.00 |
|
Lessor’s implicit rate |
9% |
|
Lessee’s incremental borrowing rate |
9% |
The collectability of the lease payments is reasonably predictable, and there are no important uncertainties about costs that have not yet been incurred by the lessor. The lessee assumes responsibility for all executory costs. Both Beta and Alpha use IFRS 16.
question 4 - A lease agreement between Alpha Corporation and Beta Corporation is described in the previous question (question 3)
Provide the following for Alpha Corporation, the lessor.
Required:
1. Calculate the amount of gross investment at the inception of the lease.
2. Calculate the amount of net investment at the inception of the lease.
3. Prepare the journal entries to reflect the signing of the lease and to record the receipts and income related to this lease for the years 2018, 2019, and 2020.
In: Accounting
The minimum word count for any assignment is 2000-2500
words unless it is mentioned otherwise in the assignment
instructions or task by task. You could lose marks if you write 10%
more or less than this.
Assignments will be reviewed only if they are
completed with all the tasks/questions. Please do not send each
task/question separately.
All documents will be checked for plagiarism. Any
report found to be plagiarised for more than 15% would be rejected
immediately.
Make sure to insert correct in-text citations when
drafting an assignment and a list of references as per the
Harvard Referencing Style is to be provided at the end of
the whole assignment. (Not end of each task)
All assignments will be sent for review and until the
assignment status shows “Completed”, kindly keep checking for
feedback and do the needful accordingly.
Assignments should be saved as: Programme Name _
(Candidate Full Name) _ (Candidate Code)_(Unit Abbreviation). i.e.
MBA_ John Smith_00123456_ ABRM
Answer only one part from all of the questions below:
Question 1
1. Discuss the concept of corporate reporting, its
importance and the characteristics of good corporate reporting.
Also, explain the concept of integrated reporting.
Question 2:
1. Critically discuss financial reporting and analysis. And explain the following:
* The GAAP ( Generally Accepted Accounting
Principles)
* The IFRS ( International Financial Reporting Standards)
In: Finance
How has the United States prepared itself for national emergencies? What types of preparedness initiatives, response systems, and agencies are in place in the event of a national emergency? Please include references and citations in your answer
In: Nursing