-

Business intelligence can detect fraudlant practise in finance, banking, Insurance etc

Select one:

a. True

b. False

2-

A spreadsheet is a computer application for organization, analysis and storage of data in tabular form.

Select one:

a. True

b. False

3-

Business Intelligence system is used by higher level of management in strategic decision making.

Select one:

a. True

b. False

4-

Which of the following is not a type of information system?

Select one:

a. Management Information System

b. Transaction Processing system

c. Operating System

d. Decision support system

5-

During extraction, the desired data is identified and extracted from many different sources, including

Select one:

a. Database systems and applications

b. Business and operating systems

c. Operating system and Application

An insurance company found that 25% of all insurance policies are terminated before their maturity date. Assume that 10 polices are randomly selected from the company’s policy database. Out of the 10 randomly selected policies;

a) What is the expected number of policies to be terminated before maturing? [1]

b) What is the standard deviation for the number of policies terminated before maturity? [1]

c) What is the probability that no policy will be terminated before maturity? [1]

d) What is the probability that all policies will be terminated before maturing? [2]

e) What is the probability that at least two policies will be terminated? [3]

f) What is the probability that more than 5 but less than eight policies will be terminated? [3] g) What is the probability that at most eight policies will be terminated? [3]

E10-4 Finding Unknowns Using Return on Investment, Profit Margin, Investment Turnover [LO 10-4]

Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements including components of the return on investment calculations.   


Required:
Help Krall rebuild its information database by completing the following table: (Do not round your intermediate calculations. Round your final answers to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.))  

4. Give three examples of items that would be included in the Interface Tier.

5. Give three examples of items that would not be included in the Interface Tier.

6. Can some program code exist in the Interface Tier? If so, what tasks does this code provide?

7. What tasks can Business Rule Tier code accomplish that is similar to a task accomplished by code in the Interface Tier? Why is this code possibility duplicated in both tiers?

8. How does the Business Rules Tier pass and receive data (information)?

13. When must you convert numbers to a numeric form (such as Integer) for storage within a database?

14. Why use datasets to pass information between tiers?

15. What items have been missed or ignored in the case example?

Every answer shown for this question appears to be giving an error message or locking the database or telling me there is an operational error or undefined parameter of some sort. Here is the question. This is for Python3

Define the Artist class in Artist.py with a constructor to initialize an artist's information. The constructor should by default initialize the artist's name to "None" and the years of birth and death to 0.

Define the Artwork class in Artwork.py with a constructor to initialize an artwork's information. The constructor should by default initialize the title to "None", the year created to 0, and the artist to use the Artist default constructor parameter values. Add an import statement to import the Artist class.

Add import statements to main.py to import the Artist and Artwork classes.

if this is input:

Pablo Picasso

1881

1973

Three Musicians

1921

what is output

1.What standard methods can you use when handling file-reading and file-writing operations?

a. Java

b. Fragment-based methods

c. onClick

d. DDMS

2. What would this query return? SELECT * FROM Items WHERE OrderDate >= Date('Now')

a. All items in the database.

b. Nothing

c. Items that were ordered yesterday

d. Items that were ordered today.

3. What can you use to manage files within a desired directory and create subdirectories?

a. Subdirectory objects

b. Directory class

c. File objects

d. Context class

4. What class can you use to access external storage on the device?

a. The Fragment class

b. The Environment class

c. The External class

d. The Log class

1. Given the tables: SKU_DATA (SKU, SKU_Description, Department, Buyer)

WAREHOUSE (WarehouseID, WarehouseCity, WarehouseState, Manager, Squarefeet)

INVENTORY (WarehouseID, SKU, SKU_Description, QuantityOnHand, QuantityOnOrder)

1. Write an SQL statement to display SKU and SKU_Description.
2. Write an SQL statement to display the SKU, SKU_Description, and WarehouseID for products having QuantityOnHand greater than 0. Sort the results in descending order by WarehouseID and ascending order by SKU.
3. Write an SQL statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState for all items stored in the Atlanta, Bangor, or Chicago warehouse
4. Write an SQL statement to show the SKU, SKU_Description, WarehouseID for all items stored in a warehouse managed by ‘Lucille Smith’. Use a subquery
5. Write an SQL statement to show the WarehouseID and average QuantityOnHand of all items stored in a warehouse managed by ‘Lucille Smith’.

All for MYSQL Database

An employment agency needs to convert its basic one-table management system into a modern information management system/database that can hold its improving business. You are hired to create this IMS and the first step you are carrying out is normalization. The table that the agency originally uses is the following:

APPLICATION(ApplicantName, AppicantPhone1, ApplicantPhone2, ApplicantAddress, ApplicantFieldOfInterest, ApplicanHighestLevelOfEducation, EmployerBusinessName, EmployerAddress, EmployerPhoneNumber, EmployerCity, EmployerEmail, JobPostingID, JobPostingTitle, JobYearlySalary, InterviewId, InterviewDate, NamesOfInterviewers, OfferDetailsIfApplicable)

Rules:

- Applicants can be identified by their phone number(s)

- No two employers can have the same name

- Employers can post more than 1 posting

- Applicant can apply for more than one posting

You are required to put the previous table in 4NF (step-by-step: 1NF, 2NF, 3NF and 4NF).

