1answer.
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]
3 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]3 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
A seller hired broker N under the terms of an open listing. While that listing was still in effect, the seller without informing
ludmilkaskok [199]

Answer:

commission to both brokers N and K.

Explanation:

Broker N is entitled to a sales commission because he/she sold the property. But broker K is also entitled to a commission because an exclusive right-to-sell agreement allows him/her to collect a commission no matter who sells the property. The only exception to the agreement would be if the seller himself/herself sold the property, but that is not the case here.

4 0
3 years ago
What’s behind gas prices
MArishka [77]

Answer:

taxes

Explanation:

there is federal, state, and government taxes included in your gas price

hope this helps :)

3 0
2 years ago
Read 2 more answers
Easywriter manufactures an erasable ballpoint pen, which sells for $1.75 per unit. management recently finished analyzing the re
maxonik [38]

a. 50 cents

Contribution margin per unit is price per unit- variable cost per unit

1.75 - ($50,000/40,000 units)

1.75 - 1.25 = $ .50

b. $8750

Margin of safety is the expected sales - break even sales

(45,000 units * $1.75 per unit) - (40,000 *1.75)

78,750 - 70,000 = $8750

6 0
3 years ago
Larkspur University sells 4,800 season basketball tickets at $60 each for the entire 15-game home schedule. (a) Give the entry t
snow_tiger [21]

Answer:

The Journal entry is as follows:

Cash A/c                    Dr. $288,000

To Unearned basketball ticket revenue A/c     $288,000

(To record the sale of the season tickets)

Workings:

Given that,

Total number of tickets sold = 4,800

Selling price of ticket = $60 each

Cash = season basketball tickets sold × Selling price of each ticket

        =  4,800 tickets × $60 per ticket

        = $288,000

5 0
2 years ago
. What do you understand by term “advertising”. What would happen if ethical advertisement is not followed by businesses? Explai
Blababa [14]

Answer:

Ethics means a set of moral principles which govern a person’s behavior or how the activity is conducted. And advertising means a mode of communication between a seller and a buyer.

Thus ethics in advertising means a set of well defined principles which govern the ways of communication taking place between the seller and the buyer. Ethics is the most important feature of the advertising industry. Though there are many benefits of advertising but then there are some points which don’t match the ethical norms of advertising.

An ethical ad is the one which doesn’t lie, doesn’t make fake or false claims and is in the limit of decency.

Nowadays, ads are more exaggerated and a lot of puffing is used. It seems like the advertisers lack knowledge of ethical norms and principles. They just don’t understand and are unable to decide what is correct and what is wrong.

The main area of interest for advertisers is to increase their sales, gain more and more customers, and increase the demand for the product by presenting a well decorated, puffed and colorful ad. They claim that their product is the best, having unique qualities than the competitors, more cost effective, and more beneficial. But most of these ads are found to be false, misleading customers and unethical. The best example of these types of ads is the one which shows evening snacks for the kids, they use coloring and gluing to make the product look glossy and attractive to the consumers who are watching the ads on television and convince them to buy the product without giving a second thought.

<em>Ethics in Advertising is directly related to the purpose of advertising and the nature of advertising. Sometimes exaggerating the ad becomes necessary to prove the benefit of the product. For e.g. a sanitary napkin ad which shows that when the napkin was dropped in a river by some girls, the napkin soaked whole water of the river. Thus, the purpose of advertising was only to inform women about the product quality. Obviously, every woman knows that this cannot practically happen but the ad was accepted. This doesn’t show that the ad was unethical. </em>

Ethics also depends on what we believe. If the advertisers make the ads on the belief that the customers will understand, persuade them to think, and then act on their ads, then this will lead to positive results and the ad may not be called unethical. But at the same time, if advertisers believe that they can fool their customers by showing any impractical things like just clicking fingers will make your home or office fully furnished or just buying a lottery ticket will make you a millionaire, then this is not going to work out for them and will be called as unethical.

Recently, the Vetican issued an article which says ads should follow three moral principles - Truthfulness, Social Responsibility and Upholding Human Dignity.

Generally, big companies never lie as they have to prove their points to various ad regulating bodies. Truth is always said but not completely. Sometimes its better not to reveal the whole truth in the ad but at times truth has to be shown for betterment.

Pharmaceutical Advertising - they help creating awareness, but one catchy point here is that the advertisers show what the medicine can cure but never talk about the side effects of that same thing or the risks involved in intake of it.

Children - children are the major sellers of the ads and the product. They have the power to convince the buyers. But when advertisers are using children in their ad, they should remember not to show them alone doing there work on their own like brushing teeth, playing with toys, or infants holding their own milk bottles as everyone knows that no one will leave their kids unattended while doing all these activities. So showing parents also involved in all activities or things being advertised will be more logical.

Alcohol - till today, there hasn’t come any liquor ad which shows anyone drinking the original liquor. They use mineral water and sodas in their advertisements with their brand name. These types of ads are called surrogate ads. These type of ads are totally unethical when liquor ads are totally banned. Even if there are no advertisements for alcohol, people will continue drinking.

Cigarettes and Tobacco - these products should be never advertised as consumption of these things is directly and badly responsible for cancer and other severe health issues. These as are already banned in countries like India, Norway, Thailand, Finland and Singapore.

Ads for social causes - these types of ads are ethical and are accepted by the people. But ads like condoms and contraceptive pills should be limited, as these are sometimes unethical, and are more likely to loose morality and decency at places where there is no educational knowledge about all these products.

(that is same question on my papers)

7 0
2 years ago
Other questions:
  • Owen expects to receive $ 25,000 at the end of next year from a trust fund. If a bank loans money at an interest rate of 7.1 %​,
    10·1 answer
  • State sales tax y is directly proportional to retail price x. an item that sells for 170 dollars has a sales tax of 10.22 dollar
    12·1 answer
  • Nancy and Betty enter into a partnership agreement where they decide to share profits according to the following rules: Nancy an
    14·1 answer
  • When should you begin preparing for an interview?
    10·1 answer
  • Suppose that a local supermarket sells apples and oranges for 50 cents apiece, and at these prices is able to sell 100 apples an
    9·1 answer
  • Sarah opened her last month's bank statement, today, to find she had an ending bank balance according to First Bank of Broad Rip
    12·1 answer
  • What is considered one cause of inflation?
    6·2 answers
  • Corporate Fund started the year with a net asset value of $14.00. By year-end, its NAV equaled $13.20. The fund paid year-end di
    9·1 answer
  • Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars)
    11·1 answer
  • what is the relationship between the securities and exchange chommisison and accounting standard setting in the united states
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!