Pine Valley Furniture wants you to help design a data mart for analysis of sales. The subjects of… 1 answer below »

Pine Valley Furniture wants you to help design a data mart for analysis of sales. The subjects of the data mart are as follows:

Data for this data mart come from an enterprise data warehouse, but there are many systems of record that feed this data to the data warehouse. The only fact that is to be recorded in the fact table is Dollar Sales.

a. Design a typical multidimensional schema to represent this data mart.

b. Among the various dimensions that change is Customer information. In particular, over time, customers may change their location and size. Redesign your answer to part a to accommodate keeping the history of these changes so that the history of DollarSales can be matched with the precise customer characteristics at the time of the sales.

Fitchwood Insurance Company, which is primarily involved in the sale of annuity products, would like to design a data mart for its sales and marketing organization. Presently, the OLTP system is a legacy system residing on a Novell network consisting of approximately 600 different flat files. For the purposes of our case study, we can assume that 30 different flat files are going to be used for the data mart. Some of these flat files are transaction files that change constantly. The OLTP system is shut down overnight on Friday evening beginning at 6 P.M. for backup. During that time, the flat files are copied to another server, an extraction process is run, and the extracts are sent via FTP to a UNIX server. A process is run on the UNIX server to load the extracts into Oracle and rebuild the star schema. For the initial loading of the data mart, all information from the 30 files was extracted and loaded. On a weekly basis, only additions and updates will be included in the extracts. Although the data contained in the OLTP system are broad, the sales and marketing organization would like to focus on the sales data only. After substantial analysis, the ERD shown in Figure 9-26 was developed to describe the data to be used to populate the data mart. From this ERD, we get the set of relations shown in Figure 9-27. Sales and marketing is interested in viewing all sales data by territory, effective date, type of policy, and face value. In addition, the data mart should be able to provide reporting by individual agent on sales as well as commissions earned. Occasionally, the sales territories are revised (i.e., zip codes are added or deleted). The Last Redistrict attribute of the Territory table is used to store the date of the last revision. Some sample queries and reports are listed here:

• Total sales per month, by territory, by type of policy

• Total sales per quarter by territory, by type of policy

• Total sales per month by agent, by type of policy

• Total sales per month by agent, by zip code

• Total face value of policies, by month of effective date

• Total face value of policies by month of effective date, by agent

• Total face value of policies, by quarter of effective date

• Total number of policies in force, by agent

• Total number of policies not in force, by agent

• Total face value of all policies sold by an individual agent

• Total initial commission paid on all policies to an agent

• Total initial commission paid on policies sold in a given month by agent

• Total commissions earned by month, by agent

• Top-selling agent by territory, by month

Commissions are paid to an agent upon the initial sale of a policy. The InitComm field of the policy table contains the percentage of the face value paid as an initial commission. The Commission field contains a percentage that is paid each month as long as a policy remains active or in force. Each month, commissions are calculated by computing the sum of the commission on each individual policy that is in force for an agent.

 

A faculty search committee with five members (whose initials are DD, AG, BH, JH, and MY)…

A faculty search committee with five members (whose initials are DD, AG, BH, JH, and MY) evaluated 10 applicants for a faculty position at Enormous State University. Each member gave each applicant a grade of “A” (highly qualified), “B” (qualified), or “C” (unqualified). Ten applicants (listed by codes) and the grades are shown in Table 4.4. Use the majority judgment method to rank these 10 applicants from best to worst.

 

On a B (A3) size sheet make a partial-section assembly drawing of the idler pulley shown in Fig….

On a B (A3) size sheet make a partial-section assembly drawing of the idler pulley shown in Fig. 14-97. Place on the drawing dimensions suitable for a catalog. Add to the drawing an item list and identification part numbers. Scale 1: 1.

 

From elementary physics, we know that when an object 1 answer below »

From elementary physics, we know that when an object is subjected to a constant acceleration a, the relationship between distance d and time t is given by d = ?1 at2. Suppose that, during a seek, the disk in Exercise 14.2 accelerates the disk arm at a constant rate for the first half of the seek, then decelerates the disk arm at the same rate for the second half of the seek. Assume that the disk can perform a seek to an adjacent cylinder in 1 millisecond and a full-stroke seek over all 5000 cylinders in 18 milliseconds. a. The distance of a seek is the number of cylinders that the head moves. Explain why the seek time is proportional to the square root of the seek distance. b. Write an equation for the seek time as a function of the seek distance. This equation should be of the form t = x + ypL, where t is the time in milliseconds and L is the seek distance in cylinders. c. Calculate the total seek time for each of the schedules in Exercise 14.2. Determine which schedule is the fastest (has the smallest total seek time). d. The percentage speedup is the time saved divided by the original time. What is the percentage speedup of the fastest schedule over FCFS?

