answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Bad White [126]
2 years ago
8

Your industrial supply company wants to create a data warehouse where management can obtain a single corporate-wide view of crit

ical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in several different systems: a divisional sales system running on a Unix server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems. In MyMISLab, you can review the proposed format, along with sample files from the two systems that would supply the data for the data warehouse. Then answer the following questions:
• What business problems are created by not having these data in a single standard format?

• How easy would it be to create a database with a single standard format that could store the data from both systems? Identify the problems that would have to be addressed.

• Should the problems be solved by database specialists or general business managers? Explain.

• Who should have the authority to finalize a single company-wide format for this information in the data warehouse?
Business
1 answer:
antoniya [11.8K]2 years ago
6 0

Answer:

Industrial supply company scenario:

  • The company wants to create a data warehouse where management can obtain a single corporate-wide view of critical sales information to identify best-selling products in specific geographic areas, key customers, and sales trends.
  • The sales and product information are stored in both a divisional sales system running on a Unix server and a corporate sales system running on an IBM mainframe.
  • The desire is to create a single standard format that consolidates these data from both systems.

Business problems:

  • A business problem that can arise from not having these data in a single standard format is that employees will see the data as inconsistent.
  • It is difficult to make business decisions if the data is unreliable, inaccurate, or redundant.
  • The product descriptions are formatted differently so managers and employees might get confused when it is entered into the system.
  • Also, the system identifies the sales by territory in the United States so it would be impossible to identify the sales or even around the world.
  • The corporate sales system also lacks a way to identify the identification of the customer.
  • Both sales system should be consistent with the information in order to prevent redundancies or inaccuracies.  

How easy it would be to create a database with a single standard format:

  • Creating a database with a single standard format would ideally be easy.
  • Data quality audits and data cleansing should be performed when constructing the new database.
  • Data quality audits and data cleansing would correct any redundancies and inaccuracies in the current systems.
  • By using data-cleansing software, the company can combine and integrate the data from all the systems into a single standard format that is uniform throughout the whole company.

Problems that should be addressed:

  • A problem that should be addressed is the product description and sales territory tags.
  • These tags have different formats which could lead to inconsistencies in the data.
  • The names would have to be changed so that they are the same format and are only entered once in the new single standard format database.
  • Another problem that would have to be addressed is keeping both the division and customer id tags in the new database.
  • This would provide more information for each entry and would limit any confusion among the employees.

Database specialists:

  • Database specialists will help solve the problems by performing the data quality audits and data cleansing.
  • They will also help in establishing an information policy and developing the new database.
  • They are also responsible for the specific policies and procedures through which data can be managed as an organizational resource.
  • This involves overseeing logical database design and data dictionary development, planning for data, and monitoring how information systems specialists and end-user groups use data.

General business managers:

  • General business managers would have the final say when managing data resources.
  • They would be responsible for defining and organizing the structure and content of the database and maintaining the database.

Who should have the authority?

  • The general business managers should have the authority because they are responsible for the data.
  • This would mean that even though they allow database specialists to establish an information policy and develop the new database, the managers are the ones who have to approve the final product in order for it to be implemented company-wide.
  • The managers are the ones whose reputations are on the line when a company succeeds or fails, so they should have the final authority.

You might be interested in
At the beginning of the month, Bobcat Boards and Skis received $800 in advance for future services to be performed. At the end o
finlep [7]

Answer:

The adjusting entry that should be recorded at the end of the accounting period:

Debit Unearned revenue $500

Credit Revenue $500

Explanation:

Following the Accrual accounting - an accounting method that revenue or expenses are recorded when a transaction occurs rather than when payment is received or made.

Bobcat Boards and Skis received $800 in advance for future services to be performed. At the end of the month, $300 worth of services were still owed to the customer.

The value of services were performed = $800 - $300 = $500.

The adjusting entry:

Debit Unearned revenue $500

Credit Revenue $500

6 0
2 years ago
Síntesis interview a classmate about his or her pastimes, weekend activities, and favorite sports. use these questions as guidel
steposvetlana [31]
<span>) Imagine you have a friend who lives in an exciting place you have never visited: New York City, Ciudad de Mexico, etc. You are about to visit your friend for the first time, you are excited and have many things you want to do, but also have a lot of questions. On a sheet of paper, write a letter to your friend to prepare for your trip. </span>
4 0
1 year ago
Read 2 more answers
In a business environment, persuasion is critical to success. Persuasion is necessary when you anticipate resistance or when you
wariber [46]

