1. (4 points) Professor Crewel would like to see the distribution of questions difficulty among the various topics.
For each question list the topic title, the question id, the questions status, and the question difficulty. Sort the results for question difficulty. Within question difficulty sort the questions by topic title. Use a join. Do not use the INNER JOIN keywords.

SELECT A. Title, B. QuestionId, B. Status, B. Difficulty from Topics A., Question B WHERE

A. Topicid =B. Topicid ORDER BY B. Difficulty, A. Title how do u show The result of the SELECT statement

Document Preview:

CITD 120 — SQL Concepts Homework Assignment 4 40 points NOTE: The Course Quizzes database you are using for this assignment is a test database and contains much less data than would be in the production database used to run the company. It has been made smaller to make it easier for you to check that your SELECT statement retrieves the correct data. However, retrieving the correct data from the testing database is not a guarantee that the SELECT statement is correct. You must write your commands as if they were run against the larger database which has different data than the testing database you are using. The ER Diagram for the Course Quizzes database is shown below. For EACH TASK for this assignment submit the following: a. The SELECT statement you used. b. The result of the SELECT statement. TASKS: (4 points) Professor Crewel would like to see the distribution of questions difficulty among the various topics.For each question list the topic title, the question id, the questions status, and the question difficulty. Sort the results for question difficulty. Within question difficulty sort the questions by topic title. Use a join. Do not use the INNER JOIN keywords. SELECT A. Title, B. QuestionId, B. Status, B. Difficulty from Topics A., Question B WHERE A. Topicid =B. Topicid ORDER BY B. Difficulty, A. Title 2.(4 points) Professor Crewel would like to know the text of the questions she has used on quiz 2.List the question text for the questions for quiz 2. Do not use a join. Use the IN operator. SELECT Text FROM Questions WHERE QuestionId in (SELECT QuesionId from QuizQuestionns WHERE QuizNum = 2) 3.(4 points) Professor Crewel would like to know which questions she has used on quiz 2.List the question text for the questions for quiz 2. Do not use a join. Use the EXISTS operator. SELECT Text FROM QuestionQ WHERE EXISTS ( SELECT* FROM QuizQuestionsQQ …

Attachments:

CITD120Assign….docxCourseQuiz1–….zip

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1.7 Read all of the classic papers cited in Section 1.7. Compose a 500–1000 word paper (or 8–12 slide PowerPoint presentation) that summarizes the key concepts that emerge from these papers, emphasizi

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. A brief business analysis (including economy, industry, and company strategies) which forms the basis of your subsequent financial analysis. Note that before doing the business analysis, you should determine the purpose, which can be either equity valuation or credit and risk analysis in this project. The purpose can influence all your subsequent analysis. 2. Identify financial reporting choices and biases that affect the quality and comparability of the company’s financial statements. You may refer to supplemental information from sources other than financial statements. 3. Evaluate the quality of the company’s financial statements and earnings, and recommend appropriate adjustments for such desirable characteristics as sustainability or comparability. 4. Conduct equity valuation or credit and risk analysis based on the adjusted financial data. 5. Prepare adjusted financial statements (statement of financial position, statement of profit and loss/statement of comprehensive income, and statement of cash flows). Purpose 1. Equity valuation OR 2. Credit analysis – -https://www.crisil.com/Ratings/Brochureware/RR_ASSES/CRISIL-Ratings-research-approach-to-financial-ratios_2013.pdf (following indicators to consider for credit analysis and subsequently to adjust the final report for calculation) a. Capital Structure i. Gearing = Total debt /Tangible net worth ii. Total Indebtedness Ratio = Total Outside Liability / Tangible Net Worth iii. BV_TANG = Tangible Book Value / Assets iv. LEVERAGE= Total Liabilities / Total Assets v. LTDEBT= Long Term Debt / Total Assets b. Interest coverage i. Interest coverage ratio = Profit before depreciation, interest, and tax (PBDIT1 )/ Interest and finance charges c. Debt-service coverage ratio i. CDSCR = [Profit after tax + Depreciation + Interest charges – 25 per cent of incremental NWC3 ] / [Debt payable within one year + Interest and finance charges] d. Net worth i. Market value of equity = Number of common shares outstanding *share price e. Profit margin i. PAT margin = Profit after tax / Operating income ii. ROA= Net Income before Extraordinary Items/ Total Assets iii. PROFIT= Net Income before Extraordinary Items / Sales f. Return on capital employed i. RoCE = Profit before interest and tax (PBIT) / [Total debt + Tangible net worth + Deferred tax liability] ii. ROE= Net Income before Extraordinary Items / Book Value of Equity; iii. g. Net cash accruals to total debt i. NCATD = [PAT – Dividend + Depreciation] / Total debt (short and long term, including off-balance-sheet debt) h. Current ratio i. Current ratio = Current assets (including marketable securities)/Current liabilities (including current portion of long-term debt i.e. CPLTD) ii. Gross current assets days = Total current assets related to operations/ operating income iii. i. Others i. PRSTDS= Standard deviation of earnings / Total assets Company Summary 1. Qualitative – A brief business analysis (including economy, industry, and company strategies) 2. Quantitative – a. Growth i. Net increased moderately, growing by X%. This is XX than the XX% growth rate for 2016. b. Cash status – liquidity i. XXX cash flow from operations generated in 2016/17, which was insufficient?? to cover all financing costs or any debt amortization. ii. capital and investment expenditures to meet by new debt, additional equity, or cash depletion, subsidies… c. Outstanding indicators i. Gross Margin ii. Operating expenses iii. Operating Profit iv. Net Profit Margin v. Bad Debt Reserve vi. Debt/TNW vii. Others… 3. Why the indicator is outperformed/underperformed – the focus question/assumption 4. Key notes i. Construction revenue recognition using percentage-of-completion method and allowance for expected losses ii. Impact of challenges in the marine industry on the valuation of assets iii. Valuation of held-to-maturity financial assets iv. Impairment loss sudden decrease v. Sudden growth in 2017 (revenue jump) vi. Contracts – b/s vii. Borrowing – b/s viii. Other reserves – b/s ix. Income tax – i/s x. Equity holder – i/s xi. Re-classification / fair loss – oci xii. Currency loss – oci 4. Reasons and alerts in the financial statements 1. Earning quality 2. Cashflow quality 3. Balance sheet quality

Attachments:

2016-Annual-r….xlsx2017-Annual-r….xlsxYZJ—2014-20….xlsxNotes.docx

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1.A company’s operations to link private changes with special group of suppliers are classified as A. public exchanges B.private exchanges C.spot markets D.exchange markets 2. Eight stages in buying process is called A. buy phase B.purchase phase C.sell phase D.off phase 3. In business markets, technical sources have great importance in the A. interest stage B.evaluation stage C.initial awareness stage D.trial stage 4. Simple and routine exchanges with moderate level of cooperation and exchange of information is classified as A. basic buying and selling B.contractual selling C.contractual buying D.cooperative systems 5. Websites on which customer can order through distributed catalogs are classified as A. ordering sites B.catalog sites C.procurement sites D.distribution sites

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. afirm’s workforce is on average 20 years away from retiring. The firm’s workers Supposecould find similar work in other companies earning $40,000 per year. Also,suppose that workers who shirk their work have a .30 chance of being dismissed.

a. Forsimplicity, assume that workers could find a job in an alternative company withno search costs. What would the firm have to pay to impose shirking costs of$60,000 on the average worker during his (her) work life expectancy? Show yourwork.

b. Findthree salary-probability of dismissal combinations that would yield shirkingcosts of $60,000 for the average worker over his (her) work life expectancy.

2. Supposea firm is considering installing cameras and using spy software on thecomputers at the office to monitor its workers in addition to hiring additionalsupervisors. The firm estimates that increasing the probability of catchingworkers who shirk by .01 costs the company $10,000 per year. For example, inthe problem above when going from 0.30 to 0.31, it would cost the firm $10,000per year. How much would the firm have to spend in order to impose shirkingcosts of $75,000 on its average worker? Show your work. Assume that

· the firm’s work force is on average 20years away from retiring

· that the firm’s workers could find similarwork in other companies earning $40,000

· that the company currently pays itsworkers $42,000

· and that the current probability ofcatching workers who shirk is 0.30,

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"