Questions
Your company maintains a database with information on your customers, and you are interested in analyzing...

Your company maintains a database with information on your customers, and you
are interested in analyzing patters observed over the past quarter. 23% of customer
in the database placed new orders within this period. However, for those customers
who had a salesperson assigned to them, the new order rate was 58%. Overall, 14%
of customers within the database had salesperson assigned to them.
a) Draw a contingency table for this situation.
b) What percentage of customers in the database placed a new order but did not
have a salesperson assigned to them.
c) Given that a customer did not place a new order, what is the probability that the
customer had a salesperson assigned to him or her?
d) If a customer did not have a salesperson assigned to him or her, what is the
probability that the customer placed a new order?

In: Computer Science

PartA: Create the database. Name the database doctorWho. Then create a page that allows Doctor Who’s...

PartA: Create the database. Name the database doctorWho. Then create a page that allows Doctor Who’s assistant to add a new patient record. You will need to give the assistant rights to this database. The assistant’s username is 'helper' and the password is 'feelBetter'. For this to work, you will need to create several pages so be sure to include all of them when submitting your work. Name the main page addPatient.php.

PartB: Add at least five records to the patient's table in the doctorWho database you created in PartA. Now create a page that will display three or more fields from each of these records. The display should consist of, at a minimum, the patient’s first and last names, and a unique identifier. Name the page getPatient.php and be sure to include the necessary accompanying files when you submit your work.

In: Computer Science

Case Study 3.2: A Large Retail Bank: Reducing the Complexity of Changing an Address (Gold-Bernstein, Beth,...

Case Study 3.2: A Large Retail Bank: Reducing the Complexity of Changing an Address
(Gold-Bernstein, Beth, and William Ruh. Enterprise integration: the essential guide to integration solutions. Addison Wesley Longman Publishing Co., Inc., 2004. Page 42)

Situation
Throughout the 1990s, the strategy of the leading retail banks was to grow through acquisition. Many regional banks disappeared during this time, swallowed up into larger institutions. During this process, many of these banks ended up with a diversity of information systems. It is not uncommon even today to find 30, 40, or even 50 systems that contain customer information. Checking, savings, personal loans, auto loans, mortgages, credit cards, and every other product provided by the bank would have a separate information system. During acquisitions there would be several systems supporting each product. As a result, getting a single view of a customer was not possible. Furthermore, just changing an address could be a long and dreary process to any bank who maintained several business relationships with a client. Checking and savings information might be changed, but mortgages would require a different process for changing address. This is a perplexing experience to banking customers. Why should something as simple as a change of address require a complex set of actions on their part to get it right? Customer service representatives for the bank could only forward the customer to the next department for service. In one case, a large bank in the southeast had over 30 systems where customers' address information might be contained. When a client had more than two products he or she would be forced to deal with different parts of the bank to get his or her address correct. Inside of the IT organization, each system would have thousands of lines of code (LOC) to manage and update a change of address. This would include the user interface for input, the verification and validation of the information, and the actual update to the database. The update was the smallest portion of the code and usually less than a hundred lines. In this organization there were over 150,000 lines of code associated with changing an address across well over 30 systems—none of it integrated and all of it maintained. Not only were customers not happy, but the cost of the code involved was high. This situation exists in many forms in most large organizations.
Solution
Through a strategy of improving customer service including change of address, a single service was developed to manage the update to all systems with less than 15,000 LOC, and it provided improved customer support.
Impact
The business integration strategy led to higher customer satisfaction, reduced complexity and cost of maintenance, and made future integration easier. An application such as this can be a big win for any organization and it demonstrates the value of the business integration strategy.
Task
Read the above case and answer the following:
1. Identify key problems and describe their impact on business productivity and customer satisfaction.
2. Explain Integration and identify how it would help this situation.
3. The solution indicates that “a single service was developed”. What type of integration would this be?

In: Economics

Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient,...

Database exercise: inpatient cases

  • Create database using name RUMKIT
  • Create tables below in that database
  • patient(idPatient, fullName, biologicalMother, birthdate, address)
  • doctor(idDr, fullName, specialization, consulRates)
  • inpatient(idPatient, entryTime, outTime, idDr, idRoom). Please make entryTime as column that is going to be filled automatically when care record is being add
  • room(idRoom, roomName, cost)
  • fill the data above to each table
  • Create sql query and relational algebra expressions for the query

Please give me detailed answer so I could learn from it. Thank you very much

In: Computer Science

Select a software system and / or a device that you are familiar with that either allows or requires the system’s software to be updated.

"Software and System Updates" Please respond to the following:

Select a software system and / or a device that you are familiar with that either allows or requires the system’s software to be updated. This system could be specific software that sets on top of an operating system, the operating system itself, a mobile device, or video game consoles. Discuss how the update was applied to the system and describe the changes that the system / software update provided. In addition, give your opinion on whether or not you believe the system updates are used as a marketing tool.

Use the system you selected in Part 1 of this discussion, speculate the constraints that they may have experienced during the system update process. Provide an alternative solution to deliver updates in a way that overcomes the constraints.

In: Computer Science

For Walmart Inc., find the balance sheet and notes to the financial statements in the fiscal...

For Walmart Inc., find the balance sheet and notes to the financial statements in the fiscal year ended on January 31, 2018 Form 10- K. The Form 10- K can be located by going to the home page of the Securities and Exchange Commission and locating the SEC EDGAR Database. The address for the home page is www. sec. gov. Using the information you find, answer the following questions:

( a) What current assets are included on the balance sheet?

( b) If the company lists accounts receivable and an allowance account, analyze these accounts.

( c) What method does the company use to value inventory?

( d) What depreciation method does the company use?

( e) What assets other than current assets and property, plant, and equipment are included on the balance sheet?

In: Accounting

Visit the EDGAR database. Access the 10-K report for the year ended December 31, 2017, filed...

Visit the EDGAR database. Access the 10-K report for the year ended December 31, 2017, filed on February 23, 2018.

To access this information:
Search SEC.gov Company Filings for McDonald's by entering the ticket information, MCD in the Fast Search box

After reviewing the information, answer the following questions:

1) Review McDonald's balance sheet and identify how many classes of stock it has issued
2) What are the par values, number of authorized shares, and issued shares of the classes of stock you identified in part 1?
3) Review its statement of cash flows and identify what total amount of cash it paid in 2017 to purchase treasury stock
4) What amount did McDonalds pay out in common stock cash dividends for 2017?

