No Hand drawings, please.

Consider the following scenario and then answer the corresponding questions.

ABC Travel and Tourism specializes in providing tourist packages to customers across the globe and the company has decided to develop an in-house software system that will help customers search for travel destinations based on popularity, budget, visa restrictions, government policies and attractive climatic conditions. Customers will also be able to book their air tickets, hotel and transportation (rental car, public transportation, cab services) through this system. Prior to the booking, the system will allow users to check for their visa eligibility to travel to destinations outside of their country of citizenship. Users will also be able to review and rate destinations or hotels using the system. The company also offers pre-set packages and if a customer decides to go with a specific package, they will be asked to provide the dates for their travel. The system will find an airline reservation, hotel/ transportation choices and create an itinerary for the customer. Customers will not be allowed to customize the pre-set packages.

Once the booking is done, the system should send a notification to the users on the purchase confirmation within 2 hours. Cancellations will incur a 25% penalty, if users are “Gold” members. In all other cases, the reservations will be non-refundable. Customers can pay using their credit cards or Paypal.

Upon your review complete the following:

1. Identify ALL MAJOR the tables relevant this case, the primary key, foreign keys, attributes and data types. For each table, list the fields, description, datatype and description about that field as suggested in the format below. (30 pts). (Hint: Refer to your class diagram).