Background

Couples Resorts include four all-inclusive Jamaican properties in the beautiful Caribbean. Relatively new to the online marketing, they elicited the help of UNLV hospitality department to take them to the next level through online marketing and more specifically in this case, social media.

Problem and Goals

A lack of recent usage of their social media channels left their followers unengaged. The goal here is to engage current brand advocates (past and future guests) on their Facebook page as well as to expand their customer database.

The resources:

1. A contact list of existing customers (home address and email address)
2. A marketing budget of max $15,000.

Here are the questions:

1. What will be your strategy? Outline your plan to help Couples Resorts?
2. How will you measure the effectiveness of your strategy?

Misha Enterprises, a rapidly growing call center in Northeast Michigan, services clients across the United States. Businesses contract with Misha to provide external outbound calls in the following areas: customer satisfaction surveys, marketing research surveys, and fundraising for non-profit organizations. Misha was established in 1992 by Anela Ainsley, who founded the business in her basement. It expanded rapidly and moved to its current location in 1997. Fortunately, because of its niche market and responsiveness to its customer base, Misha has not been negatively impacted by the current trend of outsourcing call center activities to international companies.

Middle Management Turnover

Misha uses a part-time, multi-shift hourly workforce for outbound calling. Misha has had good success hiring its hourly workforce. Both name recognition and its status as one of a handful of employers in the area has created a candidate pool of hourly workers who have a tendency to remain in their positions for a long time.

But Misha has not been as successful hiring call center managers. The company requires its managers to be degreed professionals with call center experience, but the nearest university is 150 miles away. As a result, Misha usually recruits candidates from larger cities who desire a rural lifestyle, as well as Misha employees who left the area to complete a bachelors degree and have since returned to the area.

The call center is managed by Chauncey LaBrad, the general manager, who is skilled at selling contracts and gaining new business. He's also responsible for all profit and loss and cash flow for Misha, as well as overseeing operations. He reports directly to the owner, Anela, with whom he has worked for more than 10 years.

The two call center managers, Helen Kenjor and Linda Kamis, report directly to Chauncey. Turnover is high for this call center management position. Chauncey has told Anela that he thinks the requirements for a bachelors degree and call center experience are unnecessary for the position. In fact, he has told Anela, “If I knew Helen was working on her MBA, I never would have hired her.”

Anela has decided to enter into other business ventures and dedicate more of her time to racing horses, so she is frequently out of the office. She founded the organization on the principals of providing a high level of service to clients while remaining profitable, and when she was in the office daily, Misha retained a growth of 10% per year. Under Chauncey’s direction, however,

Misha is growing at just 2% per year. Worse yet, in addition to having trouble retaining call center managers, Chauncey also is unable to retain sales employees.

Skill Disparities

Over the years, Misha has had to hire additional employees as the organization has grown. In addition to hiring more help, the company has invested in technology with predictive dialers and a sales database that is both a customer service management tool for tracking contacts and preferences, and a statistical reporting tool. While Misha’s managers can operate the sales software, some of its tenured employees struggle with it. Admittedly, Misha brought the software when it was recruiting a new call center manager, so the training was not as thorough as originally planned. As a result, the tenured employees have exceptional customer service experience but are unable to log information in the database accurately. They remember client preferences and characteristics by making personal, handwritten notes.

This customer information is not shared with other employees, which has been problematic, but not disastrous. The tenured employees have a tendency to share their notes with each other, but do not share with employees who were hired within the past three years. This occurs because they simply have not formed strong relationships with the newer employees. Because they remain connected to a headset all day, talking to clients, they have little time to socialize with their colleagues like they did back in the day when they were manually dialing the phone.

The newly hired employees are more technically savvy and have taken ownership of learning the database software. They see the value in the software and keep all of their notes in the database. They are able to pull reports to help them manage their time and can calculate their bonus potential on a real-time basis, which keeps them motivated. These employees have established an instantaneous competency in system utilization despite the fact that they have had no training. But while these employees have exceptional software competencies, they lack customer service experience.

An example of their deficient customer service skills was recently brought to light when a newly- hired employee, who was soliciting donations, told a telemarketing prospect:

Unfortunately, I do not have the time to listen to the story about your child’s first day of school. I have to make more calls because my job is on the line if I do not make 50 calls by the end of the evening. I am sure you understand. Did you want to renew your contribution of $100 from last year?

While this employee received appropriate disciplinary action, the exchange is indicative of the type of customer service problems that exist among the employees who were hired during the past three years.

Write a letter in block format or a memo (select the correct format, per BCOM) and address it to Anela Ainsley. (This should not be a recap of your team meeting or a letter to me.) In the document, provide a brief description of the problems. Identify the facts and discuss the key problems. Consider the following before making recommendations:

· How should Anela Ainsley handle the managerial employee turnover problem? On what do you base this suggestion?

· How would you design training, and how would you test whether the training was successful, considering the disparity of skills in the workforce?

· What can be done to help the employees build rapport so the “tenured” vs. “newly hired” divisions are less obvious?

In the closing cite the benefits of your recommendations in a succinct, truthful and tactful manner. Also keep in mind that since you are consulting, you wish to land future business from Misha Enterprises. So be sure to establish your credibility for future projects through your skillful analysis and solutions.