This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file). You will design a database for this company so that they won’t be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the 3NF of the data.

Create the database in an actual database application (i.e Microsoft Access, MySQL or Oracle, etc.). You must use SQL commands to create the tables in the database (i.e Create Table command). Submit the SQL commands with the completed database as part of the assignment. The tables should be populated with records from the scenario you chose.

A certain city has a population equivalent to 123456 treatment plant which will serve the community until 2040

. a) Estimate the future population of this city in 2020 and 2040 using constant percent method if the rate constant is 0.0327 /year.

b) Determine the water and wastewater treatment plant design capacities for the period of 2020 to 2040. Use maximum (fmax) and minimum (fmin) factors of 2 and 0.5, respectively (Qmax = fmax Qavg and Qmin = fmin Qavg). Assume an average of 200 L/capita-day is the water consumption rate for the city in 2010 and 80% of the consumed water is collected as wastewater. What is the maximum hourly flow?

c) Determine the daily fire protection water requirement in 2020 and 2040?

d) Estimate the size of a tank for the water treatment plant that can store the raw water for 7 day. Take the depth as 3 m. What would be removal percentages of viruses (diameter = 50 nm) and bacteria (diameter = 1 μm) by this tank? Assume the specific gravity of each micro-organism is 1.05 and the water temperature is 20°

e) Estimate the size of equalization tank for the wastewater treatment plant that can hold the raw sewage for 4 hours. Take the depth as 3 m. What would be the size of the smallest particle size with specific gravity 2.0 that can be 100% removed by this tank? Assume that the water temperature is 20°C

2. On March 1, 2010, Jacoby Ltd., a Canadian company, entered into a contract to buy supplies from Hornblower Co., a foreign company, for FC400,000. The contract requires Hornblower to deliver the supplies to Jacoby on July 15, 2010. Payment is required to be made in full upon delivery. On March 1, 2010, Jacoby entered into a forward contract with the bank to purchase FC400,000 on July 15, 2010. As promised, Hornblower delivered the goods on July 15th and payment was made in full. Jacoby has a June 30th year end date.

Spot Rate Forward Rate

March 1, 2010 FC1 = 4.80 CAD FC1 = 4.92 CAD

June 30, 2010 FC1 = 4.83 CAD FC1 = 4.88 CAD

July 15, 2010 FC1 = 4.85 CAD FC1 = 4.85 CAD

Prepare Jacoby Ltd.'s journal entries

a. assuming the forward contract is a cash flow hedge

b. assuming the forward contract is a fair value hedge

The economy of Tuland produces only two products books and watches. The following information is available for production and prices of​ Tuland's products for the years 2009 and 2010.

Using the above​ information, calculate the following values. (Enter your responses rounded to two decimal​ places.)

How did you feel about your new position as programmer Analyst? Do you feel your academic preparation which is MBA has been sufficient for you to be able to fulfil your current job expectations? Explain why or why not.

PLEASE ANSWER IN 350 WORDS AND IN WORD FORMAT ONLY.

THANKS

For some reason another programmer has asked you to write a function.

The function is called getWarYear ( ) It has one parameter , an integer.

if it is 1 return a random number in the range of 1914 to 1919.

if it is 2 return a random number in the range of 1938 to 1945.

Since the function is returning an year the data type of the return value is an integer.

Question 2.
A programmer has to develop an instant messaging app used in mobile phone. He is considering the computer instruction set architecture of either RISC or CISC and the programming method of either translation or interpretation.
(a) Suggest and justify the most suitable instruction set architecture.
(b) Suggest and justify the most suitable programming method

Reveille, Inc uses special strapping equipment in its packaging business. The equipment was purchased in January 2019 for $6,000,000 and had an estimated useful life of 8 years with no salvage value. At December 31, 2020, new technology was introduced that would accelerate the obsolescence of Reveille’s equipment. Reveille’s controller estimates that expected future net cash flows on the equipment will be $3,750,000 and that the fair value of the equipment is $3,300,000. Reveille intends to continue using the equipment, but it is estimated that the remaining useful life is 4 years. Reveille uses straight-line depreciation.

Instructions: please show work

a What is the carrying value of the asset?

b Prepare the journal entry (if any) to record the impairment at December 31, 2020.

c Prepare any journal entries for the equipment at December 31, 2021. The fair value of the equipment at December 31, 2021, is estimated to be $3,450,000.

From inception, 3M has been an innovator, bringing a stream of new products and services to market, creating value for customers, having sustainable advantage over competitors, and delivering sizable returns for investors. Thanks to the predecessor, 3M had lower costs, was highly efficient, and much more profitable. But it no longer ranks among the most innovative firms in the world. In fact, the use of Six Sigma procedures appears to be inversely related to product innovation. If that’s the case, should 3M continue to focus on using Six Sigma procedures to reduce costs and increase efficiencies, or should it strive again to encourage its scientists and managers to focus on innovation? Which of these will make 3M more competitive in the long run?

When people think of innovation, they tend to think of game-changing advances that render current products obsolete, for example, comparing the iPhone to text-based “smartphones.” Innovation, however, also occurs with lots of incremental changes over time. What are the advantages and disadvantages for 3M of each approach (experiential and compression), and when and where would each be more likely to work?

Finally, some companies innovate from within by successfully implementing creative ideas in their products or services. Sometimes, though, innovation is acquired by purchasing other companies that have made innovative advances. For example, although Google is generally rated as one of the most innovative companies in the world, most people have forgotten that Google bought YouTube to combine its search expertise with YouTube’s online video capabilities. Over time, how much should companies like 3M rely on acquisitions for innovation? Should 3M acquire half, one-third, ten percent, or five percent of its new products through acquisitions? What makes the most sense and why?

If you were in charge at 3M, what would you do?