In: Accounting

Determine the interest rate (i) that makes the pairs of cash flows below economically equivalent. Year...

Determine the interest rate (i) that makes the pairs of cash flows below economically equivalent.

Year

Pair 1

Pair 2

0

$0

0

1

$2000

$2500

2

$2000

$1875

3

$2000

$1406

4

$2000

$1055

5

$2000

$791

6

$2000

$595

In: Finance

January 1, 2018, Apple is authorized to issue 200,000 shares $1.00 par common stock and 5,000...

January 1, 2018, Apple is authorized to issue 200,000 shares $1.00 par common stock and 5,000 shares $200 par 5% cumulative and non-participating preferred stock. The transactions took place in 2018

Jan 14: issue 5,000 shares of common stock at $17 per share

Feb 2: issue 4,000 shares of preferred stock in exchange for building with a fair market value of $800,000

July 6: Re-purchased 2,000 shares of common stock at $18 per share (cost method)

Aug 15: sold 2,000 of the treasury shares at $19 per share

Dec 31: declared preferred dividends and a common stock dividends of $2.00 per share

Dec 31: close the income summary account ($150,000 of net income)

Prepare Journal entries for each transaction and prepare the statement of changes in OE for the 2018 year end.

In: Accounting

January 1, 2018, a company is authorized to issue 200,000 shares $1.00 par common stock and...

January 1, 2018, a company is authorized to issue 200,000 shares $1.00 par common stock and 5,000 shares $200 par 5% cumulative and non-participating preferred stock. The transactions took place in 2018

Jan 14: issue 5,000 shares of common stock at $17 per share

Feb 2: issue 4,000 shares of preferred stock in exchange for building with a fair market value of $800,000

July 6: Re-purchased 2,000 shares of common stock at $18 per share (cost method)

Aug 15: sold 2,000 of the treasury shares at $19 per share

Dec 31: declared preferred dividends and a common stock dividends of $2.00 per share

Dec 31: close the income summary account ($150,000 of net income)

Prepare Journal entries for each transaction and prepare the statement of changes in OE for the 2018 year end.

In: Accounting