Write the balanced reaction equation for the precipitation of calcium carbonate from
potassium carbonate and calcium chloride. Don't forget to show the states of matter.

Scotland has been a member of the United Kingdom since the 1707 Act of Union. In a recent poll, 38% of Scots would vote in favor of leaving the U.K. A random sample of 135 Scots was selected. What is the probability that between 50 and 60 of them were in favor of leaving the U.K.?

The Wolfpack Corp. is a U.S. exporter that invoices its exports to the United Kingdom in British pounds. If it expects that the pound will depreciate against the dollar in the future, explain to Wolfpack Corp. how a forward contract and an option contract can help hedge its cash flows that are received in foreign currency.

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)

The Town of Brown has the following financial transactions:

1. The town council adopts an annual budget for the general fund estimating general revenues of $2.0 million, approved expenditures of $1.6 million, approved transfers pf $150,000.

2. The town levies property taxes of $1.5 million. It expects to collect all but 4% of these taxes during the year. Of the levied amount, $50,000 will be collected next year but after more than 60 days.

3. The town orders three new police cars at an approximate cost of $120,000.

4. A transfer of $60,000 is made from the general fund to the debt service fund.

5. The town makes a payment on a bond payable of $50,000 along with $15,000 of interest using the money previously set aside.

6. The Town of Brown issues a $3 million bond at face value in hopes of acquiring a building to convert into a high school.

7. The two police cars are received with an invoice price of $115,000. The voucher has been approved and will not be paid for three weeks.

8. The town purchases the building for the high school for $2.5 million in cash and immediately begins renovating it.

9. Depreciation on the new police cars is computed at $35,000 for the period.

10. The town borrows $120,000 on a 30-day-tax anticipation note.

11. The Town of Brown begins a special assessment curbing project. The government issues $900,000 in notes at face value to finance this project. The town has guaranteed the debt if the assessments collected do not cover the entire balance.

12. A contractor completes the curbing project and is paid $900,000 as agreed.

13. The town assesses citizens $900,000 for the completed curbing project.

14. The town collects the special assessments of $900,000 in full and repays the debt plus $40,000 in interest.

15. The town receives a $20,000 cash grant from a regional charity to beautify a local park. The grant must be used to cover the specific costs that the town incurs.

16. The town spends the first $5,000 to beautify the park.

Question 1. – Please prepare journal entries for the town based on the production of fund financial statements.

Question 2 – Please prepare journal entries in anticipation of preparing government-wide financial statements.

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 consumer advocacy group published a study of labeling of seafood sold in three U.S. states. The study found that 15 of the 25 ​"red snapper" packages tested were a different kind of fish. Assume that the study used a simple random sample. Complete parts a through c below. ​

a) Are the conditions for creating a confidence interval​ satisfied? Explain.

A. ​Yes, because the sample is a simple random​ sample, the sample proportion is between​ 10% and​ 90%, and there are at least 20 expected​ "successes" and 20 expected​ "failures."

B. ​Yes, because the sample is a simple random​ sample, the sample is less than​ 10% of the​ population, and there are at least 10 expected​ "successes" and 10 expected​ "failures."

C. ​No, because the sample is a simple random​ sample, the sample is less than​ 10% of the​ population, and there are at least 10 expected​ "successes" and 10 expected​ "failures."

D. ​No, because the sample is a simple random​ sample, the sample proportion is between​ 10% and​ 90%, and there are at least 20 expected​ "successes" and 20 expected​ "failures." ​

b) Construct a 95​% confidence interval for the proportion of​ "red snapper" packages that were a different kind of fish. (___________ , _____________) ​(Round to three decimal places as​ needed.) ​

c) Explain what the confidence interval from part​ (b) says about​ "red snapper" sold in these three states. Select the correct choice below and fill in the answer boxes within your choice. ​(Round to one decimal place as​ needed.)

A) One is 95% confident that between ________% and ______________% of all red snapper sold in food stores and restaurants in these states is not actually re snapper.

B) 98% of the time, the true proportion of red snapper sold in these three states is falsely labeled is between__________% and ________%.

C) One is 95% confident that between ______% and ________% of all red snapper purchased for the study in these states was not actually red snapper.

D) No, because the sample is a simple random sample, the sample proportion is between 10% and 90% and there are at least 20 expected "successes" and 20 expected "failures".

The body goes through absorptive and postabsorptive states throughout the course of 24 hours, as illustrated in Figure 25-11 in your textbook. The nutrient pools (glucose, amino acid, and fatty acid) illustrated in Figure 25-1 vary in size during these states as the body absorbs these nutrients from food, uses them for energy production, puts them into or releases them from storage, or builds/breaks down body structure.The body has multiple hormonally-driven mechanisms by which to maintain a relatively constant glucose pool in order to ensure that adequate glucose is always available for the brain.  Neurons rely almost exclusively on glucose and cannot use fatty acids or amino acids as an alternate source.

The mass balance equation can be applied to the glucose pool.  Recall that the equation states that in order to maintain balance of a particular substance, the intake of that substance + its metabolic production must equal excretion of that substance + metabolic removal of that substance.

Intake + metabolic production = Excretion + metabolic removal

1. Your first task is to apply the mass balance equation to the maintenance of the glucose pool during the absorptive and postabsorptive states.  

For each state, you need to explain how each of the parts of the equation contribute to increases/decreases in the glucose pool, and the internal mechanisms that are employed to counteract those changes to restore balance. As part of your explanation, you need to include the specific organs/tissues, hormones, and metabolic processes that are involved.  For each hormone, include what leads to its release, cell types it targets, and what it stimulates the targets to do.

2. Your second task is to apply the mass balance equation to the regulation of blood glucose, or lack thereof, in someone who suffers from diabetes mellitus.   Describe what part(s) of the equation are not functioning properly.  Uncontrolled diabetes mellitus is associated with a number of classic symptoms:  excessive hunger and thirst, weight loss, and excessive urination.  Explain these symptoms by applying the mass balance equation, absorptive vs. postabsorptive states, and nutrient pools.