Reference no: EM13950158
The State and Capital relations, shown in the attached figure are described as follows:
- State (StateAbbrev, StateName, EnteredUnionOrder, StateBird, StatePopulation)
- Capital (Capital Name, State Abbrev, YearDesignated, PhoneAreaCode, CapitalPopulation)
- Foreign key: StateAbbrev to State relation
- Add the attribute CountyName for the county or counties containing the state capital to this database.
- Justify where you placed it (that is, in an existing relation or in a new one).
- Draw the entity-relationship diagram for all of the entities using the AutoShapes in Microsoft Word.
Note: The counties for the state capitals shown in the figure above are Travis and Williamson counties for Austin TX; Hartford county for Hartford CT; Clinton, Eaton, and Ingham counties for Lansing, MI; Davidson county for Nashville TN; Hughes county for Pierre SD
![1549_tables.png](https://secure.expertsmind.com/CMSImages/1549_tables.png)
What is the bond nominal yield to call
: Keenan Industries has a bond outstanding with 15 years to maturity, an 8.25% nominal coupon, semiannual payments, and a $1,000 par value. The bond has a 6.50% nominal yield to maturity, but it can be called in 6 years at a price of $1,150. What is th..
|
What was your rate of return on providien stock
: Ten years ago you invested $1,000 for 10 shares of Providien, Inc. common stock. You sold the shares recently for $2,000. While you owned the stock it paid $10.08 per share in annual dividends. What was your rate of return on Providien stock?
|
How to determine the amount of selling
: You are managing a hedge fund. Today, you find that the stock of Microsoft is undervalued. So, you would want to buy Microsoft stocks. But you know that buying the stocks only will make you exposed to risk even if the stock is actually undervalued. H..
|
At what stock price at maturity will you break even
: Consider a 3-month European put option on a non-dividend-paying stock, where the stock price is $60, the strike price is $60, and the risk-free rate is 3% per annum. Suppose that put options on a stock with strike prices $45 and $55 cost $4 and $9, r..
|
Draw the entity-relationship diagram for all of the entities
: Note: The counties for the state capitals shown in the figure above are Travis and Williamson counties for Austin TX; Hartford county for Hartford CT; Clinton, Eaton, and Ingham counties for Lansing, MI; Davidson county for Nashville TN; Hughes co..
|
What is the firms debt ratio
: Dearborn Supplies has total sales of $196 million, assets of $90 million, a return on equity of 30 percent, and a net profit margin of 7.9 percent. What is the firm's debt ratio?
|
Cost of new stock exceed the cost of retained earnings
: Eakins Inc.’s common stock currently sells for $55.00 per share, the company expects to earn $2.75 per share during the current year, its expected payout ratio is 70%, and its expected constant growth rate is 6.00%. New stock can be sold to the publi..
|
Consider when borrowing funds in a foreign currency
: Explain what an MNE needs to consider when borrowing funds in a foreign currency. As part of your answer, explain what happens if the foreign currency of the borrowed funds appreciates or depreciates, how you calculate the effective cost of borrowing..
|
Essential aspect of healthcare financial management
: An essential aspect of healthcare financial management for any medical facility is the year-end closing. What are the primary accounts that must be addressed in the year-end closing process? List these accounts, and briefly describe the procedure for..
|