4-5. List the junior level COSC courses (like COSC3xxx) and the name of the course. Use the Course table.

4-6. Using the COUNT feature, determine whether there are duplicate names or student numbers in the Student table.

4-7. Assume all math courses start with MATH. How many math courses are there in the Section table? From the COUNT of courses, does it appear there are any math courses in the Section table not in the Course table? Again, using COUNTs, are there any math courses in the Course table not in the Section table? Does it appear there are any courses at all in the Grade_report, Section, or Course tables not in the others? (We will study how to ask these questions in SQL in a later chapter). A query like the following would not work:

SELECT g.section_id

FROM Grade_report g, Section t

WHERE g.section_id <> t.section_id;
Explain why WHERE .. <> .. will not work to produce the desired output.

4-8. Display dictionary views for the tables we have in the Student-Course database (refer to the diagram in Appendix 3 for all the table names). Use “All_tables” as the dictionary view. Do the query as follows:

a. DESCRIBE the table with DESC All_tables;

b. Display the number of rows in All_tables. Use SELECT COUNT(*) FROM All_tables; When you are exploring the dictionary, it is not a good idea to simply SELECT * FROM whatever, where whatever is some dictionary view. Dictionary views are often long and wide --wide because there are often many attributes and many of those attributes are not necessarily interesting.

c. Display the owner and table_name from All_tables where owner = ‘your userid’.

CREATE THE TABLE FOR only for Student, GradeReport, and Section QUESTION 4-9.

4-9. For all the tables in the Student-Course database --Student, Grade_report, Section, Room, Course, Prereq, Department_to_major, list the attributes, number of rows, number of distinct rows, and number of rows without nulls. As you gather the information, put the information in a tabular format, as shown below (Note, you may want to create this table in your word processor as you gather the information.)
Table Attribute Rows Distinct Rows Rows without Nulls Student stno
48
sname major
class Section section_id etc.
Also, there is probably no “one” query to give you this information. You will have to fi nd this information using separate queries, and then put the information together in a tabular format. Hint: You can use:
SELECT COUNT (*) FROM Student WHERE sname IS NULL

You and two friends are on a game show. Each of you enters the studio with a hat on your head. There are two colors of hats: red and blue. They are assigned randomly, so each person has a 50% chance of a red hat and a 50% chance of a blue hat. Each person can see the hats of the two other people, but they can't see their own hat. Each person can either try to guess the color of his or her own hat or pass. All three of you do it simultaneously, so there is no way to base your guess on the guesses of your friends. If nobody guesses incorrectly and at least one person guesses correctly, then you all share a big prize. Otherwise you all lose. If everybody randomly guesses and nobody passes what is the probability that you will win?

Since you are all friends, and you all know how the game works, you develop a strategy with your friends before the show to maximise your probability of winning. (Note: if your strategy requires a particular person to speak regardless of what hat colours you all see then that person is you. In cases where both colours are equally attractive then you will pick red.)
When you walk onto the stage you can see that both of your friends have blue hats on.
What colour should you guess?
(a) Red (b) Blue (c) Stay silent

When you walk onto the stage you can see that one of your friends has a red hat on and the other friend has a blue hat on. What colour should you guess? (
a) Red (b) Blue (c) Stay Silent
What is the probability that you will win using the best strategy?

Explain the significance of the quote below. Who wrote it? Who were they writing to? What did they say? Why is it important? Your answer should be two paragraphs. In the first, answer the previous questions. In the second, describe the significance in context with the broader history of imperialism.

