John owns a portfolio of rental properties with his parterns. He wants to develop a database to store property information as well rental data. Below are some of the data that need to be kept track of.
A. For each property, the database needs to store property address, size, number of rooms and bathrooms, and purchase date.
B. There are two types of properties – single family house and condo. Need to store yard size for single family house and monthly HOA(Home Owner Association) fee for condo.
C. For current and potential customers, need to store customer name, current address, family size, and contact phone number.
D. A customer needs to submit an application to rent a property. Need to track application submission date, potential start date, application result and explanation.
E. Once approved, a lease will be signed and need to track start date, end date, sign date, montly rent, and deposit amount.
F. Need to track montly payment information including payment amount, pay date, and payment method.
G. A customer can set up different payment methods. Each method includes financial institute name, address, and account number. There are two types of methods – credit card and check. For credit card, need to store expiration date and security code. For check, need to store bank routing number.
Please complete the following tasks to design the database to meet requirements specified. State any relevant assumptions you make, but do not add any additional data requirement unless it is really necessary.
I. Identify entities and attributes. List entity name and attribute names for each entity.
II. Identify relationships among entities. List relationship type in terms of cardinality and specify business rules (e.g. 1:M between Library and Branch: a library has many branches; a branch belongs to one and only one library).
III. For each entity, identify primary key and foreign key if applicable. If you use surrogate key for PK, also specify business unique key (natural key). For FK, also specify parent entity and the matching attribute in parent entity.
IV. Create ERD using crow’s foot notation using ER Assistant or Visio. The ERD should incorporate all items mentioned in I, II, and III (NOTE: I, II, and III still need to be answered separately in narrative format).
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Is A Warehouse Supervisor Who Works For A National Company That Sells High
/in Uncategorized /by developerJohn is a warehouse supervisor who works for a national company that sells high-quality (and very expensive) electronics – e.g., HD television sets, business and home computers, and business and personal laptops. John has a high school education, and has been employed by the company for 10 years. Recently, John was promoted to an exempt (salaried) low-level management position; his present annual salary is $60,000. Over the past two months, John has been stealing HD television sets from his employer – and reselling them. To date, he has stolen $15,000 in merchandise. When John’s wife – Jane – takes note of the rapid growth in the family’s savings account, she asks John about the source of the money. John’s astonished response is: “Jane! Are you kidding? Consider the extra money as a company bonus — well, it’s sort of a bonus anyway….Look, Jane, while I make better money than I used to, it’s not enough compensation for all the stuff I do. This company can afford to pay me far more than what they pay – and they choose not to. The way I look at it, I’ve earned this extra money! It’s a well-deserved and hard-earned bonus, Jane. You know that we can barely pay our bills. I’m doing what is best for our family! I have to do what I think is best for my family, even if I know it might be wrong!”
What are the utility ethics raised in this situation? Be specific! Please provide reference.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Is Saving For A Car In A Bank Account That Pays 12 Interest Compounded Mont
/in Uncategorized /by developerJohn is saving for a car in a bank account that pays 12% interest, compounded monthly. The balance is now $ 2,400. Clem will be saving $ 120 per month from his salary, and once every four months (starting in 4 months) he adds $ 200 in dividends from an investment. Bank fees, currently $ 10 per month, are expected to Increase by $ 1 per month henceforth. How much will Clem have saved in two years?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John James Rolly Is The Cfo Of Sd Yachts Inc A Manufacturer Of Boat Fenders For
/in Uncategorized /by developerJohn James Rolly is the CFO of SD Yachts Inc., a manufacturer of boat fenders for luxury yachts. Rolly is considering the purchase of a 2 to injection mold, which will allow the company to mold boat fenders. The equipment cost $250,000. The project is expected to produce after tax cash flows of $60,000 for the first year, and increase by $10,000 annually; the after-tax cash flow in year 5 will reach $100,000. Liquidation of the equipment will net the company $10,000 in cash at the end of 5 years.
a) Assume that the required return is 15%. Is the project profitable?
b) Assume that the required return is 19%. Is the project profitable?
c) What is the IRR of the project?
d) How will your answer change to part (a) if the company does not net anything on the liquidation of the equipment?
SD Yatch Inc.,MouldInitial CostNet asset costInitial outlay $$ 250,000.00250,000.00 $ 0(250,000.00) Incremental Cash flowsa The required return is 15%YearInitial outlayAfter tax salvage…
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Jetison Believes He Would Need 500 000 To Retire Today And Keep His Same Li
/in Uncategorized /by developerJohn Jetison believes he would need $500,000 to retire today and keep his same lifestyle. If Jetison estimates he will retire in 20 years, how much should he put away each month to have the equivalent of $500,000 in 20 years if the interest he can earn is 5%? If the interest rate changes to 3%, what will Jetison need to save each month? Picture cash flows on a timeline and present it when providing your answer. Think about your own retirement; what would the timeline look like? In what ways could you better prepare for retirement?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Likes To Play Futsal Football 5×5
/in Uncategorized /by developerJohn likes to play futsal (football 5×5). The number of times per year that he plays depends on both the price of playing an hour of futsal as well as John’s income and the cost of alternative types of entertainment and, in particular, how much it costs to go see a movie instead of playing futsal. The three demand schedules in the table below show how many games of futsal per year John will demand at each price under three different scenarios. In scenario D1, John’s income is €50,000 per year and movies cost €9 each. In scenario D2, John’s income is also €50,000 per year, but the price of seeing a movie ticket rises to €11. And in scenario D3, John’s income goes up to €70,000 per year while movies cost €11.
Using the data under D1 and D2, calculate the cross elasticity of John’s demand for futsal at all three prices. Is the cross elasticity the same at all three prices? Are movies and futsal substitute goods, complementary goods, or independent goods?
Using the data under D2 and D3, calculate the income elasticity of John’s demand for futsal at all three prices. Is the income elasticity the same at all three prices? Is futsal an inferior good?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Likes To Play The Instant Lottery He Likes A Particular Game That Claims To
/in Uncategorized /by developerJohn likes to play the instant lottery. He likes a particular game that claims to have a probability of a winning ticket to be 11%. Suppose he obtains six lottery tickets independently. What is the probability that he will win on AT LEAST one of those tickets?
(Show your work)
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Moore A 22year Old Patient Who Weighs 150 Pounds Presents To The Emergency
/in Uncategorized /by developerNeed breif answers for these questions, much appreciated.
2. John Moore, a 22—year-old patient who weighs 150 pounds, presents to the emergency deparbnent (ED) after being thrown front his horse and passing out for a few minutes; heregained consciousness. The friend who was also riding a horse called the squad. The patient presented with a Glasgow IComa Scale {GCS} of 15, and the neurologic ezam waswithin normal limits ML). The EU physician wrote the orders for a CT scan without contrast of the head, CBC, renal and metabolic profile, PT, PTT, and Hill. The nurse sentthe labs and had the Pit of NS at keep-open rate per ED protocol hanging. The nurse was awaiting radiology to call for the patient to go for the ET when the patient had anepileptic cry, became unconscious, stiffened his entire body, and then had violent muscle contractions. The resp irations are very shallow, and the lips and nail bed became blue. The patient lost control of bladder and bowel. The patient bit his tongue and blood iscoming from the mouth. The radiology deparunent calls and is ready for the patient. {Learning Objectives Tr’ and 3] a. List in the correct order the actions that should be taken by the nurse. b. Ezplain what type of seizure the patient is having, and describe the fl’ll’EE phasesof the patient’s seizure and the specific nursing care for each stage. c. The ED physician orders the following: 1i.laliurn {diazepanr} 1E] mg every ill to 15minutes PEN for seizures (maximum dose of St] mg}. Once seizures stop, adrninister Dilantin (phenytoin) ll] nigflrg WPE. ECG monitoring continuously,vital signs, GCS, neurologic checlrs every 3t] minutes. Ezplain what medications the nurse should provide, in what order, and how they should be administered.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Nash And His Buddy Return To The Bar In Which A Few Weeks Ago They Failed T
/in Uncategorized /by developerJohn Nash and his buddy return to the bar in which a few weeks ago they failed to secure either a blonde or a brunette. This week they have a new plan. First, John will choose a girl to approach. Then, afterobserving the girl that John approaches, his buddy will choose a girl to approach (he can approach the same girl that John has approached or either of the other ones). There are still 3 girls: one blonde (B) and two brunettes (b1, b2) in the bar. Both John and his friend still prefer blondes to brunettes. They will be successful in approaching any girl, unless she is approached by both of them, in which case they leave the bar with nothing. Represent this situation as an extensive form game. *Which of the following is a Nash equilibrium of the game, but not a subgame perfect equilibrium? For the strategy of John’s friend, let the items in his strategy vector (.,.,.) represent his choices following John’s choosing B, b1 and b2 respectively(a) b1, (b2,B,B)(b) b1, (B,B,B)(c) b1, (b1,B,b2)(d) None of the above. *Which of the following is a Subgame Perfect equilibrium of the game?(a) B, (b1, b1, b1)(b) B, (b1, b2, B)(c) B, (b1,B ,B)(d) None of the above.
John Nash and his buddy return to the bar in which a few weeks ago they failed to secure eithera blonde or a brunette. This week they have a new plan. First, John will choose a girl toapproach….
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John One Of The Owners Of Mi Casa Front Porch Restaurant Has Been Working With T
/in Uncategorized /by developerJohn, one of the owners of Mi Casa Front Porch Restaurant has been working with the Chef, Maria to potentially add a new item to the menu. He sampled 50 of his regular customers and asks them if they would like the new item on the menu, 37 said yes and 13 said no. Determine the sample proportions of customers that would like the new item on the menu and determine the standard error of the proportion. How would this standard error influence John’s decision?
Answer the questions below in essay format. Your essay must include an introduction, a body, and a conclusion, and it must address all relevant parts of each question. Your response should be a minimum of 150 words in length and include both the appropriate statistics and support for the analysis and interpretation. Make sure to cite any source you use. Proper citation format for a source includes the name of the author(s), the title of the work, the date of the publication, and the page number if you directly quote the source.
Using the scenario above, identify the standard error of the proportion and determine the impact of the error on potential decision making by Mi Casa Front Porch Restaurant leaders.
What should the company do based on the information calculated?
John, one of the owners of Mi Casa Front Porch Restaurant has been working with the Chef,Maria to potentially add a new item to the menu. He sampled 50 of his regular customers andasks them if…
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
John Owns A Portfolio Of Rental Properties With His Parterns He Wants To Develop
/in Uncategorized /by developerJohn owns a portfolio of rental properties with his parterns. He wants to develop a database to store property information as well rental data. Below are some of the data that need to be kept track of.
A. For each property, the database needs to store property address, size, number of rooms and bathrooms, and purchase date.
B. There are two types of properties – single family house and condo. Need to store yard size for single family house and monthly HOA(Home Owner Association) fee for condo.
C. For current and potential customers, need to store customer name, current address, family size, and contact phone number.
D. A customer needs to submit an application to rent a property. Need to track application submission date, potential start date, application result and explanation.
E. Once approved, a lease will be signed and need to track start date, end date, sign date, montly rent, and deposit amount.
F. Need to track montly payment information including payment amount, pay date, and payment method.
G. A customer can set up different payment methods. Each method includes financial institute name, address, and account number. There are two types of methods – credit card and check. For credit card, need to store expiration date and security code. For check, need to store bank routing number.
Please complete the following tasks to design the database to meet requirements specified. State any relevant assumptions you make, but do not add any additional data requirement unless it is really necessary.
I. Identify entities and attributes. List entity name and attribute names for each entity.
II. Identify relationships among entities. List relationship type in terms of cardinality and specify business rules (e.g. 1:M between Library and Branch: a library has many branches; a branch belongs to one and only one library).
III. For each entity, identify primary key and foreign key if applicable. If you use surrogate key for PK, also specify business unique key (natural key). For FK, also specify parent entity and the matching attribute in parent entity.
IV. Create ERD using crow’s foot notation using ER Assistant or Visio. The ERD should incorporate all items mentioned in I, II, and III (NOTE: I, II, and III still need to be answered separately in narrative format).
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"