A big paper to write 1,200 words. How does the stage of a product’s life cycle affect price? You may

A big paper to write 1,200 words. How does the stage of a product’s life cycle affect price? You may include a discussion of marketing skimming and marketing penetration pricing strategies for new products.

Questions: Question 1 “Looking Back” Please respond to the following: • Focusing on the course…

Questions:
Question 1
“Looking Back” Please respond to the following:
• Focusing on the course content and assignments, discuss the single most surprising or interesting thing you learned during this course. Explain what made it so and why you were surprised or interested.
The most surprising and interesting thing that I learned during this course was the amount of resources available to help guide businesses in successful import and export operations. The BIS website alone provided a wealth of information and through additional research and the e-activities I feel that we were exposed to a vast wealth of knowledge.
• In the context of security and regulatory compliance, summarize what you have learned during this course in 50 words or less (about six sentences).
I learned that security and regulatory compliance can be challenging and that following best practices is one of the best ways to ensure success. I learned the the CBP is an agency that is heavily involved in many aspects of our nations security. Another important take-away from this class has been the importance of documentation. Documentation on both the import and export sides require strict attention to detail and it was good to learn that something as simple as a wrong INCO term can seriously effect the outcome.
Question 2
“Looking Back” Please respond to the following:
Focusing on the course content and assignments, discuss the single most surprising or interesting thing you learned during this course. Explain what made it so and why you were surprised or interested.
In the context of security and compliance, summarize what you have learned during this course in 50 words or less (about six sentences).
During this course I have learned so much, from security and compliance to INCO terms. However the single most surprising aspect that I have learned about was the concept of reimbursement importers can receive from re-exporting items that they have originally paid duties on. Of course this is a long and lengthy process, and certain criteria must be adhered to.
From a security and compliance standpoint I have learned so much. First there are many agencies involved with the compliance and security aspects, but the CBP in my opinion leads the way in this objective. This agency leverages fines and penalties for noncompliance as well as inspects cargo for deficiencies. Additionally this agency helps companies become compliant by offering sources of information on their website and assistance by phone if needed. There are programs that companies can join to show compliance one such program is the C-TPAT program. This platform allows organizations to enjoy benefits such as being exempt from stratified exams, accelerated trade processing, access to trades specialists, business resumption, as well as entry to the CBP annual trade conference. Additionally companies can conduct self-audits to ensure compliance as well as view lists of potential customers on these banned exporting lists. Finally companies must ensure that the items that they are exporting comply with mandates set by the US Department of Commerce concerning dual use items. In certain instances licenses are required for these items, the requirements are defendant upon the items mechanical characteristics, the destination, who the end user is, what the purpose of the end user is, as well as other aspects pertaining the end user according to export.gov (2012).
Reference: Export.gov. (2012, October 4). Export.gov – Dual Use Licenses. Retrieved fromhttp://www.export.gov/regulation/eg_main_018229.asp
Question 3
•As international regulations and restrictions have increased significantly since 9/11, speculate how the import / export activities in the U.S. will either increase or decrease over the next 10 years. Explain your rationale.
Overall U.S. economic performance is likely to be poor for the next 10 years if not longer. When US imports more goods and services than it exports the result is a current account deficit. If we want to prevent a snowball effect of decreased exporting and poor economic performance for the next 10 years US should finance the current account deficit, either by international borrowing (not personally recommended) or by selling more capital assets than it buys internationally. US’s international equity market competitiveness has recently weakened significantly. US’s global time sensitive equity market competitiveness challenge faces prompt synergistic mitigation efforts from both government agencies (implementing collaborative reforms that are practical and beneficial for all vested parties) and the private sector corporate support (engage in lobbying and cross-level training amongst its employees and active interaction with government agencies in developing mutually beneficial regulatory and security conscious reforms) to observe diligently mastery of two tenets for effective competitiveness, those being productivity and ability of the economy to compete. Linked to US’s average living standards, productivity measures how the economy ‘obtains goods and services of value from labor and capital inputs it provides’ (Baily & Slaughter, 2008). Equally important, US’s ability of its economy to compete in international trade is measured by the continued maintenance of Americans’ high standard of living by building an economy on the foundation of high-productivity firms. Aside from today’s economic crisis, if US wants to get over this financial hump it may behoove it to consult with its private sector strategic partners towards developing regulatory reforms that do not undermine innovation and hampers competitiveness but rather establishes sound structural policies that account for sensitivities of global trade with trading nations, global security, and managing the delicate value of our current depreciated US dollar that currently has boosted the global competitiveness of many American companies and has created a unique opportunity to expand investment, increase skills, and add employment.
Reference: Baily, Martin N. and Slaughter Mathew J. (2008). Strengthening U.S. Competitiveness in the Global Economy. Published by Private Equity Council. Retrieved from http://www.pegcc.org/wordpress/wp-content/uploads/pec_wp_strengthening_
120908a.pdf.
•Identify any gaps you have observed in international trade policies during this course. Explain what U.S. government agency you would contact to address the gap and what recommendation you would make.
With the quickly evolving and complex business dynamics of global supply chain, multimodal transportation, third party logistics (3PL), and cultural or political contrasting agendas in play between trading countries, the private sector finds itself sometimes tied up in diplomatic incongruences with its trading nations that pose catastrophic delays and unexpected costs in that firm’s efforts to effect their mission by them being forced to deviate or delay already synchronized multifaceted logistical coordinated plans of which one of the transshipment part depends on the timely delivery of the other. Case in point, a US based Chinese Broadway musical, due to its political message to the US audience, has strained relationship with China and continuously faces insurmountable challenges in keeping tailors and clothing manufacturing suppliers from Hong Kong because of the communist oppression pressed on manufacturers supporting this Broadway company from sharing its liberal views on the oppressive nature of the Chinese communist government. An international trade policy that is sensitive to the political and cultural impact of a trading nation has on our US based firm’s ability to import and facilitates the cooperation of both trading nations needs to be created to avoid these similar obstacles to global trade. Agencies that can facilitate in the development of such policies could include the US embassy to the trading nation, CBP, Department of State, International Transport Workers Federation, and US Department of Homeland Security. The collective pre-emptive effort to have a policy that has eyes on this diplomatic and cultural aspect of trading as plans are developed to initiate trade with other countries will save us cost, time, and increase the trust of the private firms on the US governments’ vested interest to facilitate the enablers in place to increase a smoother global trade experience and engenders a spirit of cooperation from all vested parties.
Question 4
“Looking Ahead” Please respond to the following:
• As international regulations and restrictions have increased significantly since 9/11, speculate how the import / export activities in the U.S. will either increase or decrease over the next 10 years. Explain your rationale.
I believe that import activities will increase and export activities will remain about constant. As the U.S. continues to outsource and become more reliant on foreign countries such as China and India importing of goods from these countries will increase with the reliance. I feel that export activities will remain constant because companies will continue to export but going global still presents challenges to businesses. Hopefully as technological advances continue the process will become more attractive to businesses.
• Identify any gaps you have observed in international trade policies during this course. Explain what U.S. government agency you would contact to address the gap and what recommendation you would make.
I feel that the CBP needs to take advantage of technology available. Using technology will lessen the human error and will increase efficiency.