Swaying the wide world, I have but one aim in view, namely, to maintain a perfect governance and to fulfill the duties of the State: strange and costly objects do not interest me. If I have commanded that the tribute offerings sent by you, O King, are to be accepted, this was solely in consideration for the spirit which prompted you to dispatch them from afar. Our dynasty's majestic virtue has penetrated unto every country under Heaven, and Kings of all nations have offered their costly tribute by land and sea. As your Ambassador can see for himself, we possess all things. I set no value on objects strange or ingenious, and have no use for your country's manufactures. This then is my answer to your request to appoint a representative at my Court, a request contrary to our dynastic usage, which would only result in inconvenience to yourself. I have expounded my wishes in detail and have commanded your tribute Envoys to leave in peace on their homeward journey. It behooves you, O King, to respect my sentiments and to display even greater devotion and loyalty in future, so that, by perpetual submission to our Throne, you may secure peace and prosperity for your country hereafter.

CORPORATE FINANCE: USE THE INFORMATION PROVIDED IN CASE STUDY PART ONE TO ANSWER THE QUESTIONS IN CASE STUDY PART TWO    Case Study-Part One

A.    From the company you selected, provide the following core business information and characteristics:

1. The company name and ticker symbol. Duke Energy Corporation (DUK)

2. Provide a brief description of this company and the type of product and/or services it provides. If it is a diversify entity, please provide a general description of its operations. Duke is the largest electric power company in the US, serving Americans since 1904

3. Identify the core business of the company. Duke core business is to drive its value going forward

4. Identify the management structure of the company. This can be done by simply pasting the corporate structure flowchart. The flowcharts are located on the next pages

5. Identify the market in which this company is publicly traded. NASDAQ

6. Identify the country in which this company operates (if it is a Multinational Corporation just say Multinational Corporation). Duke Energy Corporation only operates in the United States

7. Identify the major business and financial risk the company faces along with any major competitors if any.

8. Identify any regulatory or legal institutions that this company is subject to.

    (a) Code of Business Ethics (b) Principles of Corporate Governance (c) Board of Directors    (d) Stock Ownership Guidelines Policy (e) Security Trading Policy (f) Regulation FD Policy (g) Related   Person Transaction Policy (h) Political Participation (i) Political Expenditures Policy (j) Principles for Health Care Reform (k) Board Committee Charters

B. From the company you selected, present the following financial information for year-end 2017:

1. What is company’s total market capitalization? $53.27 Billions

2. What is the company’s book value amount? $59.63 (As of December 2017)

3. What is the company’s total amount of outstanding liabilities? $96,175,000

4. What is the company’s total amount of assets outstanding? $137,914,000

5. What is the total amount of long-term debt outstanding? $49,035,000

6. What is the total amount of common equity outstanding? ($67,000)

7. What was the company’s total year-end resulting net income? $3,059,000

8. What is the effective year-end taxes paid by this company? $1,196,000

9. What was the company’s total year-end amount of reported earnings? If it is the same as total net income, the just state total net income. $3,059,000

10. What was the total year-end amount of dividends declared by this company?     A cash dividend payment of $0.89 per share was scheduled to be paid on December 18, 2017. This represents an 4.09% increase over prior dividend payment.

11. What was the year-end dividend retention policy by this company? At the current stock price of $91.09, the dividend yield is 3.91%

12. What was total year-end amount of dividends paid, if any, by this company? $0.890

13. Identify the total year-end amount of shares outstanding. DUK's current earnings per share, an indicator of a company's profitability, is $3.37. Investment Research reports DUK's forecasted earnings growth in 2017 as -2.03%, compared to an industry average of 4.4%.

C. From the company you selected, present the following financial and valuation metrics for year-end 2016:

1. What was the current market stock price for this company? You could also use the 2016-year end average price or the year-end closing price. If you do so, please state what market stock price you are using. payment. At the current stock price of $86.12, the dividend yield is 4.13%.

2. What is the company’s year-end earnings per share (EPS)? 4.36

3. What is the company’s year-end dividends per share (DPS)? $3.03

4. What was the company’s year-end book value per share (BVPS)? 56.63

5. What is the company’s current dividend yield? You could also use the 2016-year end average dividend yield. If you do so, please state?

6. What is the company’s beta coefficient? 0.16

7. What is the company’s earnings price multiples (P/E)? 17.64

8. What is the company’s market to book ratio (M/B)?

Case Study-Part Two