2. Apply 1^st, 2^nd and 3^rd normalization rules for your tables. Explain how each table satisfies these normalization rules. (Hint: You may end up creating intersection tables as needed, in addition to the tables identified for question #1). (20 points)

(Please see normalization examples from the lecture notes and show the normalization process for the tables as applicable)

3. Draw an ER diagram for this case including the tables, relationships, cardinality and all the fields. (10 points)

FRAUDD EXAMINATION

Case 4

Stephanie Adkins is an accountant who is trained in forensic accounting. She is an experienced fraud investigator. She was recently hired by Lake Side Hotels, a closely-held corporation, to investigate a company manager who is suspected of taking kickbacks from vendors.

Stephanie gave Lake Side her standard engagement letter stating that the scope of the engagement would be limited to investigating only one suspect. It did not guarantee findings or results.

According to the provisions of Stephanie’s engagement, she was to communicate directly with Bernie James, the company’s controller, and Amanda Peterson, the outside attorney.

At the first meeting of this team, Bernie indicated that Lake Side had received four separate anonymous tips about possible kickbacks. All the tips indicated that Laurie Miller, an evening manager, was taking kickbacks from food vendors. One tip named a particular vendor, the Mid States Beef Source, a company that supplies meat to the hotel’s restaurants.

Stephanie asked if Bernie had any documentation that supports Laurie Miller’s possible involvement in kickbacks. Bernie had no documentation but hoped Stephanie could help them substantiate the information from the anonymous tips. He was concerned that kickbacks would hurt the hotel financially.

Amanda, the outside attorney, said that she had already talked to several hotel employees and was convinced that Laurie was guilty.

Kickback schemes can be difficult to uncover, so Stephanie wanted to proceed cautiously.

Bernie wanted to confront Laurie immediately. He was convinced she would confess if he told her that he had evidence against her.

Stephanie asked what evidence Bernie had. Bernie said, “Only the anonymous tips, but I know she will confess if we bluff.” It was against Stephanie’s professional principles to lie and she said so.

“Detectives do it all the time on cop shows,” Bernie said. Stephanie insisted she would need to run the investigation her way or she wouldn’t be able to undertake this engagement.

In relation to this scenario, write responses to the following:

What steps might Stephanie follow to proceed with her investigation?

What mistakes, if any, have already been made in the investigation?

Which of the following is an example of adverse possession?

B. Sally owned a one-acre lot next to a state park. She decided to donate the lot to the state in order to expand the park. Sally’s children claimed they had a right to the land, not the state.

C. In 2005, Megan fenced off a field belonging to Farmer Giles, put a new lock on the gate leading to the field, built a wooden shed, and grew vegetables on the land. After 10 years, Megan gained title to the land without paying Farmer Giles.

D. Bob needed a place to stay so he broke into an empty house and stayed there for nearly a month until the house owner asked the police to make Bob leave.

A. Years ago, your grandmother bought 10 acres of land, paid the property taxes, and left you the property in her will.

A landowner builds a nine-foot fence topped with barbed wire around his property to keep people out, and posts warning signs on the fence saying “DANGER: Barbed Wire.” A group of graduate students decides to go cow tipping on the landowner’s property. The students climb the fence in the night, and one student suffers injuries from the barbed wire. What duty of care does the landowner owe to the students?

D. No duty because the student trespassed onto the owner’s land

B. A duty not to intentionally injure and to warn about known defects on the property

A. A duty not to intentionally injure the student

C. A duty to inspect the property for defects, correct defects, and warn about defects

Marta places a large, pre-assembled plastic greenhouse in her backyard, with the steel frame bolted into concrete that she poured specially for that purpose. She attaches gas-heating ducts and builds a brick walkway around the greenhouse. Now the town wants to raise her real property taxes, claiming that her property has been improved. Marta argues that the greenhouse is not real property. Is it?

E. The greenhouse is an easement and is part of the real property.

C. The greenhouse cannot be part of the real property if Marta does not own the land.

B. The greenhouse is not part of the real property because it could be removed.

D. The greenhouse is a fixture and is part of the real property.

A. The greenhouse is not part of the real property because it was pre-assembled.

A developer wants to subdivide a parcel of land into 35 lots to be used for residential construction. The projected sale price of the developed lots is $1,000,000. The site development costs are set forth below: (5points). Development costs $300,000 Management and supervision 15,000 Contractor’s overhead and profit 100,000 Sales Expense 35,000 Taxes 20,000 Entrepreneurial profit 50,000 TOTAL $520,000 What value is indicated if the development and marketing period is projected to be three years and the market-derived discount rate is 8%?

Write about history of Heron's fountain using around 200 words, discuss the construction process using 500 words (make sure to include pictures, you can draw them or find them online) discuss using physics concepts and mathematical equations, and then discuss using around 500 words the application of heron's fountain and its futher developments in science. You can include information about how a fountain works, explantions about hydraulics and pneuamtics.

The reserve ratio is 20 percent. The Fed buys $1 million in government securities from a bond dealer by transmitting the funds to the dealer's deposit account at Bank A. Bank A makes the maximum loan possible to a construction company, which buys materials with the loan. The check is deposited in Bank B, which loans out all it can to a car dealership. To this point, the money supply has increased by.. A)$1 million B)$1.8 million C)$2.44 million D)$3 million.

Explain how will each of these affect the economy in the short run and the long run (in terms of output, unemployment and inflation) 3. For each of the following what kind of monetary policy do you suggest?

a. Government decides to take policy to reduce deficit.

b. Construction workers goes on a strike for 2 months.

c. US dollar depreciates with respect to euro

d. People become more optimistic about the economy

e. Productivity of U. S workers increase due to technological advancement

1. A) Explain concepts of firm-specific risk, systematic risk, covariance, beta and how they are relevant for portfolio construction. Discuss what CAPM model implies for investors.

2. You are considering two stocks – Stock A with expected return of 8% and CAPM beta of 1.20 and Stock B with expected return of 11% and beta of 0.80. If the risk-free rate is 3 percent and the market risk premium is 6%, discuss whether these stocks are properly valued or not based on Security Market Line. Are they under- or over-valued?

1-4): True or False?

1) The sample statistic is at the center of a confidence interval for that statistic.

2) In a hypothesis test, increasing the significance level increases the chance of making a type 1 error.

3) Failure to reject the null hypothesis test in a hypothesis test implies strong support for the null hypothesis.

4) When no prior belief about a population characteristic is held, construction of a confidence interval, rather than the use of hypothesis testing, is used to estimate the population characteristic.