The standard DECISION-TREE-LEARNING algorithm described in the chapter does not handle cases in…

The standard DECISION-TREE-LEARNING algorithm described in the chapter does not handle cases in which some examples have missing attribute values.

a. First, we need to find a way to classify such examples, given a decision tree thal. includes tests on the attributes for which values can be missing. Suppose that an example X has a missing value for attribute A and that the decision tree tests for A at a node that X reaches. One way to handle this case is to pretend that the example has all possible values for the attribute, but to weight each value according to its frequency among all of the examples that reach that node in the decision tree. The classification algorithm should follow all branches at any node for which a~ value is missing and should multiply the weights along each path. Write a modified classifical-ion algorithm for decision trees that has this behavior.

b. Now modify the information gain calculation so .that in arry given collection of examples C at a given node in the tree during the construction process, the examples with missing values for any of the remaining attributes are given “as-if” values according to the frequencies of those values in the set C.

 

1. Motivational Theories ExerciseReview the different motivational theories in Chapter 2 and address

1. Motivational Theories ExerciseReview the different motivational theories in Chapter 2 and address each of the following assignment requirements:Choose three motivational theories and write a brief summary about each one.Write a brief analysis in which you compare and contrast these three theories.Explain how managers can use motivation theories to motivate employees.The completed assignment should be at least 1 page.2.Your personal characteristics influence your perceptions, attitudes, and interpersonal behavior. This assignment will help you determine your individual personality type to help guide your interactions with others:Complete Question 2 of “Check your Understanding†on page 109.Take at least two of the personality tests located at Queendom (Links to an external site.).Write a paper in which you address the following prompts: Summarize the results of each test and explain what your strongest and weakest traits are.Compare and contrast the results from the two personality tests. Do they contradict or confirm one another?How can knowing one’s personality type affect how they work with others?How can it help improve one’s leadership skills?The completed assignment should be at least 1 page.BookHegar, K. W. (2012). Modern human relations at work (11th ed.). Mason, OH: South-Western.

The word acid is often associated with danger and corrosiveness. Explain, using examples, whether…

The word acid is often associated with danger and corrosiveness. Explain, using examples, whether all acids are dangerous and whether it is only concentrated acids that are dangerous.