Answer:

The correct answers are:  

(C) Anticipate objections: A person who persuades correctly and with ethics can anticipate the objections or doubts that people who are subject to persuasion have in order to effectively answer any questions they may have and  be able to make the deal effective.

(D) It generates interest: It generates interest because at that time it usually creates a need for the person who does not have or who mainly does not know he does not have.  

(E) Ask for a particular and easy action to take: In general, persuasion, as it is a created need, is easier to create small and easy-to-execute actions so that persuasion work is effective because if the person who is doing the work does it with larger actions, it is likely that it will not capture the attention of the person with whom it is being done, emphasizing that these actions should always be done considering the ethical principles of a company and society.

6 0
2 years ago
In your own words, briefly describe the benefit of each type of alert below: a. Low Balance b. Mobile Deposit c. Unusual Activit
pshichka [43]

Answer:

Explanation:

a. Low Balance: You can set up your bank account for this alert on a threshold which you want to make. This alert inform you about the low balance in your bank account when it touches to the threshold you set up that may be any amount for example 50$ or 500$ or 1000$ so that you know that you shouldn't . It facilitate you to safe from the expenses like OD etc.

b. Mobile Deposit. You always receive a text message whenever you used your smartphone to deposit the check with it. It may be act as a receipt for the check submission while using with your smartphone.It also provide you a facilitation when the check is cleared and deposit received in your bank account

c. Unusual Activity. This type of alert message received while bank detects an unusual activity which could be fraud etc.For example the transactions which are made unusual and which may not be your regular activity with your account.It could also occur when your account transaction has been made outside of your normal living etc area

2.

The most important type of alert would be the Unusual Activity as it involves the risk more that other two alerts.

5 0
1 year ago
The business of renting specialized construction equipment is highly competitive. In 2010, your company, Franklin Property Group
son4ous [18]

Answer:

o identify the reasons for switching of clients to B&S , we shall first examine our weaknesses and loopholes toward the valuable clients. It will give us some basics like pricing policies, benefits to the clients, strongest part of our immediate competitor, style of our services team and managers etc.

After knowing the possible reasons of customers switching to other business, i will start improving our offerings. I will make a team of client service officers who will carefully contact the existing as well as older clients and make them assure to reorder with our business as our offerings have more advantages to them. We shall offer them cost advantage, product's increased benefits, revival of their plans and requirements and door step delivery and 24×7 hours services. I will give competitive discounts on bulk order . Even , we shall give them better credit facilities which will attract more clients to associate with our offerings.

I think that clients will again back for our products and services . We shall welcome them again with improved products and services. I hope that the sales turnover and market share of our organization will increase day by day with respect to our immediate competitor.

4 0
2 years ago
Other questions:
  • Julie boss Sandra wants to have a word with her. She finds that Julie has stepped out for lunch , so she leaves Julie a _____ on
    7·2 answers
  • What are some tasks commonly performed in Plant Systems jobs? Check all that apply.
    15·2 answers
  • In early January 2020, Southland Growers began construction of a new, fully automated citrus processing plant. The plant was fin
    10·1 answer
  • Anastasia was trying to decide which investment plan would be best over 10 years. Bank A was offering 8.5% simple interest on he
    6·1 answer
  • Cashier's checks Checks Question 5 0/1 pts If Sid Inc. has net sales of $750,000, sales on account of $600,000, and sales return
    5·1 answer
  • The Southern Division of Barstol Company makes and sells a single product, which is a part used in manufacturing trucks. The ann
    9·1 answer
  • Barkley Company has a piece of equipment that it has been depreciating for 3 years. The equipment originally was estimated to ha
    6·1 answer
  • 2. Demand for Riana's product in the U.S. is inconsistent. When orders are slow, she sometimes needs to shut down production to
    7·1 answer
  • Presented below is a combined single-step income and retained earnings statement for Hardrock Mining Co. for 2017.
    12·1 answer
  • Corona Industries purchased a stamping machine on January 2, 20X1, for $100,000. It made an initial payment of $20,000 and finan
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!