Database Design CIW
State_Capitals Physical Database
Create primary and secondary keys for the attached unfinished physical database design.
| CREATE DATABASE STATE_CAPITALS; | ||
| GO | ||
| USE STATE_CAPITALS; | ||
| GO | ||
| CREATE TABLE Country( | ||
| Country_Code varchar(10) NOT NULL, | ||
| Country_Name varchar(50) NOT NULL, | ||
| Population int NOT NULL, | ||
| Country_Size float NOT NULL | ||
| ) | ||
| GO | ||
| CREATE TABLE Region( | ||
| Country_Code varchar(10) NOT NULL, | ||
| Region_Code varchar(10) NOT NULL, | ||
| Region_Name varchar(50) NOT NULL | ||
| ) | ||
| GO | ||
| CREATE TABLE State( | ||
| Region_Code varchar(10) NOT NULL, | ||
| State_Code char(2) NOT NULL, | ||
| State_Name varchar(50) NOT NULL, | ||
| Date_of_Statehood int NOT NULL, | ||
| State_Size float NOT NULL, | ||
| State_Population int NOT NULL | ||
| ) | ||
| GO | ||
| CREATE TABLE Capital( | ||
| State_Code char(2) NOT NULL, | ||
| Capital_Code tinyint NOT NULL, | ||
| Capital_Name varchar(50) NOT NULL, | ||
| Capital_Since smallint NOT NULL, | ||
| Land_Area float NOT NULL, | ||
| Most_Populous_City bit NOT NULL, | ||
| Municipal_Population int NOT NULL, | ||
| Metropolitan_Population int NULL, | ||
| Note varchar(300) NULL | ||
| ) | ||
| GO | ||
Ensure your submission addresses each of these components:
Submit your project in a word document format
In: Computer Science
Review the 10k reports from Microsoft and Apple in 2018-2019, write a few paragraphs about which company you would rather invest in maybe give a a few reasons why you choose this company with possible financial information and non-financial information in it. Thank you :)
In: Accounting
Angiogenesis is required for normal development to proceed. However, angiogenesis is also required to allow tumors to become metastatic. Explain how angiogenesis is involved in these two diverse pathways and give two examples for its role in normal development and two examples for its role in cancer. Please include all citations used as well as in-text citations.
In: Biology
"How can I connect my hadoop database or mysql database server to my d3 visual?"
In: Computer Science
using empirical research checklist search for empirical article and write an annotation concise summary in your own words and APA format (1) Does breastfeeding help to reduce the risk of childhood obesity (2) a systematic review and meta-analysis of the effect of lifestyle modification on metabolic control in overweight children?
In: Nursing
Prepare a memo for the file showing the ADSP in a 2018 sale and comparing it to the ADSP from a 2017 sale.
Acquiring Corporation pays $22,000,000 for 100% of Target stock in a single transaction.
Target assets have a tax basis of $12,000,000.
Target liabilities are on the balance sheet at $4,000,000
The ADSP = Stock Purchase Cost + Target Liabilities
Target Liabilities = Non-tax Liabilities + Tax Liability
Tax Liability = .25 (ADSP – Tax Basis of Assets) 2017
Tax Liability = .21 (ADSP – Tax Basis of Assets) 2018
In: Accounting
National Foods Pvt. Ltd. is a company producing canned foods. Below are the company’s financial statements:
|
National Foods Pvt. Ltd. |
||||||||
|
Statement of Comprehensive Income for the year ended 31 August 2018 |
||||||||
|
RM |
||||||||
|
Sales revenue |
2,700,000 |
|||||||
|
Cost of goods sold |
(900,000) |
|||||||
|
Gross profit |
1800,000 |
|||||||
|
Operating Expenses Administration & Distribution expenses |
(195,000) |
|||||||
|
Depreciation expense |
(30,000) |
|||||||
|
Other operating expense |
(150,000) |
|||||||
|
Interest expense |
(135,000) |
|||||||
|
Net profit before tax |
1,290,000 |
|||||||
|
Income tax expense |
(240,000) |
|||||||
|
Net income |
1,050,000 |
|||||||
|
National Foods Pvt. Ltd. |
||||||||
|
Statement of Financial Position as at 31 August 2018 |
||||||||
|
2017 |
2018 |
|||||||
|
RM |
RM |
RM |
RM |
|||||
|
Non-current Assets |
||||||||
|
Van |
600,000 |
900,000 |
||||||
|
(-)Accumulated depreciation |
(120,000) |
480,000 |
(150,000) |
750,000 |
||||
|
Current Assets |
||||||||
|
Bank |
825,000 |
1,186,500 |
||||||
|
Debtors |
300,000 |
150,000 |
||||||
|
Inventory |
75,000 |
90,000 |
||||||
|
Total Assets |
1,680,000 |
2,176,500 |
||||||
|
Non-current Liabilities |
||||||||
|
Loan |
480,000 |
630,000 |
||||||
|
Current Liabilities |
||||||||
|
Creditors |
90,000 |
135,000 |
||||||
|
Operating expenses payable |
31,500 |
33,000 |
||||||
|
Shareholders’ Equity |
||||||||
|
Ordinary share capital |
478,500 |
478,500 |
||||||
|
Retained earnings |
600,000 |
900,000 |
||||||
|
Total Liabilities & Equities |
1,680,000 |
2,176,500 |
||||||
Required:
Prepare the statement of cash flows for Hasniza Foods Pte. Ltd. for the year ended 31 August 2018 using the direct method. (Show all calculations).
In: Accounting
|
2019 ‘000 US$ |
2018 ‘000 US$ |
|
|
Assets |
||
|
Non-current assets Property, plant and equipment Right of use assets Investment properties Intangible assets and goodwill Investment in equity accounted investees Other investments Accounts receivable and prepayments |
12,226,735 2,080,908 1,672,911 10,054,701 2,200.252 20,009 675,845 |
8,960,782 - 1,622,130 8,833,151 2,101,425 51,078 574,570 |
|
Total non-current assets |
28,931,361 |
22,143,136 |
|
Current assets Inventories Properties held for development and sales* Accounts receivable and prepayments Cash and cash equivalents |
156,393 194,612 1,836,795 2,943,359 |
115,590 261,724 1,378,179 2,614,710 |
|
Total current assets |
5,131,159 |
4,370,203 |
|
Total Assets |
34,062,520 |
26,513,339 |
|
2019 ‘000 US$ |
2018 ‘000 US$ |
|
|
Equity Share capital Share premium Shareholders’ reserve Retained earnings Translation reserve Other reserves |
1,660,000 2,472,655 2,000,000 8,179,779 (1,904,817) (592,451) |
1,660,000 2,472,655 2,000,000 7,712,784 (1,976,051) (598,190) |
|
Equity attributable to owners of the company |
11,815,166 |
11,311,198 |
|
Non-controlling interests |
1,032,052 |
687,720 |
|
Total equity |
12,847,218 |
11,998,918 |
|
Liabilities |
||
|
Non-current Liabilities Loans and borrowings Lease liabilities Loans from non-controlling shareholders Accounts payables and accruals Deferred tax liabilities Employee’ end of service benefits Pension and post-employment benefits |
12,185,472 2,287,655 688,017 3,79,271 937,967 176,227 347,406 |
10,048,232 17,156 132,236 345,467 886,173 159,233 157,082 |
|
Total non-current liabilities |
17,002,015 |
11,745,579 |
|
Current liabilities Loans and borrowings Lease liabilities Accounts payables and accruals Income tax liabilities Pension and post-employment benefits |
1,095,412 225,535 1,000 2,663,660 120,888 106,792 |
348,324 6,051 1,000 2,305,727 100,674 7,066 |
|
Total current liabilities |
4,213,287 |
2,768,842 |
|
Total liabilities |
21,215,302 |
14,514,421 |
|
Total equity and liabilities |
34,062,520 |
26,513,339 |
|
Sales |
7,685,938 |
5,646,280 |
Required:
A. Calculate the following ratios of DP World for the year 2018 &2019:
B. Evaluate liquidity, solvency and efficiency of the company.
if you can not do all part A and part B, just leave it for another tutoor
In: Accounting
According to Markowitz, an investment in risky security is presumed to select an investment portfolio which is on the EFFICIENT FRONTIER and tangent on the investor indifference curve. However, in practice neither the efficient frontier nor the INDIFFERENCE CURVE can be estimated with high degree of accuracy. Therefore, the PORTFOLIO THEORY may be redundant. Explain the term in in capital letters in the above statement and critically asses their validity with reference to be above theoretical argument.
In: Finance
Many employees find learning about employee safety as part of annual education every year redundant or boring. (In fact, you may already have similar opinions based on your job or previous classes where you have learned about safety.) Why is it important to continuously remind ourselves about OSHA regulations pertinent to our jobs? 300 words please.
In: Psychology