A.      Using the information from Case Study Part one, answer the following questions using Ratio Analysis:

1.            State your company’s Total Assets (TA) Turnover Ratio:

a)            Is your company managing its assets efficiently? What would you recommend your company to do to improve its asset management?

2.            State your company’s debt ratio and Times-Interest-Earned (TIE) Ratio:

a)            Is your company managing its debt issuances efficiently? What would you recommend your company to do to improve its asset and debt management?

3.            State your company’s Return on Total Assets (ROA)?

a)            Is your company having enough ability to turn its assets into net-income?

4.            What is your company’s ROE?

B.     Using the information from Case Study Part one, answer the following questions using market value analysis:

1.           Using yahoo finance, answer the following:

a)            What is the expected price earnings ratio (expected P/E).

b)            How does the current ratio (P/E) indicate compared to the expected P/E ratio?

c)            Is it undervalue based on expected P/E ratio? Please explain.

2.           Using the ROE in the section A, answer the following:

a)            Assuming an investment of 20 years, what is the present value of this stock?

b)            Is the present value higher or lower than the current stock price?

c)            Would you consider this stock be undervalue or overvalued? Please explain.

3.           Answer the following:

a)            What would be the company’s current indicated dividend?

b)            What is the company’s expected Dividend?

c)            What would be the company’s expected dividend yield, using the current price and expected dividend?

d)            What is the Company’s expected growth rate in earnings?

e)            What is the company’s expected growth in dividends?

f)             What is the company’s dividend payout and/or earnings retention rate?

g)            Is this dividend policy sustainable?

4. Using a Discounted Cash Flow (DCF) analysis with the information in part B, section 4, answer the following:

a)            What is the DCF expected ROE?

b)            Is the expected ROE higher or lower than the realized ROE in part A?

c)            What can you conclude about the difference between the expected ROE and the realized ROE in part A?

5.           Assuming a 5% historical risk-free rate of return, and a 10% market return, answering the following?

a)            What is the market expected risk premium?

b)            Using Capital Asset Pricing Model (CAPM), what is the expect company’s risk premium?

c)            How this expected return compares to the other ROE’s?

c.      Using the information from Section A and B, what is your final evaluation and recommendation regarding your company’s stock?

6.2_What is the meaning of the term busy waiting? What other kinds of waiting are there in an operating system? Can busy waiting be avoided altogether? Explain your answer.

7.4_Describe how deadlock is possible with the dining-philosophers problem.

Why is it necessary to have an atomic instruction for providing access to a critical section?

Antibody titer is a measure of activity, not actual concentration. Explain why titer is a measure of activity, not a concentration. Please use the following example: You have anti-sheep red blood cells from two different companies, both with the same concentration, but one has a high titer and one with a low titer.

Option 1 – the Reference Letter

Background

You need a reference letter from someone to accompany a resume and job application. When you ask the referee to write you a letter of reference, they state they would be happy to, but they are very busy. They ask you to draft a letter of reference that they will review, revise, and sign.

Your Assignment

Draft a 250-word (maximum) reference letter for yourself. Write it as if someone else is writing about you.  

Use proper business letter format with FULL BLOCK formatting. If you need to make up any details such as addresses, that is fine. You may address your letter to me if you wish.

Remember you will be writing about yourself. Think about the best qualities you have that would recommend you for a job in your chosen field. What would you like to have highlighted for a specific potential employer?

Human Physiology

1. Describe the events that lead to micturition (urination), including the effect of the nervous system on the muscles involved.
2. Explain the concept of transport maximum. Under what scenario would glucose appear in the urine?
3. Explain in detail the process that establishes and maintains the medullary osmotic gradient in the kidneys. Then describe the effect this osmotic gradient has on the water in the renal tubules.
4. Explain what conditions stimulate the release of ADH by the posterior pituitary. Then describe in detail the effect of ADH on cells lining the collecting duct.
5. Describe the effect aldosterone and ANP have on sodium levels in the blood.