Reference no: EM1371816
You are familiar with Premiere Products database and its set of 3NF relations. A similar company, firm ABC, uses the following set of relations in their database in place of the SLSREP and CUSTOMER tables. (The ORDERS, ORDLNE, and PART tables are the same for both firms.)
ABCSLSREP (SLSRNUMB, SLSRLASTNAME, SLSRFIRSTNAME, SLSRSTREET, SLSRCITY, SLSRSTATE, SLSRZIP, SLSRRATE)
ABCCUSTOMER (CUSTNUMB, CUSTNAME, STREE, CITY, STATE, ZIP, BALANCE, CREDITLIMIT)
ABCSLSCUST (SLSRNUMB, CUSTNUMB, COMMRATE)
For Firm ABC, each of the above relations is in 3NF. What 2 differences must exist in the company policies of Firm ABC? Explain your answer.
|
Determine sales
: David Ding advertises on a local radio station. For last 6-weeks, the manager has kept records of the number of minutes of advertising that were bought, and the sales for that week.
|
|
Calculate confidence and support of rule
: Assume that 30% of science students are majoring in biology. Would you consider to be novel with respect to rule? Describe. Calculate confidence and support of rule.
|
|
Explain barriers to entry and limit pricing
: Assume that, prior to other company's entering the market, the maker of a new smartphone earns $100 million per year. By reducing its price by 50%,
|
|
Determine economically efficient move
: Business Week, in an article dealing with management, wrote, "When he took over furniture factory three years ago. Realized almost immediately that it was throwing away at least $100,000 a year worth of wood scrap.
|
|
Write down differences in company policies of firm
: For Firm ABC, each of the relations is in 3NF. Write down two differences should exist in company policies of Firm ABC? Explain your answer.
|
|
System of fixed wages
: American Linen is a company that has multiple salespersons. In 2008, it changed the compensation method for its sales force, moving from a system of fixed wages to one of base wage plus charge.
|
|
Describe your personal level of comfort with business
: Describe your personal level of comfort with business accounting and computation before and after taking this course and What learning techniques did you use to approach the subject of accounting
|
|
Difference between symmetric and public key system
: What is the most important difference between a symmetric key system and a public key system and in what way does a hash function provide a better message integrity check than a checksum
|
|
Write down steps to browse site ausing same url
: Employees will open their Web browser and enter personnel.mycompany.com in URL address box to browse this Web site. Write down steps which you take so that each computer in company can browse site using this URL?
|